Hi,
I am about to update all my DataObjects with the following...
static $create_table_options = array('MySQLDatabase' => 'ENGINE=InnoDB');
(After reading... http://www.silverstripe.org/archive/show/515#post515)
This is because I need to run scripts on my database and the best way of doing that is with transactions in the first place... i.e.
use test;
BEGIN;
SELECT count(*) FROM dummy;
INSERT INTO dummy (ClassName) VALUES ('Dummy');
SELECT count(*) FROM dummy;
ROLLBACK;
#COMMIT;
Is there any disadvantage to change the table types to 'InnoDB'? Will I lose any silver stripe functionality?
Barry