Performance with oraclespatial using og r

[Bart van den Eijnden]

Hi,

I don't know if this will work with views, I never tried. Frank might be
able to comment on this part ...

You could try looking at the 4.4 beta release, as the mapserver query
functions have been implemented in that release by Fernando Simon for the
native Oracle Spatial support.

Best regards,
Bart

> Dear Bart,
>
> I'v tried using DATA "viewname", but I received the following error:
>
> msDrawMap(): Image handling error. Failed to draw layer named
> 'hectometerhok'.
> msOGRFileOpen(): OGR error. GetLayer(LOCATIE10) failed for OGR connection
> `oci: a/b at c'.
>
> I also tried to use DATA "SELECT GEOM FROM LOCATIE" but this does not
> perform any better as with the where clause.
>
> As I my web client isn't a WMS client (yet) I am not using bbox in the map
> request, but mapext instead.
>
> Do you have any other idea to make it use the spatial index?
>
> By making a selection I meant an interactive selection in the map (using
> NQUERY) and not a selection in the where clause as Paul mentioned.
>
>
> Thank and kind regards,
>
> Merlijn
>
>> -----Original Message-----
>> From: bartvde at xs4all.nl [mailto:bartvde at xs4all.nl]
>> Sent: Thursday, November 18, 2004 14:16
>> To: Merlijn Simonse
>> Cc: mapserver-users at LISTS.UMN.EDU
>> Subject: Re: [UMN_MAPSERVER-USERS] Performance with
>> oraclespatial using ogr
>>
>>
>> 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
>>
>
>