On 26 Nov 2017, at 3:13am, Kevin O'Gorman <kevinogorm...@gmail.com> wrote:
> 
> I've got a database of some 100 million records, and a file of just over
> 300 thousand that I want represented in it.  I wanted to check how much
> difference it was going to make, so I wrote a super
> simple program to the read the file and count how many records are already
> there.

You can use COUNT(*) to find out how many rows there are in a table.  SQL is 
optimized to handle this faster than reading individual row data.

SELECT COUNT(*) FROM pos

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to