UMN - Oracle Spatial

[Bart van den Eijnden (OSGIS)]

Mapserver queries Oracle row by row (fetch by id). This works fine for
shapefiles but not for database sources.

For maps it should be reasonably fast enough on Oracle Spatial, but for
queries it is not, at least that's my experience. It also depends on the
size of the result set ofcourse.

If I need heavy queries, I tend to go for Geoserver instead.

Best regards,
Bart

--
Bart van den Eijnden
OSGIS, Open Source GIS
http://www.osgis.nl


--------- Oorspronkelijk bericht --------
Van: Pleyer, Walter <Walter.Pleyer at LFRZ.AT>
Naar: MAPSERVER-USERS at LISTS.UMN.EDU <MAPSERVER-USERS at LISTS.UMN.EDU>
Onderwerp: [UMN_MAPSERVER-USERS] UMN - Oracle Spatial
Datum: 29/01/07 10:37

> Hi folks!
> 
> Do some of you have know how and experince with UMN mapserver and Oracle
> spatial?
> We try to use this combination, but the performance is inacceptably
> slow.
> We are not sure, where the problem lies, but we have hints that make us
> believe, that mapserver may not be using very efficient query, when
> retrieveing data from Oracle spatial.
> 
> Can you confirm that?
> Do you have other information regarding that topic?
> Are there feasible workarounds?
> 
> Thanks
> Walter
> 
> LFRZ
> A-1200 Wien, Dresdner Strasse 89
> Tel:   ++43(1)33 176/421
> Fax:   ++43(1)33 176/999
> Email: walter.pleyer at lfrz.at
> WWW:   http://www.lfrz.at 
> 
>