9.1.13 Table handlersThis is NOT the latest copy of this book; click here for the latest version.
In order to promote flexibility and choice, MySQL allows you to select what "type" of table it will create - you have the choice of MyISAM, which is the default type, InnoDB, and BDB. Of these, MyISAM and InnoDB are popular, and both offer their own advantages.
MyISAM is the default - it is very, very fast for reading and writing data of all types, which is its main feature. It does not support transaction processing or foreign keys, but it does support table optimisation.
InnoDB does support transactions and foreign keys, as well as row-level locking - this potentially allows it to update rows faster. However, on the whole you will find that InnoDB is a great deal slower than MyISAM. Unless you specifically require transactions, I suggest you stick with MyISAM.
|
Want to see this stuff in print? PHP in a Nutshell takes the core topics covered here, adds in thousands of edits from the editorial team and myself, and combines them to make an unbeatable reference for PHP programmers at all levels.
My latest book has hundreds more tips on how to use PHP, Apache, and MySQL, plus Perl, Python, shell scripts, performance tuning, and more!
|
