Performance with oraclespatial using ogr

[paul]

Hi Merlijn,

You can also make selections with oraclespatial with queries like this:

CONNECTIONTYPE oraclespatial
CONNECTION " a/b at c"
DATA "GEOM, LOCATIE_ID FROM (select * from LOCATIE where LOCATIESOORT_ID =
10)"

Paul.


----- Original Message -----
From: "Merlijn Simonse" <m.simonse at VICREA.NL>
To: <MAPSERVER-USERS at LISTS.UMN.EDU>
Sent: Thursday, November 18, 2004 9:47 AM
Subject: [UMN_MAPSERVER-USERS] Performance with oraclespatial using ogr


> 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
>