Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

For 800 customers with each one having 5 document libraries, Is it better to create a one site with 800 x 5 document library or 800 sites with each one having 5 document libraries.

Please respond considering following points

  1. Manageability : How to roll out upgrades for 800 sites.

  2. Performance.

  3. Any limits for Fine - grained permissions.

  4. Security.

etc

thank you

share|improve this question
add comment

1 Answer

Large numbers of item-level permissions in a list can cause serious performance problems as its not only the permission being set but also limited access being granted to navigate to the item.

If you place them in same site, there is a workaround for the performance issues that involves moving creating and moving folders inside a document library. More here.

Another approach would be as you mention to create a site for each customer. You can have 250.000 sites per site collection and still be in supported territory.

You could handle upgrades using site (site collection) scoped features.

share|improve this answer
    
Anders, how would item level permissions have an impact here? If I understand correctly, the choice is site level vs. library level permissions. –  Christophe Oct 10 '10 at 12:06
    
limited access is granted on both list and list-item level permissions, so the performance problem would be similar for a large number of lists with unique permissions. I would go for the one-site-per-customer instead of relying on managing a haywire of unique permissions. Also imaging new content being added, it would scale much better –  Anders Rask Oct 10 '10 at 21:08
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.