[[firebird-support] Rtree indic or similar]

>
> on a big table (more than 10 000 000 rows) i need to do a query
> like
>
> select
> ID
> from
> Hash
> where
> X1 > 10 and
> X1 < 20 and
> X2 >40 and
> X2 < 60 and
> X3 > 12 and
> X3 < 22 and
> X4 > 33 and
> X4 < 44 and
> X5 > 89 and
> X5 < 99;
>
> i try everything on firebird (mostly the plan), puting an index on
> each column, the best i have is 300 ms to retrieve the data.
>
> now using simply SQLIte3 with Rtree index on the same amount of row
> the result is given in 0 ms !!
>
> is their any way out to do the same thing using Firebird ?

Add R-Tree indices? From what I've understood (which might not be
enough) an R-Tree is a perfect match for your requirements.

In addition, if I remember correctly, SQLite doesn't handle concurrency
very well, so it does have advantages for simple speed test scenarios
without concurrent read-write transactions.

--
Michael Ludwig