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 <[EMAIL PROTECTED]> Naar: [email protected] <[email protected]> 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: [EMAIL PROTECTED] > WWW: http://www.lfrz.at > >
