We are using Windows 2008 (EC2) and have application that stores large number of subfolders in a specific folder (i.e. root/subfolder1, root/subfolder2, root/subfolder3 etc.)
We are expecting tens of millions of subfolders and the question of scalability arised. Do you have any idea if Windows 2008 will be able to handle this? What about performance, is there a magic line after which any folder operations (e.g. creating new subfolder, or looking up exisiting) will drastically slow down? Are there any hard numbers?
As an alternative we are considering converting that flat structure into a tree like
root/subfolder1_/subfolder1 root/subfolder1_/subfolder11 ... root/subfolder2_/subfolder2
What is your opinion on that?