[TinyOWS-users] Tinyows on a huge table

Rahkonen Jukka Jukka.Rahkonen at mmmtike.fi
Fri Feb 3 09:56:06 EST 2012


If you have not set  estimated_extent="1" then have a try.

estimated_extent        Optional        Flag to indicate if TinyOWS should use estimated_extent (faster but less accurate). Default is 0

-Jukka Rahkonen-

Andrea Peri  wrote:

I'm intersect a strange situation.

I' m testing tinyows with a huge DB.
I start adding thre table to the config.xml.
And all go ok.

table1 : a table with 287 record only of geometrytype multipolygon.
table2: a table with 10 records only of geometrytype multipolygon.
table3: a table with 5.185.512 record of geometrytype polygon.

Until now all is ok. When I open my client wfs I receive correctly the list of layers available.

I notice a little more time to respond when add the third table to config.xm, but all seem acceptable.

After this I add a fourth table (table4)

The fourth table has 17.077.038 records of geometrytype linestring.

Now tinyows go in trouble.

when I try to ask the getcapabilities from my client wfs it never respond and after some time I receive this error
on my client WFS.
"invalid name for processing instruction"

After this , I remove from config.xml file the table3 and leave the table4 .
so the list in config.xml is
and retry to ask the getcapabilities.

Now it respond and the list was returned to my client wfs.

After this if i retry to re-add the table3.

So the list is


and again the tinyows go in error.

So I guess the tiny has some trouble when the tables has many records.

There is some setting to avoid this or to increment the limit for tinyows ?


Andrea Peri
. . . . . . . . .
qwerty àèìòù

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/tinyows-users/attachments/20120203/1344d838/attachment.htm 

More information about the TinyOWS-users mailing list