On Wed, 28 Mar 2001, you wrote:
> On Wed, Mar 28, 2001 at 09:26:38PM +0100, Robin Szemeti wrote:
> > (my pseudo-transaction scheme for MySQL is basically : .. do this and
> > return a closure to undo it if I to .. bung the closures in an array ..
> > if something screws up then back it all off by walking along the array
> > and executing the closures ... its not rocket science but it works ..
> > sort of .. I used it for doing multiple inserts into a spread of tables
> I did something similar.  It worked too, until not only did an insert
> fail, but when I was backing out, a delete failed too.  There was much
> head-scratching.  A week later, the hard disk died and the head-scratching
> stopped.

;)) .. 

> Unfortunately, if you implement this sort of thing, mysql loses it's only
> advantage over other databases - speed.  But I wasn't allowed to upgrade
> to (eg) postgresql for silly reasons which I forget now.

well .. since in most web based uses of MySQL the 99% of queries are
simple 'select * from blah where something=something_else' .. the
speed is all you need .. every now and again there is reason to add a
user or, very occasionally, someone buys something .. and those bits have
the pseudo-transactions in .. yeah .. its slow, but I'd ratehr have that
bit slow and the rest lightning quick than pretyy much anything else ...

Robin Szemeti

The box said "requires windows 95 or better"
So I installed Linux!

Reply via email to