I have not had occasion to use the nested set representation, but I have multiple friends who have. And it certainly worked as advertised for them.
Unless you have some concrete experience of the nested set representation not working as advertised, I'm going to have to heavily discount what you have to say. Even then I'd be interested to see the implementation since I know full well how easy it is to accidentally turn an efficient query into an inefficient one.
In reply to Re: Re: Re^3: Efficiently Walking Large Data Structures Stored in Multiple Tables
by tilly
in thread Efficiently Walking Large Data Structures Stored Across Multiple Tables
by jerrygarciuh
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |