On 24 Dec 2016, at 10:52am, MONSTRUO Hugo González <americasoftw...@gmail.com> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users