Search code examples
sharepoint-2010threshold

Sharepoint list view threshold maximum limit?

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

I 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?

Would I look like a fool if I simply increase it to 5 or or 10 million

Solution

  • 50 million, if that's what the article says.

    It's really just a question of performance and scalability, but if the client really needs a quarter million items in a list, he'll have to accept a little waiting time.

    Read this, where it says that SQL Server escalates to a full table lock if you exceed 5000 items. That means that you're probably going to be making other people wait, if they also require access to the same table at the same time.

    Use the smallest possible threshold that will satisfy the client. Warn him that there may be performance penalties.