VB6 Oracle Spatial or Locator OO4O code

I have just uploaded a radically revised and improved VB6 code for accessing Oracle Spatial or Locator.

In revising the code I came to appreciated something the Catholic priest who married my wife and I once said to me: “True scholarship requires leisure”. I have had the lesiure to revise the code and am horrified by what was in the previous code. Though well intentioned, I simply did not have the time to address, in a systematic fashion, all aspects of squeezing the maximum performance out of a set of code to access Sdo_Geometry data in VB6. (I will convert the code to VB.NET but not yet!).

From the history notes of the library here are some highlights:

  • Modified code to bring back in some improvements from PL/SQL port.
  • Added Tolerance Property and ObjectTolerances() function to set its values.
  • included support for min_resolution parameter in Sdo_Filter/FindFirst
  • Overhauled asPoint, asMultiPoint, asPolyline and asPolygon routines to improve readibility and speed
  • Upped default lFetchArrayBufferSize to 524288 bytes
  • Added ObjectTolerances routine to extract sdo_tolerance from XXX_SDO_GEOM_METADATA views
  • Some type and object name changes
  • Modified implementation of mobjGF.isNull()
  • Fixed bug with converting circle/circulararc to vertex-connected segments when ArcToChord value is large
  • Fixed handling of 3D data
  • Added ability to output shape data as ADFText/EWKT via FindFirst/MoveNext and mobjGF.AsString
  • Cleaned up object memory handling in some routines
  • Removed setting mutLayerProperties.layerMBR in ObjectExtent()
  • Simplified setting of all SQL properties and moved all checking of rules and combinations in the BuildSQL function.
  • Removed support for group by, order by and having clauses to reduce complexity (can be used via the directly setting a complete SQL statement.
  • Recreated separate CGeometryFactory class from the GF_ inline code. Involved splitting out of SQL SELECT field indexes from actual sdo_geometry data in mutGeomUDTFields
  • Implemented use of ErrorHandler resource strings in error/warnings.
  • Replaced ORADYN_READONLY with ORADYN_NOCACHE to improve read performance and reduce memory use.
  • Improved dynaset processing efficiency by implementing performance tip”Avoiding Multiple Object Reference” in OO4O documentation
  • Simplified handling of optional extent in FindFirst
  • Added Parameter support to FindFirst in order to improve cursor sharing on database server
  • Made actual FindFirst modified query a returnable property to aid client debugging
  • Load error messages on layer startup

Also, added lots more tests to the LibTest.vbp project.

Leave a Reply

Your email address will not be published. Required fields are marked *