Subject Re: [firebird-support] Rtree indic or similar
Author Vander Clock Stephane
> Add R-Tree indices? From what I've understood (which might not be
> enough) an R-Tree is a perfect match for your requirements.

Yes exactly. not only my requierement, the requierement of everyone that
want to do some select in range

> In addition, if I remember correctly, SQLite doesn't handle concurrency
> very well,

not handle at all ! we must use mutex everywhere

> so it does have advantages for simple speed test scenarios
> without concurrent read-write transactions.

but actually with Firebird, 300 ms, same with sqlite3 = 0ms :(
even with no concurency their is no competition.

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