Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Sharepoint 2013 Library List View Limitations

Posted on 2016-10-17
9
Medium Priority
?
127 Views
Last Modified: 2016-10-24
I'm confused about the 5000 item list view limit and what is added up to reach 5000. Does this mean I cannot have more than 5000 items in a Document Library or that I cannot have more than 5000 items in each folder of that document library?


I've read the below KB and am still confused...
https://support.office.com/en-us/article/Manage-large-lists-and-libraries-in-SharePoint-2013-and-SharePoint-2016-b8588dae-9387-48c2-9248-c24122f07c59?ui=en-US&rs=en-US&ad=US
0
Comment
Question by:David Mundt
  • 6
  • 3
9 Comments
 
LVL 20

Expert Comment

by:Walter Curtis
ID: 41847403
0
 

Author Comment

by:David Mundt
ID: 41847421
I've read this article as well and I'm not getting the clear answer to my question.

Is the > 5000 item limit the total of a document library or only one list where each folder is the current list...
0
 
LVL 20

Expert Comment

by:Walter Curtis
ID: 41847616
There is  no practical limit to the number of items a list or library can have. The limit is in the millions, depending upon the version of SharePoint.

Folders play no role. They don't add to the count nor do they divide the number of items in to anything.

The list threshold is what you are probably thinking about. SharePoint throttles resources so that one site does not bring down the farm or degrade farm performance for other sites. (Remember SharePoint is about collaboration.) That means that the maximum number of items a list/library view will display is 5000, out of the box. That limit can be adjusted as needed and in some cases I have set it as high as 30,000 for various reasons without any negative impact.

With good design however, the list threshold should never pose a problem to you.

Hope that makes it somewhat clearer for you...
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:David Mundt
ID: 41848420
So to define list/library view it is ALL items in a library regardless of folder structure?
0
 
LVL 20

Accepted Solution

by:
Walter Curtis earned 2000 total points
ID: 41848458
A view is a display of data. Lists and Libraries can have an unlimited number of views. Each view can have different filters, styles, groupings etc. applied to them.

When a list or library is created a default view is also created which does show all items, however since the list or library is newly created it is empty. As items are added, the use of views will play an important role in administering the list or library.

For example, if you have a list of 100,000 people, you would probably want to create 26 views, one for each letter of the alphabet. This can be done by using the filter capabilities of views.

Therefore, most views would probably not exceed the list threshold of 5000 items. (In reality maybe it would because there are more names that start with "S" then with "Z", but I hope you get the point.

As far as folders, they don't do much as far as filtering. That means, if you have 10 folders in a list, and all folders have 1000 items, you exceed the threshold by 5000.

Good luck...
0
 

Author Comment

by:David Mundt
ID: 41848466
Thank you! I now understand. I've been thinking in terms of file explorer and the items per folder and it seemed like if each folder had < 5000 items I'd be safe...
0
 
LVL 20

Expert Comment

by:Walter Curtis
ID: 41848507
Glad that helps...
0
 
LVL 20

Expert Comment

by:Walter Curtis
ID: 41857695
Please select a solution and close this question David.
0
 
LVL 20

Expert Comment

by:Walter Curtis
ID: 41857707
Thanks
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question