Storing Hierarchical Data in a Database, Part 2 — SitePointApril 30, 2003Storing Hierarchical Data in a Database, Part 2 Now, let’s have a look at another method for storing trees. Recursion can be slow, so we would rather not use a recursive function. We’d also like to minimize the number of database queries. Preferably, we’d have just one query for each activity. We’ll start by laying out our tree in a horizontal way. Start at the root node (‘Food’), an
