17488 Posts in 4473 Topics by 1978 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 2300 Views |
-
Why does Silverstripe hardwire its storage engine to MyISAM?
11 March 2007 at 11:13pm
... 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 -
Re: Why does Silverstripe hardwire its storage engine to MyISAM?
12 March 2007 at 4:12pm
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.
| 2300 Views | ||
|
Page:
1
|
Go to Top |
