Zbigniew Baniewski wrote: > 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). > Add limit 1 to the query, so that it stops after finding the first match.
Gerry _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users