Hi,<br><br>You've run into the 'one pass query problem' which has an outstanding RFC here:<br><a href="http://mapserver.org/development/rfc/ms-rfc-52.html">http://mapserver.org/development/rfc/ms-rfc-52.html</a><br>
<br>And it will possibly gets implemented for the 6.0 release.<br><br>Best regards,<br><br>Tamas<br><br><br><br><div class="gmail_quote">2009/4/13 Murty Maganti <span dir="ltr"><<a href="mailto:MMaganti@oriongis.com">MMaganti@oriongis.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p>Hi</p>
<p> </p>
<p>I am doing a query on a oracle spatial layers. When I loop
through the result set to retrieve field value, using layerObj.getFeature() method,
it is terribly slow. What I see from the log files is that a separate database
query with unique id column value is fired to oracle for <b>each</b> getFeature
call. This will definitely slows down. If I have 10,000 results, then 10,000
database queries are getting fired to retrieve the field values. Is there is a
way to avoid this. Is there any setting or API that will prevent so many separate
queries fired and retrieve field values with first query itself. </p>
<p> </p>
<p>Thanks</p>
<p>Murty</p>
<p> </p>
<p> </p>
</div>
</div>
<br>_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
<br></blockquote></div><br>