Hi, You've run into the 'one pass query problem' which has an outstanding RFC here: http://mapserver.org/development/rfc/ms-rfc-52.html
And it will possibly gets implemented for the 6.0 release. Best regards, Tamas 2009/4/13 Murty Maganti <[email protected]> > Hi > > > > 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 *each* 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. > > > > Thanks > > Murty > > > > > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
