Introduction
In this article, I will compare the limits ofSharePoint 2016 List and Library with other SharePoint versions.
Boundaries, Thresholds and Supported limits
Before we get started, you should first know what are 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.
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 07 | SharePoint 10 | SharePoint 13 | 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 |
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 |
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, I've compared the SharePoint 2016 List and Library limits with SharePoint 2013 / 2010 / 2007.
Reference