What is the 5,000 list item limitation?

The reason behind this limitation has everything to do with database performance. SQL Server databases sit behind every SharePoint list and library, and their functions are driven primarily by direct database queries. So the more items in a list or library, the harder the database needs to work, and the more performance becomes comprised for every SharePoint user in the entire farm.

What should you do? There are many approaches to take with managing large lists that will avoid this issue and at the same time make your SharePoint site run faster and more efficiently. There is a wonderful online video training course for managing SharePoint lists titled SharePoint lists V: Techniques for managing large lists that directly addresses this limitation and demonstrates several ways to solve this problem.

Need help?

Last updated: 

July 27, 2017

Browse by tag