Performance with oraclespatial using ogr

[Bart van den Eijnden]

Hi,

see:
http://mapserver.gis.umn.edu/data2/wilma/mapserver-users/0404/msg00215.html

in short, only by using DATA "tablename" the bbox is used in the query.

Best regards,
Bart

> Hi all,
>
> I have some oracle layers in my map to which I connect using ogr. I use
> ogr because I also make selections on this layer. Everything performs very
> well until the Oracle table gets too many records. As soon as it has more
> than 10,000 records it can take up to a few minutes to make the map.
> Selecting a polygon from this layer takes even more time and selecting n
> polygons can take more than 5 minutes.
>
> My data parameter is looks like this.
>
>   CONNECTIONTYPE ogr
>   CONNECTION "oci: a/b at c"
>   DATA "SELECT GEOM, LOCATIE_ID FROM LOCATIE where LOCATIESOORT_ID = 10"
>
> Is there anyway I can improve performance changing this query or other
> parameters?
>
> Thanks,
>
> Merlijn
>