> Which is the fastest way to count the records of a table. ? And records > that meet a condition?
I have a table with 726.000 registers. SELECT COUNT(*) FROM MyTable << is very slowly SELECT COUNT (RowId) FROM MyTable ORDER BY PrimaryIndex << is very FAST SELECT COUNT(RowId) FROM MyTable WHERE a LIKE '%abc%' ORDER BY PrimaryIndex << is FAST with more registers, but is SLOWLY with 726000 registers Which is the fastest way to count the records of a table with a condition and 700.000 registers ????? Which is the fastest way to select 23 registers that meet a condition ????? Hugo _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users