I haven't been able to dig up a recent, definitive answer on this one. Some time ago I saw 50 mentioned as the max number of nodes you'd want under any given node.
I'm looking at a site now which potentially will have a greater number than that, without any clear way to subcategorize them further.
Could anyone please shed some light on whether 50 is a reasonable limit, or if not, how far I can push it without running into serious performance issues? The hosting environment is pretty powerful (but not a web farm), and is running sql server 2k8 I believe.
Number of child nodes/performance on sql server?
I haven't been able to dig up a recent, definitive answer on this one. Some time ago I saw 50 mentioned as the max number of nodes you'd want under any given node.
I'm looking at a site now which potentially will have a greater number than that, without any clear way to subcategorize them further.
Could anyone please shed some light on whether 50 is a reasonable limit, or if not, how far I can push it without running into serious performance issues? The hosting environment is pretty powerful (but not a web farm), and is running sql server 2k8 I believe.
is working on a reply...