In a situation with many concurrent reads and writes an InnoDB table would be preferable.
See http://www.mysql.com/doc/en/Table_types.html Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: JOUANNET, Rodolphe [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2003 2:30 AM > To: [EMAIL PROTECTED] > Subject: Large file : InnoDB or MyISAM > > > Hi to all, > > I will have to do with a very big file (approx 600 millions > of records). > Which is the best table handler for this king of table : > InnoDB or MyISAM > (many INSERT and MANY SELECT, no UPDATE - statistics file). > > Best regards. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]