On Sun, Nov 26, 2017 at 1:39 AM, Simon Slavin <slav...@bigfraud.org> wrote:
> > > 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. > I know, but that does not help much when I'm trying to match the database against a file, as I am here. -- Dictionary.com's word of the year: *complicit* _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users