On 19 Jan 2018, at 12:06pm, x <[email protected]> wrote:
> Int Count=0;
>
> while (sqlite3_step(...)) Count++;
That’s a slow way to count rows. Do it in SQL:
SELECT COUNT(*) FROM MyTable WHERE b > 11;
You get just one row back which makes everything far faster.
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
