[CDBI] Transactions between HTTP requests?

Carlos Vicente cvicente at network-services.uoregon.edu
Wed Mar 8 18:50:59 GMT 2006


On Wed, 2006-03-08 at 13:39 -0500, Perrin Harkins wrote:
> 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.
> 

That confirms my impression that this idea was just a big brain
fart.  ;-)

Thanks.

cv




More information about the ClassDBI mailing list