On 2 Aug 2010, at 7:06pm, Richard Hipp wrote: > Most of the slow queries seem to be "SELECT count(*) FROM ....". Such > queries have to visit every row in the table (in order to count the rows) > and thus get progressively slower as the number of entries in the database > increases.
Might there be a way to optimize count() ? After all, the number of rows in a table is probably held somewhere convenient. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users