On 3/21/2010 10:26 AM, Igor Tandetnik wrote: > Tim Romano wrote: > >> For latitude/longitude queries >> > Without diving into the details of your situation, I wonder if you are aware > of R-Tree extension: > > http://www.sqlite.org/rtree.html >
Thank you Igor. I had read about R-TREE after seeing that extension mentioned recently in this forum. But I am also curious about INTERSECT and what sort of optimizations it uses now and what additional intelligence, if any, it could be retrofitted to employ. Regards Tim Romano _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users