Subject Re: [firebird-support] Need to optimize this query for my benchmark tools against Firebird / Mysql / Sqlite3
Author Vander Clock Stephane
Dear Ann,

> 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.

Actually on Mysql, i can not really understand how to translate my query
using their Rtree index (spatial) :(

> 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.

you speak about mysql or sqlite3 ? because in both their implementation
of rtree is not really efficient ... on mysql after 3 days still not
how to use it or why the speed is soo slow and on sqlite3 it's not
database engine..

also on sqlite3, the rtree is moslty based and internal table they contruct.
the code of the rtree implementation is not very big (one small unit),
so it's
look like rtree is not very hard to do...

[Non-text portions of this message have been removed]