Is there any tips for programatically adding and managing the huge number of folders in document library?
In my scenario, a document library has 3 hierarchies and each hierarchies contains 50 - 100 folders. The number of folders has possible to be 1,000,000 (=100*100*100). Additionally, the terminal folders should have unique role assignments.
In straightforward way, it takes more time to add folder and set role assignments to it as the number of created folders increases. The index fragmentation of SharePoint database may cause this problem. I have only idea to execute SQL command to rebuild index for solving this problem, but this is not good method.
Hope someone helps me.