Show pageOld revisionsBacklinksAdd to bookBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. The database structures are generated by the modules. The storage engine generally default but is specified for a few tables based on the ACID requirement of the table. ^ table ^ Preferred Engine ^ |_messages|myISAM| |_mail|myISAM| |_egrades|InnoDB| |_cgrades|InnoDB| |_delinquency|InnoDB| ===MyISAM OR InnoDB=== |Required full text Search |myISAM| |Require Transactions |innoDB| |frequent select queries |myISAM| |frequent insert,update,delete|innoDB| |Row Locking (multi processing on single table) |innoDB| |Relational base design |innoDB| [[http://developer99.blogspot.com/2011/07/mysql-innodb-vs-myisam.html]] dev/database.txt Last modified: 2022/04/30 01:18by 127.0.0.1