db tree structure, optimal design

[lajkonik86]

I have some threaded comments and am looking to have the most efficient db design.

One way to go about it:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

Furthermore is it even possible to use a LIMIT on a subset of your query, ie to limit one table to 50, but let the joined table result not be limited?

[Piranha]

lajkonik86 wrote:

Furthermore is it even possible to use a LIMIT on a subset of your query, ie to limit one table to 50, but let the joined table result not be limited?

With subqueries it is possible, but I don't think it is possible to do without subqueries.