Very good! I'll keep that one. On Tue, Sep 15, 2015 at 1:26 PM, Igor Tandetnik <igor at tandetnik.org> wrote:
> On 9/15/2015 2:04 PM, John McKown wrote: > >> sqlite> select count(a) from x; >> > > Better still: > > select exists (select 1 from x); > > The difference is that the version with count() always scans the whole > table, while the latter stops at the first record - which is good enough if > you only need to check for existence, and don't actually need the count. > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown
