This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.
Please use forum.silverstripe.org for any new questions
(announcement).
The forum archive will stick around, but will be read only.
You can also use our Slack channel
or StackOverflow to ask for help.
Check out our community overview for more options to contribute.
... just curious as it seems like InnoDB is much better all round.
Silverstripe 2.0.0, MySQLDatabase.php:
/**
* Create a new table with an integer primary key called ID.
*/
public function createTable($tableName) {
$this->query("CREATE TABLE `$tableName` (ID int(11) not null auto_increment, primary key (ID)) TYPE=MyISAM");
}
thanks,
J
We hardwired the storage engine so that database generation was done automatically.
It would be fairly straight forward to add a static method, so that you could put this into your _config.php file:
* MySQLDatabase::table_type("InnoDB")
As to why we chose MyISAM, we basically went with it because we didn't need the extra features of InnoDB, and we though we'd go with the format with the most history. This may change in future releases as we might want to use transactions.
