<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="MSHTML 8.00.6001.19154">
</head>
<body>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="542185414-03022012">Hi,</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="542185414-03022012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="542185414-03022012">If you have not set estimated_extent="1" then have a try.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="542185414-03022012"></span></font> </div>
<div dir="ltr" align="left"><span class="542185414-03022012">estimated_extentOptionalFlag to indicate if TinyOWS should use estimated_extent (faster but less accurate). Default is
<i>0</i></span></div>
<div> </div>
<div><span class="542185414-03022012"><font color="#0000ff" size="2" face="Arial">-Jukka Rahkonen-</font></span></div>
<div><br>
</div>
<blockquote style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<div dir="ltr" lang="fi" class="OutlookMessageHeader" align="left">
<hr tabindex="-1">
<font size="2" face="Tahoma">Andrea Peri<span class="542185414-03022012"><font color="#0000ff" face="Arial"> wrote:</font></span></font><br>
</div>
<div></div>
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>
</blockquote>
</body>
</html>