Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • aaronb 97 posts 116 karma points
    Sep 20, 2011 @ 16:48

    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.

Please Sign in or register to post replies

Write your reply to: