Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: Atomic use of unlink() and SQL DELETE? How?

by pboin (Deacon)
on Feb 09, 2006 at 13:31 UTC ( #529072=note: print w/replies, xml ) Need Help??

in reply to Atomic use of unlink() and SQL DELETE? How?

If it were me, I'd not kill myself trying to do this perfectly. Getting the atomic transaction right, along with the cascading deletes, etc. seems to not be worth it.

Have you considered relaxing your requirements a bit so that the delete will work correctly in all but the most extreme circumstances, and then just running a periodic maintenance job to make sure you're clean on files-to-pointers and pointers-to-files?

Perfection is cool, but can be dear to implement.

  • Comment on Re: Atomic use of unlink() and SQL DELETE? How?

Replies are listed 'Best First'.
Re^2: Atomic use of unlink() and SQL DELETE? How?
by robins (Acolyte) on Feb 09, 2006 at 13:47 UTC

    Do you have a good suggestion for the "almost perfect" solution?

    Could you point me in the right direction about what I'm doing wrong in the current function? I know I'm doing something wrong, but I think I've managed to blindfold myself while looking at the problem...

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://529072]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (6)
As of 2021-08-05 09:04 GMT
Find Nodes?
    Voting Booth?
    My primary motivation for participating at PerlMonks is: (Choices in context)

    Results (44 votes). Check out past polls.