Re: Converting tables to innoDB

2004-04-21 Thread Paul DuBois
At 18:43 -0400 4/21/04, Brad Tilley wrote: 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 an

RE: Converting tables to innoDB

2004-04-21 Thread Dathan Vance Pattishall
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.