- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688
-->-----Original Message----- -->From: Holly Chamberlain [mailto:[EMAIL PROTECTED] -->Sent: Friday, October 10, 2003 11:01 AM -->To: [EMAIL PROTECTED] -->Subject: What do you recommend: MyISAM or INNODB? --> -->Hi Group, -->I'm requesting feedback - should I use MyISAM or Innodb tables, or a -->mix? My database (currently in Sybase) typically gets no larger than 50 -->gigs, but 99% of the data is in one table. --> -->(The app is an cleanroom monitoring system, we collect 3-5,000 records a -->minute from environmental sensors that are installed in cleanrooms.) The -->data in this big table is never updated, and very, very rarely deleted. -->We just add it and later users select it to display parts of it. What we -->need most are fast queries and fast inserts. --> -->What would be better for performance and maintenance- all MyISAM tables? -->INNODB tables? Or a mix? Do you need transactions? For instance to commit the state of a clean room you need to insert all return values from a sensor? Use Innodb. Either table format can easily handle 3-5000 records a min so, performance should not be the definitive factor. Do, you need to backup this data often? Use mySQL or buy the INNODB backup tool. If you don't need transaction use myISAM, I personally like the multiple table space, the repair tools, and backup tools in place. --> -->Thanks! -->Holly --> --> -->-- -->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]