[CDBI] Transactions between HTTP requests?

Perrin Harkins perrin at elem.com
Wed Mar 8 18:39:43 GMT 2006


On Wed, 2006-03-08 at 09:56 -0800, Carlos Vicente wrote:
> So, I guess the two questions are: Is it possible to do this somehow,
> and if so, is it a good idea?  

No and no.  Besides the major technical problems, this just isn't what
transactions are for.  They are supposed to be short-lived, so that they
don't hold onto locks and kill your database.

Instead you need to do something like log the user's actions for undo or
write the changes to a temporary holding area while waiting for
approval.

- Perrin





More information about the ClassDBI mailing list