EXPLAIN EXTENDED

How to create fast database queries

Archive for March 18th, 2009

Hierarchical queries in MySQL: adding level

with 4 comments

This is a series of articles on hierarchical queries in MySQL:

See also:

Today I will add some more features to these queries.

We have almost 100,000 rows in the table, 8 hierarchy levels, and our query is written so that it always selects all rows.

Now let's try to present our data in a Yahoo-style catalog. We need only top 2 levels: parent categories and their subcategories.
Read the rest of this entry »

Written by Quassnoi

March 18th, 2009 at 11:00 pm

Posted in MySQL