Re: [sqlite] Is this query optimized?

[Kurt Welgehausen]

count() has always done a full table scan. As far as I know,
nothing has been done to optimize it, as your observations
seem to confirm.

Regards