2

I am working on sharepoint document library inside sharepoint on-premises 2013. the document library contain around 3800 files and folders. so when i went to the library setting, i got this warning message:-

enter image description here

so my question is how i can allow the document library to have more than 5,000 items? as in our case we store our projects documents inside this library, so it should allow use to have more than 5,000 items. is this is possible to increase the threshold? as if we can increase the threshold, then will it have any drawbacks ? Regards

2

You can increase the List view threshold setting by going to central admin.

  • Open Central admin -> Application Management -> Manage Web Applications
  • Select Web applications -> Now from ribbon...Click on General Settings -> Resource throttling.enter image description here
  • Now change the settings as per your requirements: enter image description here

Link: SharePoint 2013: List View Threshold

Impact will be depending upon your infrastructure i.e.

  • Number of Users
  • List items
  • Number of Servers
  • Network

Warning: Changing the List View Threshold (LVT) is not recommended if you have other users, as larger values will degrade performance. Creating too large a value can cause high latency or failures for users, or potentially bring down a server.

Manage large lists and libraries in SharePoint

  • thanks for the reply. but seems the threshold of 5,000 does not mean that the document library can only hold 5,000 items, it means that the list view will only show max of 5,000 item.. is this correct? if this is the case then can i control which 5,000 items will be shown, for example can i say that the last 5,000 modified folders to be shown inside the list views? second question, let say my list will have 200,000 items then how i can view all those items (assuming that i will keep the current threshold of 5,000 as is)? can u adivce on my 2 points – john Gu Oct 1 '18 at 23:02
  • 1
    That's correct, 5000 limit for views not lib/list. Yes you can control it by using filter option inside view settings, link k shared have information about it. – Waqas Sarwar MVP Oct 1 '18 at 23:48
  • this topic is really confusing ,, now i find some articles which suggest to create index columns inside the list for all the sort & filter columns we use inside the list views, and they mentioned that doing so will allow the list view to show all the items (not just 5,000) ?? so is this correct? for example inside my current document library, i have a single list view which do not have filer (as it shows all items) and it sort the items based on the Modified date.. so if i create an index on the modified date my problem will be solved? – john Gu Oct 2 '18 at 0:07
  • 1
    Index column is one of the options, if you able to create it then yes you can get required results – Waqas Sarwar MVP Oct 2 '18 at 0:15
  • but let say i define to sort the list views items based on the "Modified" column and i created an Index on the "Modified" column,, then will the list view be able to show more than 5,000 items ?? if the answer is yes, then what is the magic of using index column in this case.. – john Gu Oct 2 '18 at 2:40
2

Using PowerShell, you can also disable list throttling on a per-list basis rather than increasing the limit for all lists in a web application. The following shows the commands required:

$web = Get-SPWeb http://urltoweb

$list = $web.Lists["MyList"]

$list.EnableThrottling = $false

$list.Update()

While this can still have an effect on the farm as a whole if the list gets very large and/or lots of people are using it to retrieve many items, this only impacts a single list rather than all lists in a web application.

  • thanks for the reply.. so let say i disable Throttling on the list, and i found that this will cause problems inside our sharepoint server,, so can i enable it back? or this is a one time task that can not be reversed in the future? – john Gu Oct 1 '18 at 23:04
  • 1
    You can just use the same commands with '$list.EnableThrottling = $true' instead to re-enable throttling whenever you want to. – Andy Dawson Oct 2 '18 at 9:02
  • i mean this is flexible process ... so i can test disabling the threshold and if i find that it will cause problems i can re-enable it again ? – john Gu Oct 2 '18 at 14:44
  • Absolutely. If you're worried about it, pre-prepare your disable and re-enable scripts in advance so you just have to run them. – Andy Dawson Oct 2 '18 at 14:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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