SharePoint 2016: List and Library Limits compared to previous versions
Introduction
In this article, let's compare the SharePoint 2016 List and Library limits with other SharePoint versions.
Boundaries, Thresholds and Supported limits
Before we getting started, you should first know What's the types of Limit?
- Boundaries: Static limits that cannot be exceeded by design.
- Thresholds: Configurable limits that can be exceeded to accommodate specific requirements.
- Supported limits: Configurable limits that have been set by default to a tested value.
You may be also interested to read SharePoint 2019 Limitations compared to other versions.
List and Library Limits for SharePoint
The below table lists the recommended guidelines for List and Library in SharePoint 2016, 2013, 2010, 2007.
Limits/Version | Limit Type | SharePoint 2007 | SharePoint 2010 | SharePoint 2013 | SharePoint 2016 |
List Row Size | Boundary | x | 8,000 bytes per row | 8,000 bytes per row | 8,000 bytes per row |
File Size | Boundary | 50MB (2GB max*) | 2 GB | 2 GB | 10 GB |
Documents | Supported | 5 Million per library | 30,000,000 per library | 30,000,000 per library | 30,000,000 per library |
Major Version | Supported | x | 400,000 | 400,000 | 400,000 |
Minor Version | Boundary | x | x | 511 | 511 |
Items | Supported | x | 30,000,000 per list | 30,000,000 per list | 30,000,000 per list |
Bulk Operation | Boundary | x | 100 items per bulk operation | 100 items per bulk operation | 100 items per bulk operation |
List view lookup threshold | Thresholds | x | 8 join operations per query | 12 join operations per query | 12 join operations per query |
List view threshold | Thresholds | 2,000 | 5,000 | 5,000 | greater than 5,000 |
List view threshold for auditors and administrator | Thresholds | x | 20,000 | 20,000 | 20,000 |
Subsite | Thresholds | x | 2,000 per site view | 2,000 per site view | 2,000 per site view |
Calculated Columns | Thresholds | x | 48 per list | 48 per list | 48 per list |
GUID Columns | Thresholds | x | 6 per list | 6 per list | 6 per list |
Coauthoring in Word and PowerPoint | Thresholds | x | 10 concurrent editors per document | 10 concurrent editors per document | 10 concurrent editors per document |
Security scope | Thresholds | x | 50,000 per list | 50,000 per list | 50,000 per list |
Workflow associations | Supported | x | x | 100 per list | 100 per list |
Maximum list size for workflow lookups to non-indexed fields | Thresholds | x | x | 5,000 items per list view | 5,000 items per list view |
Maximum list size for auto-start workflow associations | Supported | x | x | 10 million items per list | 10 million items per list |
SharePoint Workspace synchronization | Boundary | x | 30,000 items per list | x | x |
Note
X indicates this information is not mentioned in TechNet.
Conclusion
In this article, we've compared the SharePoint 2016 list and library limits with SharePoint 2013 / 2010 / 2007.
Reference
Software boundaries and limits for SharePoint Server.
See also
- SharePoint 2016: Site Collection Limits compared to previous versions.
- SharePoint 2016: Content Database Limits compared to previous versions.
- SharePoint 2016: Web Application Limits compared to previous versions.
- SharePoint 2019 Limitations.
Credits
Published by M.Qassas at Comparing SharePoint 2016 list and library limits with SharePoint 2013 / 2010 / 2007.