Thanks for your replies. I've my pc down for maintanance, so I cannot give you quantitative details at the moment. Anyway, I haven't tested GeoRaster (as I don't have rasters on the db). I've only made read-only tests through ogr2ogr (to export to shapefiles) and the qgis ogr provider. >From the words of Frank I suppose that the driver needs more tuning and optimization for reading... I'm going to read 'Oracle Call Interface Programmer's Guide' and 'Building High Performance Drivers...' [1]
giovanni [1] http://www.oracle.com/technology/tech/oci/pdf/building-best-drivers.v9.pdf 2010/2/26 Ivan Lucena <[email protected]>: > Giovanni, > > Have you tried any GeoRaster read and write on your environment? > > Have you been able to compare the performance of Oracle/GeoRaster in GDAL > against other alternatives? > > The raster driver also uses Oracle's OCI dlls but the performance is balanced > between fast loading and fast reading. > > Regards, > > Ivan > > >> -------Original Message------- >> From: Frank Warmerdam <[email protected]> >> To: G. Allegri <[email protected]> >> Cc: [email protected] >> Subject: Re: [gdal-dev] why ogr oracle connection is so slow? >> Sent: Feb 26 '10 11:39 >> >> G. Allegri wrote: >> > In this period I'm working intensively with Oracle Spatial (on Windows >> > XP), and I've had the occasion to use it from many perspectives: >> > through Gvsig with its jdbc-based connector, ArcGis with the >> > Interoperability Tools, etc. >> > When I've decided to test the ogr driver I've seen it's times slower >> > then any other solution. I see it uses the C api (oci.h), but I'm not >> > capable to debug it to find the bottleneck... >> >> Giovanni, >> >> What use cases is it particularly slow for? I will note that fetching >> records by feature id is very slow with oracle because each fetch is an >> independent SQL query. >> >> In general the Oracle driver read access was not performance tuned as >> the point of the original contract supporting it's development was >> fast data loading. I do not believe the problem is use of OCI. >> >> Best regards, >> -- >> ---------------------------------------+-------------------------------------- >> I set the clouds in motion - turn up | Frank Warmerdam, >> [email protected] >> light and sound - activate the windows | http://pobox.com/~warmerdam >> and watch the world go round - Rush | Geospatial Programmer for Rent >> >> _______________________________________________ >> gdal-dev mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/gdal-dev >> > _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
