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

[Ivan Lucena]

Hi Bob,

The OCILIB is a great wrapper over the OCI but even Oracle has a great wrapper over OCI, it is called OCCI. 

Those wrapper make it easier to develop code against Oracle OCI but I believe that there is no specific concern in LOB access performance and that is what we need. That would requires deep understand of pure OCI interface calls.

I would encourage Giovanni, if he is interested, to also take a look at FDO ".h" style OCI wrapper and Terralib OCI wrapper for some ideas. Well, and of course, the GeoRaster driver "oci_wrapper.cpp/.h", also used by LibLAS.org. Those are wrappers developed for Spatial data.

Regards,

Ivan


>  -------Original Message-------
>  From: Moskovitz, Bob <Bob.Moskovitz at conservation.ca.gov>
>  To: G. Allegri <giohappy at gmail.com>, Ivan Lucena <ivan.lucena at pmldnet.com>
>  Cc: gdal-dev at lists.osgeo.org
>  Subject: RE: [gdal-dev] why ogr oracle connection is so slow?
>  Sent: Feb 26 '10 12:50
>  
>  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
>