On 7 Aug 2013, at 7:54pm, Christopher W. Steenwyk <csteen...@gmail.com> wrote:

> I've attached the
> schema, my query, and the results of EXPLAIN QUERY from sqliteman.

Sorry, attachments don't work on this list (we don't want everyone sending us 
their homework).  Could you instead just post your SELECT command and the 
EXPLAIN QUERY for it ?

First, have you done an ANALYZE ?

Second, do you have, or think you have, indexes appropriate to your query ?

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to