SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a client who has already exceeded default sharepoint threshold. enter image description here

Is understand that it is not advisable to increase the default limit but in my case i am left with no other option than to increase the threshold .

Can anyone tell me what is the max limit for threshold i can put? Client is expecting another 50000 files going into the document store.

As per this it says max limit is 50 million. How much can i increase it to? any guidance on this will be very helpful

share|improve this question
up vote 2 down vote accepted

The threshold has nothing to do with how many items can be in a library. It has to do with the performance of the views. So, keep the threshold low, and configure views to only show a small number of items at a time, like items added today (and index the fields you're using to filter the views).

If you increase the view threshold anyway, you're going to have significant performance problems on your site.

share|improve this answer
Also, when creating a view based on an Indexed field, that field must be the first one listed in the filters. If it isn't then SharePoint will still show the Threshold Warning message – Dave Wise May 21 '13 at 19:33

As @Mike2500 points out, changing the threshold is not advisable but there are other alternatives to handling this, such as folder organization, key fields and so forth. This "Training Course" from Microsoft is one of the best resources that I've run across on how to handle the Large List issue and should provide you with a few options that might work in your situation as well as an understanding of the underlying issue itself

share|improve this answer
Great training link Dave. Thanks for sharing. – Anthony Kasses May 23 '13 at 23:17

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.