You might also see how well INTERSECT performs on your Latitude/Longitude query. Put an index on (float) LAT and another on (float) LON and use an INTEGER primary key in MYTABLE.
select * from MYTABLE JOIN ( select id from MYTABLE where (lat >= 30 and lat <= 33) INTERSECT select id from MYTABLE where (lon >=-80 and lon <= -55) ) as IDLIST on IDLIST.id = MYTABLE.id Regards Tim Romano _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
