Office 365 (SharePoint) Manage Large Lists and Libraries
There are many ways you can work with or query a SharePoint list or library without receiving a List View Threshold warning. You can store up to 30 million items or documents in a SharePoint list or library. Using the following ideas, you can get the information you need and stay within the 5000 item List View Threshold.
Managing Large Lists and Libraries in SharePoint
SharePoint has resource throttles and limits that govern the amount of data and throughput that can be managed. The List View Threshold is by default, approximately 5000 items, and is set to allow users to work with large lists, but keep good performance. There are three main ways to work with the List View Threshold:
- For all versions of SharePoint, manage the number of items returned using indexing, filtering, folders, and offline data.
- For server versions of SharePoint use an administrator scheduled Daily Time Window whee limits are raised.
- For Server versions of SharePoint, a network administrator can raise the limit of the List View Threshold.
For further information on these items, and more, please see this Microsoft Support article regarding large list and library management in SharePoint.