RE: [PEAR] MDB and MySql Innodb table
| From: | Raoul Pierre | Date: | Fri, 02 Jan 2004 10:14:49 +0000 |
| Subject: | RE: [PEAR] MDB and MySql Innodb table | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-9902@lists.php.net to get a copy of this message | ||
> De : Lukas Smith [mailto:smith@backendmedia.com]
> Envoye : vendredi 2 janvier 2004 02:10
[...]
> 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?
Well, for example, I'm asking myself what's happening when you take a new ID
from a sequence during a manual transaction, and you cancel (rollback) this
transaction. Or the update fails during the commit command. Is there any
risk of inconsistency?
Regards
Pierre