On Tue, Dec 27, 2011 at 10:47 AM, Igor Tandetnik <itandet...@mvps.org> wrote: > If you need to do this with any regularity, you should look at R-Tree > module: > > http://www.sqlite.org/rtree.html
I do have a lot of range-based queries and rtree seems to be a perfect solution for my problem. I am using the sqlite module from Python and a good news is that, at least on Mac, RTREE is enabled by default (python 2.7, Mac/BuildScript/build-installer.py has -DSQLITE_ENABLE_RTREE). I will report back my if I can use this module to optimize my query. Thanks, Bo _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users