[EMAIL PROTECTED] wrote:
If I understand the InnoDB engine correctly, I don't see how they could speed it up unless they start tracking how many records belong to each active "version" within a database.
But one thing you can do to speed it up somewhat is to do a COUNT(PK_column) (rather than COUNT(*)) if you have a column that is a primary key for the table - that's the same thing semantically, and involves searching an index rather than the data records themselves, which should involve less I/O.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
