On 16 Apr 2013, at 7:10pm, ven...@intouchmi.com wrote: > I tried transfering the database to an in memory copy and running the > queries. It is actually a little slower but not much. I'm sure there are > tables that are not being accessed and so loading them into memory would add > to the time.
I'm sorry I'm not responding to your posts any more, but I don't think I can help. I'm not familiar with anything that would cause ANALYZE to make a query slower, and I'm hoping an expert will see this and help you. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users