Solved

Sharepoint 2013 Library List View Limitations

Posted on 2016-10-17
9
56 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 16

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 16

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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

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 16

Accepted Solution

by:
Walter Curtis earned 500 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 16

Expert Comment

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

Expert Comment

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

Expert Comment

by:Walter Curtis
ID: 41857707
Thanks
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Viewers will learn the different options available in the Backstage view in Excel 2013.
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…

803 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