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 traianstanev, 16 years ago

Component: FDO APISQLite Provider

Fixed "Component" field.

comment:2 by jbirch, 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.