[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