Hi all I was reading the High Performance MySQL book (by O'Reilly) and there was mentioned that executing a count(*) is slower on the InnoDB engine compared to the MyISAM engine, because InnoDB tables do not keep track of the number of the records. I just wanted to know that if this performance degradation is a feature of all transactional engines (i.e. Oracle, DB2, PostgreSQL, ...) or it's just a weakness of the InnoDB engines?
Best Regards, Behrang S. -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
