On Mon, Aug 2, 2010 at 11:11 AM, Simon Slavin <[email protected]> wrote:
> 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.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
