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 email@example.com http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users