On Fri, Apr 16, 2010 at 8:17 AM, Mike Goins <mike.go...@adtecservices.net> wrote: > Query: > SELECT tb_file_key, basename, extension, path FROM tb_file WHERE > basename GLOB 'a*' AND extension GLOB 'b*' AND path GLOB 'c*' AND > deleted = 0 ORDER BY tb_file_key DESC;
Apologies for responding to my own post (digest subscriber). I did make significant progress by creating an index on the deleted column and re-arranging the query: SELECT tb_file_key, basename, extension, path FROM (SELECT tb_file_key, basename, extension, path FROM tb_file WHERE deleted = 0) WHERE basename GLOB ? AND extension GLOB ? AND path GLOB ? order by tb_file_key DESC; This query is over 25 times faster. Now it's a matter of watching it over time. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
