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

Reply via email to