Compare The SharePoint 2016 List And Library Limits With Other SharePoint Versions

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

X

Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now