I will let others give their opinions on which one is best, but it is important to point out that you are not making a one-or-the-other decision. One of the advantages of using MySQL is that you can choose the right table handler on a table-by-table basis. This means that you can have sales and inventory tables be innodb and take advantage of transactions, but keep your log tables in MyISAM for extra speed and fulltext searching (just an example).
Regards, Mike Hillyer www.vbmysql.com -----Original Message----- From: Mojtaba Faridzad [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 12:32 PM To: [EMAIL PROTECTED] Subject: InnoDB Hi, I need your experience to help me which table type it's better. I am going to define my database with more than 100 tables and some tables have more than 200,000 records. I know that InnoDB has some advantages against MyISAM such as transactions or foreign keys. But I am not sure that these services cause slowing process or not. If you want to start a database project, which table type do you prefer to use? Thanks -- 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]