3 ms·
+1 for root-id, this is a huge failing in a lot of threaded discussion table designs.
by tracker1 7y ago
+1 for root-id, this is a huge failing in a lot of threaded discussion table designs.
- protomyth 7y agoYeah, it really helps if you have to do some processing in the stored procedures and it helps with the query speed if properly indexed. I have seen folks put a level number in the table also, but that really depends on what the hierarchy represents.