Re: [gdal-dev] why ogr oracle connection is so slow?

[Ivan Lucena]

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 <warmerdam at pobox.com>
>  To: G. Allegri <giohappy at gmail.com>
>  Cc: gdal-dev at lists.osgeo.org
>  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, warmerdam at pobox.com
>  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
>  gdal-dev at lists.osgeo.org
>  http://lists.osgeo.org/mailman/listinfo/gdal-dev
>