Hi all, I'm using mysql 4.0.17 and I have this problem with speed of innodb database:
I have simple command like select count(*) from table1, or select field1, field2 from table1. The table1 and has more than cca 10.000 rows (most of the fields are integer, only several varchars and several memos) and its type is InnoDB. Then the query lasts too long, at least several seconds, sometimes more than 5. If I convert it to MyISAM then the query lasts usually less then 0.3 second. If the table is small (cca less than 5.000 rows) then there is not big difference... Is it normal, that InnoDB isn't able to access large table as quickly as MyISAM? Or is there any parametr to set to make InnoDB run faster? I need to use InnoDB because it supports transactions and MyISAM not... thx Jiri Matejka [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
