Thanks Kabel,
Not sure if this is the exact problem you're trying to solve, but
this helped
me in a similar situation.
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Yes, I have seen this article before, and it is really nice. However
they do not discuss any optimization issues.
Now I was reading Joe Celko's book. Probably my query is simply not
the best solution for this type of problem.
Thanks,
Olga
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
