Subject Re: [firebird-support] Need to optimize this query for my benchmark tools against Firebird / Mysql / Sqlite3
Author Ann W. Harrison
On 12/19/2010 2:35 PM, Vander Clock Stephane wrote:
> Now for this tool i need to optimize this SQL :

Stephane, you've already figured out that R-tree indexes support
the query you're trying to benchmark. Systems that have R-tree
indexes are vastly better at that query than B-trees. PostGIS
would be a good choice.

Since there is an open-source transactional database that handles
spatial data and has a license that can be used in commercial
projects, there's no great push in Firebird to add R-trees.