Hi,<br><br>I'm intersect a strange situation.<br><br>I' m testing tinyows with a huge DB.<br>I start adding thre table to the config.xml.<br>And all go ok.<br><br>table1 : a table with 287 record only of geometrytype multipolygon.<br>
table2: a table with 10 records only of geometrytype multipolygon.<br>table3: a table with 5.185.512 record of geometrytype polygon.<br><br>Until now all is ok. When I open my client wfs I receive correctly the list of layers available.<br>
<br>I notice a little more time to respond when add the third table to config.xm, but all seem acceptable.<br><br>After this I add a fourth table (table4)<br><br>The fourth table has 17.077.038 records of geometrytype linestring.<br>
<br>Now tinyows go in trouble.<br><br>when I try to ask the getcapabilities from my client wfs it never respond and after some time I receive this error<br>on my client WFS.<br>"invalid name for processing instruction"<br>
<br>After this , I remove from config.xml file the table3 and leave the table4 .<br>so the list in config.xml is<br>table1, <br>table2, <br>table4<br>and retry to ask the getcapabilities.<br><br>Now it respond and the list was returned to my client wfs.<br>
<br>After this if i retry to re-add the table3.<br><br>So the list is <br><br>table1, <br>table2, <br>table4, <br>table3<br><br>and again the tinyows go in error.<br><br>So I guess the tiny has some trouble when the tables has many records.<br>
<br>There is some setting to avoid this or to increment the limit for tinyows ?<br><br>thx,<br>
<br><br>-- <br>-----------------<br>Andrea Peri<br>. . . . . . . . . <br>qwerty אטלעש<br>-----------------<br><br>