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 <[email protected]> > To: G. Allegri <[email protected]>, Ivan Lucena <[email protected]> > Cc: [email protected] > 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: [email protected] > [mailto:[email protected]] On Behalf Of G. Allegri > Sent: Friday, February 26, 2010 9:45 AM > To: Ivan Lucena > Cc: [email protected] > 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 <[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 > _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
