[mapserver-users] queryByAttributes on oracle spatial layer

[Tamas Szekeres]

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 <MMaganti at oriongis.com>

>  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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090414/8ccb9d0f/attachment.html