On Sun, Sep 21, 2008 at 05:22:46PM -0500, Jay A. Kreibich wrote:
> count(*) is an odd one... In most database systems it is extremely
> fast, but in SQLite it tends to be rather slow.
I forgot the important thing: usually I was using count(*) just to detect
the presence of any record meeting given condition. Is it possible to make
it fast _not_ using count(*)? I need just a "boolean result" of 1/0 (yes,
there is at least one / there aren't any).
--
pozdrawiam / regards
Zbigniew Baniewski
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
