SharePoint 2013 had a default List View Threshold that used the number 5,000 for a lot of limits. SharePoint 2016 has made a few changes to the List View Threshold to give us a little more flexibility. If you take a look at the TechNet article “Software boundaries and limits for SharePoint Server 2016” you will find that the old 5,000 limit is still there for normal list activity, but they have made a few changes for Site Owner maintenance activities.
- When adding or removing a column index, the threshold is 20,000 by default.
- When deleting a list or folder, the threshold is 100,000 by default.
- When renaming a folder within the same library, the threshold is 100,000 by default.
Note that these limits are for Team Members, Site Owners and Site Collection Administrators. Server administrators can exceed these limits and everyone can during “happy hour!” (Officially, the “Daily Time Window for Large Queries” limit set by the SharePoint Server administrators.)
As I am working on a new course, “Microsoft SharePoint Server Content Management for SharePoint 2013 and 2016”, I have to both test these limits and create screen captures for classroom demos. I ran into two interesting discoveries:
- I could rename folders when there were more than 100,000 items. So this one must be for when there are up to 100,000 folders at the same level.
- I could NOT delete a list with 100,000 items. Or, 99,999 items.
The delete issue was a bit more interesting… I started deleting items, even emptied the Recycle Bin after each delete, but still could not delete the list… until I hit 99,993 items. Weird huh? That number is not even a magic number (a power of 2). I guess there must seven hidden, for SharePoint’s use only, items in that large list. Who knows…
I could not delete the following list until the item count was below 99,994.
99,993… now I can delete it.
Now… should I go an tie up the bandwidth to create a 100,000 item list in SharePoint Online to test there?