Got a situation with a test env, where I'm dealing with a number of spawned processes, that might also spawn processes, so I have a "tree" where I'm looking to determine when the spawned processes have completed. To manage this cluster/tree of processes, I'm considering using a tree kind of DB representation:
I've got a test app that spawns off child processes, where each process then updates the status of the corresponding given item upon completion. So the status in the itemStatusTBl will change from 0 to 1.
I'm trying to determine how to efficiently be able to determine when the children of a given top/root node in the parentChildTBL are complete, ie, have the status set to '1'. (There could be multiple top level/root nodes, each with their own independent set of children)
I could try to simply look at all the children each time I examine the tbl, but that might result in a lot of recursive function/processing in order to get to all the levels...
I've looked at various articles, but not sure which is the best approach to this kind of issue.
A complete run is determined by: when all children of the top level/root node != '0'
Is this a self join,left join situation?
A sample query/pointers would be helpful
Thoughts/Thanks
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Jan 16
Arthur Fuller Re: Parent/Child - Linked List
Jan 16, 2012; 12:18
Arthur Fuller
Re: Parent/Child - Linked List
Jan 16
bruce Re: Parent/Child - Linked List
Jan 16, 2012; 13:53
bruce
Re: Parent/Child - Linked List
Jan 16
Peter Brawley Re: Parent/Child - Linked List
Jan 16, 2012; 13:33
Peter Brawley
Re: Parent/Child - Linked List
Jan 16
bruce Re: Parent/Child - Linked List
Jan 16, 2012; 17:14
bruce
Re: Parent/Child - Linked List
Jan 16
Peter Brawley Re: Parent/Child - Linked List
Jan 16, 2012; 19:31
Peter Brawley
Re: Parent/Child - Linked List
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!