I'm just looking for some advice on the best way to structure documents in
SharePoint 2010 for a client. Basically they have about 10
Business Units, then potentially tens of thousands of
Clients and for each Client they should have from 1 to hundreds of
What I'm thinking of doing is create a site per Business Unit, and then just have one Document Library containing a Folder per Client, and then a Sub-Folder per Project, and then in the Project folder have a number of standard folders to contain the different types of project documents. I will create code to automatically create this structure as Projects are added to their line of business app.
I appreciate this will results in quite large document libraries but they will have a decent structured in them with no particular folder having thousands of files in them.
The other option is to create a document library per client, but I think that's going to get very clumsy to navigate?
The one other thing I need to bear in mind is that in some point they might want to allow certain clients logon rights to certain folders inside their own client folder. This may be easier with Libraries but I think I can write code to automatically manage permissions that is no harder for folders than for libraries.
Thank you for your input!!