On 16 Feb 2010, at 12:28pm, [email protected] wrote: > SELECT * FROM nodes > WHERE n_lat >= 51 AND n_lon >= -1 AND n_lat <= 53 AND n_lon <= 1;
Take a look at the BETWEEN operator, section 2 of http://www.sqlite.org/optoverview.html However, this won't improve things much in your case. Igor's comment about rtrees will be more effective than this for such applications. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
