[fdo-trac] #290: ODBC driver: significant performance improvement on selecting geometries

FDO trac_fdo at osgeo.org
Mon Mar 31 14:17:03 EDT 2008


#290: ODBC driver: significant performance improvement on selecting geometries
-----------------------------+----------------------------------------------
   Reporter:  danstoica      |       Owner:  danstoica
       Type:  enhancement    |      Status:  new      
   Priority:  major          |   Milestone:  3.3.1    
  Component:  ODBC Provider  |     Version:  3.2.0    
   Severity:  3              |    Keywords:           
External_id:  1041996        |  
-----------------------------+----------------------------------------------
 ODBCDR: Currently the geometries are retrieved as BLOBs ("image"), using
 the specialized  ODBCGetData(). This approach is slow, about 2000
 geometries/sec.

 During the implementation of the SQLServerSpatial provider (against MS SQL
 Server 2008) a hybrid technique for retrieving the geometries has been
 developed and tested, allowing a performance boost of about 10 times.
 Ported this enhancement to ODBCDR.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/290>
FDO <http://fdo.osgeo.org/>
Feature Data Objects


More information about the fdo-trac mailing list