now its time for Database. the major thing that beginners are curioues to know what are the difference between InnoDB and MyISAM. when where to use when.
The Simple is that to show By The Table.
My ISAM | InnoDB | |
Required full text Search | Yes | |
Require Transactions | Yes | |
frequent select queries | Yes | |
frequent insert,update,delete | Yes | |
Row Locking (multi processing on single table) | Yes | |
Relational base design | Yes |
if there is any doubt which to use when. then MyISAM is your default choice.
you can also mix different table types in same database. Hence it is recommended.
i think table has told the everthing. 🙂 and nothing more to explain.
Source From http://developer99.blogspot.com.au/2011/07/mysql-innodb-vs-myisam.html
Recent Comments