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