In Firebird CORE-659 (http://tracker.firebirdsql.org/browse/CORE-659) there is a collection of requests for spatial index, e.g. R*Tree or GiST, for GIS applications and other. Spatial indexes are also fine to find events in a interval of time.
R* Tree at https://en.wikipedia.org/wiki/R*_tree GiST at http://gist.cs.berkeley.edu/ I think the support of spatial indexes can bring a lot of new users from SQLite (https://www.sqlite.org/rtree.html ) and PostgreSQL (http://www.postgresql.org/docs/8.1/static/indexes-types.html) to FireBird. Christian Waldmann ------------------------------------------------------------------------------ Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel