On Jun 3, 2008, at 10:27 AM, Christophe Leske wrote: > > We have a city database that is being queried regurlarly depending on > the lat/long position of the viewport in order to show city names and > labels.
SQLite has an optional R-Tree engine. The R-Tree is a new addition and has not appeared in any release of SQLite, but it is available via CVS. There is little documentation other than a README file in the source directory. Nevertheless, an R-Tree is specifically designed to solve the kind of query you describe above. If you are willing to work on the bleeding edge, you might want to investigate SQLite's R- Tree capabilities. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users