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
