Hello Axel,

Thanks for your reply.

> Seems you don't know of multi-column-indexes nor of the spatial
> indexing extension (MyISAM only)
>
> http://dev.mysql.com/doc/refman/5.0/...ate-index.html
> http://dev.mysql.com/doc/refman/5.0/...xtensions.html

Yes, I knew about those. However I fail to see how a multi-column index
would help in this case. Could you elaborate? If I create an index on
(lat, lon), will it be able to retrieve ranges efficiently? About the
spatial indexing, I did not want to go into this as it seems overkill
for my needs. But if you say it's the way to go, I'll give it a try.

As you're from MySQL, any plans on allowing future versions to use two
indexes in the same query?

Cheers,

JFG