RE: [PEAR] MDB and MySql Innodb table
| From: | Lukas Smith | Date: | Fri, 02 Jan 2004 01:09:31 +0000 |
| Subject: | RE: [PEAR] MDB and MySql Innodb table | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-9896@lists.php.net to get a copy of this message | ||
> From: Raoul Pierre [mailto:pierre-m.raoul@wanadoo.fr]
> Sent: Friday, January 02, 2004 12:36 AM
> I'm trying MDB 1.1.4RC6 with MySql and PHP 4.3.1 under Windows XP.
>
> When I create a new table with the option DefaultTableType set at INNODB,
> I get table of the right type.
>
> But I don't find any way to force the sequence
> table to be of INNODB type: MDB_Manager_mysql::createSequence
> doesn't take any type option to create this table.
>
> Is this deliberete?
Sort of :-)
Well I never considered allowing other table types.
As far as I know myisam is actually very fast, but just not as feature rich.
I think my implementation of sequences would also not benefit from the row
level locking supported by INNODB. However I don't think it should matter
much.
Is there a particular reason why you would prefer INNODB to be used for
sequence emulation?
Regards,
Lukas