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

[Moskovitz, Bob]

Speaking of Oracle drivers.  Maybe there is something in orclib (http://orclib.sourceforge.net/ ) that the gdal devs can use to solve the speed problem.  -Bob

-----Original Message-----
From: gdal-dev-bounces at lists.osgeo.org [mailto:gdal-dev-bounces at lists.osgeo.org] On Behalf Of G. Allegri
Sent: Friday, February 26, 2010 9:45 AM
To: Ivan Lucena
Cc: gdal-dev at lists.osgeo.org
Subject: Re: [gdal-dev] why ogr oracle connection is so slow?

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 <ivan.lucena at pmldnet.com>:
> 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
>>
>
_______________________________________________
gdal-dev mailing list
gdal-dev at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev