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.
> 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

Reply via email to