| Subject | Re: [firebird-support] Need to optimize this query for my benchmark tools against Firebird / Mysql / Sqlite3 |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2010-12-20T16:27:59Z |
On 12/19/2010 2:35 PM, Vander Clock Stephane wrote:
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.
Cheers,
Ann
>Stephane, you've already figured out that R-tree indexes support
> http://sourceforge.net/projects/alcinoe/files/alsqlbenchmark/1.00/ALSQLBenchmark_1_00.zip/download
>
> Now for this tool i need to optimize this SQL :
>
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.
Cheers,
Ann