MySQL Forums
Forum List  »  Newbie

Re: Traversing a Category tree, is there an easy way to do this? Need an experts opinion!!!!!
Posted by: Jay Pipes
Date: July 04, 2005 12:37PM

Or, you could use the nested set model and do away with recursion all together, which wouldn't be a bad idea, since recursive stored procedures are currently being turned off in the code because of some bugs...

You can read up on the nested set model in Joe Celko's SQL for Smarties, Trees and Hierarchies, or find some articles describing it online (I believe Mike Hillyer recently published a pretty good synopsis of it). If you want to wait a couple weeks, Pro MySQL also has a good portion of a chapter devoted to it...

Cheers,

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.