Forum Discussion
List View Threshold Exceeds 5000 even after moving items into folders
So I hit this threshold on one of my client's document libraries, but even after I moved documents into subfolders we still get this message when we go to settings. (Note: So far I'm only seeing the message there, but I understand this might pose various problems moving forward).
I read this post by Justin Liu and followed up by reading http://sharepointmaven.com/how-to-overcome-sharepoint-5000-item-limit-threshold/ (How to overcome SharePoint 5000 item limit threshold) mentioned by one of the folks that responded to Justin's question. I thought I understood the problem, which is that it's certainly not a limit on the number of items that can be stored but the queries that are run to extract the data. So it seems related to the View and how the data is extracted for the view.
We've taken the library items and organized them into folders so that the main view loads only about 20 folders. But I'm still seeing this message when I go to settings.
So my questions:
How is this threshold still being exceeded?
Perhaps I'm misunderstanding and even though we've moved items into folders, SharePoint is still having to run the query on all the items. If that is the case, then how do I really solve this or at least understand it better so that I can fix it.
Technical: SharePoint Online, it uses the new Library experience (I'm not sure if it has a better name than that)
5 Replies
- Well, as long as you have more than 5.000 items in the doc. library, you are going to see the message....as you say, you can browse the information stored because you are not having a view showing more than 5000 items
- I have a large library that is A-Z folders and each have sometimes even 6 thousand. I placed A-C into a Document Center and I still get the message. Can I keep going even if I get this message? This is for SharePoint online, not server.
The 5000 includes files and folders. The 5000 is per root folder. Moving files another root folder, same site, is how we got around that issue. From a practical standpoint, our SPO searches quit finding items after this number reached about 8000.
I also realized my practical-experience info of 8000 may be old. That comes from Jan 2014.
I'm not sure I understand. When you say 'moving files to another root folder' are you referring to a root folder in the same document lib or are you talking about creating a new document lib altogether?
In theory these lists can hold millions of records correct? So I'm assuming the 5000 threshold is a view/query issue. If that's the case then it would seem that folder restructuring does nothing to change the message since it still shows up.
I don't know, I feel like I'm missing a vital bit of understanding here.
