Opened 16 years ago
Last modified 16 years ago
#391 new task
SQLite provider: Investigate if we can support the new R*Tree SQLite extension
Reported by: | traianstanev | Owned by: | traianstanev |
---|---|---|---|
Priority: | minor | Milestone: | |
Component: | SQLite Provider | Version: | 3.2.0 |
Severity: | 3 | Keywords: | |
Cc: | External ID: |
Description
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.
Change History (2)
comment:1 by , 16 years ago
Component: | FDO API → SQLite Provider |
---|
comment:2 by , 16 years ago
For anyone else looking for information on this new index: http://www.sqlite.org/rtree.html
Note:
See TracTickets
for help on using tickets.
Fixed "Component" field.