Subject Re: Need to optimize this query for my benchmark tools against Firebird / Mysql / Sqlite3
Author chris.waldmann
--- In firebird-support@yahoogroups.com, Vander Clock Stephane <svanderclock@...> wrote:
>
>
> > Hello Ann
> >
> > PostGIS and OpenGIS are very complete solutions for spatial data.
> >
> > In an abstract way, queries for spatial data are multi dimensional
> > range queries for areas or points. And R*Tree indexes are well suited
> > for such queries.
> >
> > And multi dimensional range queries are very common on search
> > platforms, e.g searching for a 3 to 5 year old car with a kilometer
> > reading of 50'000km to 100'000km.
> >
> > So I vote for an additional index kind!
> >
> > To be open for the future, R*Tree indexes could be implemented
> > as a variant of generalized search trees (GiST).
> >
> > Is this a feature that can be discussed in Firebird architect list?
> >
> > Christian
> >
> >
>
> I completely agree ! actually i face the need to split my database in 2
> database engines just because i need RTree indexes ...
> PostgresSQL is probably right (i not try it yet), but it's a very heavy
> system, it's hard like oracle without the power of oracle !
>
> so this feature in Firebird could be defintivelly be a greatest features !
>
> and also i thing we can easily found some users to sponsor such
> developpement
>
> to finish, when i see how sqlite3 implemente their rtree index (only
> with additionnal table), and with few hundreds of lines of code it's not
> look like a "titan" project ...
>
> st├ęphane
>
>
> [Non-text portions of this message have been removed]
>

Bonjour St├ęphane

To have some examples and arguments on the architecture list, can you give me some descriptive examples of your range queries.

And also the SQL script of the multidimensional Rtree-Query in SQLite you use for the benchmark.
My be there are some hours left during Christmas holiday to do some brain gym with stored procedures and bring up the request for additional index types (Rtree, with or without GiST) in the architecture forum.

Do you follow the Firebird-architecture group?

Happy holidays
Christian