On 14 Oct 2011, at 5:12pm, Fabian wrote: > Is this the expected output? If so, ANALYZE was to blame. The query > containing 'ORDER BY rowid DESC' is still slower than the one which doesn't > specify any order, but the results are closer to eachother now.
So that should never happen, right ? ANALYZE is meant to make things faster, not slower. So is that an actual fixable bug or is it one of those extremely unlikely situations that is hard to fix ? So, OP, try issuing these commands DROP TABLE sqlite_stat1; DROP TABLE sqlite_stat2; then see whether anything improves. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
