On 7/4/2013 5:29 PM, Paul Sanderson wrote:
select * from master as m, lookup as l where x >= start and and x < end and
m.index = l.index

You might want to look at the RTree module:

http://www.sqlite.org/rtree.html

It's specifically designed to implement such range queries efficiently.
--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to