RE: [PEAR] MDB and MySql Innodb table
| From: | Lukas Smith | Date: | Fri, 02 Jan 2004 11:39:11 +0000 |
| Subject: | RE: [PEAR] MDB and MySql Innodb table | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-9907@lists.php.net to get a copy of this message | ||
> From: Raoul Pierre [mailto:pierre-m.raoul@wanadoo.fr]
> Sent: Friday, January 02, 2004 11:15 AM
> > 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?
There is really no risk of inconsistencies, however the sequence would still
remain incremented and would not get rolled back. Anyways I guess it
wouldn't hurt adding such an option, I will ponder it.
Regards,
Lukas