Contents
30 million items
You can store up to 30 million items or files in a list or library. Filtered views of large lists have a similar experience to other lists. However, when a list view shows more than 5000 items, you may run into a list view threshold error.
Under SharePoint Web Application Management, click ‘Web application general settings’. On the Web Application General Settings page, choose the appropriate web application. Under Maximum upload size, type the file size which you want to upload and click on OK. You can specify a maximum file size up to 2,047 megabytes.
How many records can you store in SharePoint?
As per MS we can store 30 million records in a single sharepoint list and as long as we are not fetching 5000. My question to MVP’s or MSFT is why there are so many links warning about 5000 item limit. Can somebody explain real meaning of list view threshold of 5000 item limit?
Is there an item limit of 5000 in SharePoint?
What I understand as an architect is the 5000 limit is not for actual items but number of items you can fetch at one time which should not be more than 5000. We have quarter million records in a list and we can still edit the list without any issue as long as the view item limit is well below 5000.
If you plan to store more than 60 million items in SharePoint Server 2013, you must deploy multiple content databases. We strongly recommended limiting the number of site collections in a content database to 5,000. However, up to 10,000 site collections in a database are supported.
Each index partition contains a subset of the whole search index. If the number of indexed items is high in relation to how much memory the server has, affects the query response time negatively. For SharePoint Foundation 2013, the maximum number of indexed items is 2 million items per index partition.