[nycphp-talk] MySQL, MyISAM tables, <trigger> | <on delete cascade> - Help
Dan Cech
dcech at phpwerx.net
Fri Feb 20 11:46:50 EST 2004
David Mintz wrote:
> On Fri, 20 Feb 2004, Dan Cech wrote:
>
>>You can find a lot of information in the archives of this list and the
>>nyphp-dev list, and also plenty of resources on the net. A good place to
>>start would be:
>>
>><http://www.intelligententerprise.com/001020/celko.jhtml>
>
> Interesting! I'll let you know what I think as soon as I get done
> imagining a little worm crawling counter-clockwise along the tree.
Hehe, getting your head around the concept can be an 'interesting'
experience, but the system can be very powerful indeed.
Personally I use a variation which retains the parent_id field, allowing
easy retrieval of direct parents and children, and also the ability to
rebuild trees should they become severely monged.
The biggest project I've applied this to has been phpGACL
(<http://phpgacl.sourceforge.net/>), approximately doubling the speed of
the program.
Dan
More information about the talk
mailing list