RE: MyISAM vs InnoDB

[Jimmy Guerrero]

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:flessard@stripped] 
> Sent: Tuesday, October 31, 2006 2:25 PM
> To: mysql@stripped
> 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/mysql?unsub=1
> 
>