Ah, sorry about the attachments, you can find the files here: https://www.dropbox.com/l/fpFfcjwwcyhXZgduswCggb
And yes, as the final part of the DB creation I do run ANALYZE. And I do think the indexes are correct for the query. On Wed, Aug 7, 2013 at 3:07 PM, Petite Abeille <petite.abei...@gmail.com>wrote: > > On Aug 7, 2013, at 8:54 PM, "Christopher W. Steenwyk" <csteen...@gmail.com> > wrote: > > > The attached query takes over 6 days to run. > > “Patience – A minor form of despair, disguised as a virtue.” > > Also… attachments are stripped out by the mailing list. You may want to > try to inline them instead. > > _______________________________________________ > 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