No, there is no reason to covert them to INNODB unless you want an ACID compliant table format, and have disk space to spare.
MYISAM support a wide variety of mySQL featured, such as full text searches, a key buffer, and a few other nice things such as a being able to get a row count in ms time. INNODB is cool for transactions / ACID compliant features and large amounts of concurrency. -- DVP > -----Original Message----- > From: Brad Tilley [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 21, 2004 2:44 PM > To: [EMAIL PROTECTED] > Subject: Converting tables to innoDB > > Hello Mysqlers, > > I have a few small DB's (less than 10,000 entries per table) that track > computer inventory in a mid-sized organization. Currently, all of the > tables > are MyISAM. Is there any compelling reason to convert these to InnoDB? > We're > not having any performance or size issues... everything works great right > now. I'm just hearing how InnoDB is the only way to go today, any tips on > whether or not to switch? > > Thanks, > > Brad > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
