The dreaded 5000 limit

Today I hit the dreaded 5000 limit in SharePoint.
This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator.

To view items, try selecting another view or creating a new view. If you do not have sufficient permissions to create views for this list, ask your administrator to modify the view so that it conforms to the list view threshold.

Learn about creating views for large lists.

This means you can not access the list FULLSTOP.

Do not believe the experts when they tell you 5000 items is not a problem, that you can have 32 million
items in a list, that you just have to add a view filtering out less than 5000 items. They do not tell you upfront, you need to have an index supporting the filter in place before you hit the 5000 limit. That they tell you when you have hit the ceiling. Filters can only be latched on indexed fields when the list is larger than 5000 items. And you cannot create an index on a list with more than 5000 items. Catch 22. A black hole storage. If I can't access the items I do not care if can store 32 zillon items in a list.
How can anyone the year 2016 have a product out on the market that cannot handle more than 5000 items. SharePoint is a work in progress and that is very diplomatic.
I will certainly publish a comment from a (proud) SharePoint developer designer defending the 5000 limit. Come on; tell us why 5000 items is a good limit for SharePoint in this day and age of IoT. Right now I can use some soothing words to lower my blood pressure down.

I Found the answer myself, this is reason for the 5000 limit

If you do not care or understand what you are writing this is probably a good answer.

No comments:

Post a Comment