On 24 Dec 2016, at 10:52am, MONSTRUO Hugo González <[email protected]> wrote:
> Which is the fastest way to count the records of a table. ? And records > that meet a condition? SELECT COUNT(*) FROM MyTable SELECT COUNT(*) FROM MyTable WHERE a = b There is special optimization for COUNT with a * which can sometimes speed these enquiries up quite a bit. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
