[wp-hackers] Category Operation (Adjacency vs. Modified Preorder)

[David Chait]

Well, without some real atomic operation, uncancellable by the user, lots of 
problems could occur throughout the entire system... ;)

Some ideas for this one:
- spawn the thing that does the update in another script, so user can't muck 
it up.
- have the update script use some kind of lock file, in order to try to keep 
atomicity of its operations.
..etc.

Just me, randomly writing without thinking... :)
-d

----- Original Message ----- 
From: "Denis de Bernardy" <denis at semiologic.com>
To: <wp-hackers at lists.automattic.com>
Sent: Saturday, February 11, 2006 12:03 PM
Subject: RE: [wp-hackers] Category Operation (Adjacency vs. Modified 
Preorder)


> > sql tree preordering works nice, but imho implementing them without
> > transactions and triggers is really asking for trouble.
>
> I suppose performing an index check after every insert/update
> might be a bit excessive .. or would it?

Technically, you can live with a corrupt tree, but you cannot trust any math
to make assumptions on its contents.