From: "David Lloyd" > journalling file system. It's not always that clear cut. I've just > switched a number of big customer databases to InnoDB and noone's > noticed any difference - if anything it's going faster.
For small tables (<50,000 records) MyISAM is usually a lot faster. However, MyISAM gets slower as the table size increases if it is used in a medium to high concurrency environment. If you only use selects (low concurrency) MyISAM will probably be fast, but when it comes to large tables with lots of select, update and insert queries you will most likely see that the speed of InnoDB remains roughly constant as the database grows. You will see a slower performance as : - InnoDB runs out of table space and has to autoextend the data file(s) - the conf file is not suitable for the db size anymore - the hardware is not suitable for the db size anymore (e.g. not enough memory) But this is not really InnoDBs fault ;-) Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
