[fdo-trac] #391: SQLite provider: Investigate if we can support the new R*Tree SQLite extension

FDO trac_fdo at osgeo.org
Wed Sep 10 12:12:58 EDT 2008


#391: SQLite provider: Investigate if we can support the new R*Tree SQLite
extension
----------------------------+-----------------------------------------------
   Reporter:  traianstanev  |       Owner:  traianstanev
       Type:  task          |      Status:  new         
   Priority:  minor         |   Milestone:              
  Component:  FDO API       |     Version:  3.2.0       
   Severity:  3             |    Keywords:              
External_id:                |  
----------------------------+-----------------------------------------------
 SQLite 3.6 introduces a new built-in spatial index functionality in the
 form of an R*Tree. The spatial index is fully integrated in the SQL
 semantics of SQLite and spatial (BBOX) queries can in theory execute
 transparently.

 This task is to investigate if the provider can be easily modified to
 support both its own spatial index and the built-in SQLite spatial index
 (if it exists). Also, it would be interesting to make a performance
 comparison between the two.

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


More information about the fdo-trac mailing list