New answers tagged limitations
TL;DR - Stay under 5,000 items for the entire library to get 100% of functionality In addition to the 30 million documents per library you also need to be aware of the limit of 5,000 items per "view". http://technet.microsoft.com/en-us/library/cc262787(v=office.15).aspx#ListLibrary This particular limit can be changed in on-premise but in SharePoint ...
A document Library can hold more than 30,000,000 denouements but catch is MSFT support upto 30,000,000 and if you exceed you will be out of support. That's mean MSFT will tell you delete the documents stay in limit. So, 30 Million is upper limit, whatever folder structure you have and number of folder you have....all together should not exceed 30 Million.
In our SharePoint implementation, we try to avoid breaching the list view threshold (which we’ve left at 5000) by designing our views with it in mind. We don’t have libraries quite as large as yours, but in those that are above the list view threshold we have set the default view to ‘1 Week View’, ‘1 Month View’ etc. which show files which have been created ...
You have to change the List View Threshold to the number of items returnd in one database query. You do that in Centra Administration > Application Management > Manage Web applications. In the ribbon select the Web application you want to edit select General Settings edit List View Threshold item limit.
if the list contains less than 5000 items, the performance of the CQWP is likely to be very good. However, if the list exceeds 5000 items, and the query in the CQWP is complex, the Web Part can run into performance problems. It’s difficult to define exactly what a complex query is, but a Source that goes across all sites in your site collection is more ...
The issue is that the view is scanning all items to determine which are folders so that they can be displayed. The fix is to modify the default view so that it does not show folders (under view settings, folders section).
As far as I understood only a 'View' of a list ran into problems at 5000 items. If you can filter the view to only ever show less than 5000 I think you would be fine.
Top 50 recent answers are included