> Did you try a compound index? Given WHERE conditions wouldn't have any benefit from compound index - only first column will be used anyway.
Pavel On Fri, Dec 10, 2010 at 10:11 AM, Jim Morris <jmor...@bearriver.com> wrote: > Did you try a compound index? > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users