On 19 Jan 2018, at 12:06pm, x <tam118...@hotmail.com> 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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
