SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
I am using sharepoint 2010. I have a list view threshold with 5000 items on the production environment. I exceeded this limit and got this error:
The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator
How can I reproduce this error on my development environment? I would like to change some custom code to bypass this error.
To be able to reproduce the error on your development environment you need log in as a normal user to your dev farm. Administrators default list view threshold is 20,000 items and 5,000 for normal user, thus rendering the error. However, the threshold is there for one reason, so i would not recommend to override it in your production environment.
By default, the list view threshold prevents operations that will involve more than 5,000 items, such as queries that will return more than 5,000 items or adding a column to a list that contains more than 5,000 items. Although this is a configurable default, we strongly recommend that you keep it. If poorly performing queries are used on lists with more than 5,000 items, overall throughput can significantly decrease when you increase this limit.
The list view threshold is the maximum number of list or library items that a database operation, such as a query, can involve at one time. By default, this is set to 5,000 items. This limit has a major effect on large lists because, by the definition of this threshold, a large list is a list that has more items than this limit. Operations that exceed this limit are throttled
Designing large lists and maximizing list performance (SharePoint Server 2010)
Indexing is the one of the solution for this problem.
