Hello, Although the number of records is a consideration to weigh in your decision, there are many other (perhaps more important) factors to consider.
For example, do you need foreign keys? transactions? row-level locks?...then InnoDB is your choice. Perhaps with more details concerning the characteristics of the data and your applications requirements, folks may be able to better help you with a design choice. Storage limits, efficiency in how space and memory is used, bulk insert speed, etc. might be other factors to consider. Take a look at: http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html Thanks, Jimmy Guerrero MySQL, Inc > -----Original Message----- > From: Francis [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 31, 2006 2:25 PM > To: mysql@lists.mysql.com > Subject: MyISAM vs InnoDB > > Hi list, > > Question about MyISAM vs InnoDB ? What is the best to > use, I have a large table contain around 10 millons of > records. What is the best for me ? Use MyISAM or InnoDB ? > > Ty for reply ? > > > > > > -- > 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]
