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

Currently I have a single list where I store some data for all users. The problem is that the list has scalability issues after 5000 rows. I was thinking to create a list for each user.

How many lists can I create in Sharepoint 2010 ? Is there a limit? I need to create at least 1 million lists.

What is the recommended approach ?

Thank you

share|improve this question
1  
I couldn't find any limit on number of lists, however you might want to go through this link, technet.microsoft.com/en-us/library/cc262787(v=office.14).aspx –  Muhammad Raja Apr 24 '13 at 9:38

2 Answers 2

up vote 1 down vote accepted

Seem 2000 lists is the suggested limit.

See this page from Microsoft for further detail. Note that the limit isn't an "hard limit" but performance seem to degrade exponentially after that point.

enter image description here

share|improve this answer

the scalalibity issues are due to poor planning. With good planning that should not happen, limit is 30 million items per list.

Sharepoint 2010 LIMITs http://technet.microsoft.com/en-us/library/cc262787(v=office.14).aspx#ListLibrary

share|improve this answer
    
"You can create very large lists using standard views, site hierarchies, and metadata navigation. This value may vary depending on the number of columns in the list and the usage of the list." 5 columns are too much for 30 mil items ? How it performs with 100k simultaneous read/writes? –  Bogdan M. Apr 24 '13 at 9:35
1  
with 30 millions items, 1 server would not be enough and then you need to scale out. Please check the farm topologies for recommendation based on limits, blogs.technet.com/b/schadinio/archive/2010/08/18/…, look ath the small and medium topologies. Your Sharepoint will be way too slow specially if the crawl components are on the same WFE. –  L.V. Sharepoint Architect Apr 24 '13 at 9:55
    
i still need to find the maximum # of lists to see if the other approach is better, but links are useful –  Bogdan M. Apr 24 '13 at 11:02
    
technet.microsoft.com/en-us/library/cc262813(v=office.14).aspx explains how to optimize performance –  Bogdan M. Apr 24 '13 at 11:33

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.