NYCPHP Meetup

NYPHP.org

[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