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