Something about Sharepoint

How to increase the list view threshold in SharePoint 2013

**The most common limitation that SharePoint users face these days is managing a list with large amount of data. We had all our wings flying high when we used SharePoint 2007 as there were no talks of optimising the lists and hence even if we have lists with 100000 items, there were no issues viewing them. The reason being in SP 2007 when a listview exceeds 5000 items, customers were facing table locking issues. Microsoft realised this ande decided to enforce this threashold.

In SP 2013, if you try viewing a list with more than 5000 items you will notice an error saying listview cannot display more than 5000 items. There are couple of workarounds for this issue.

• Structure your lists in such a way that once a list reached the 5000 item threashold, it splits into another list and hence we have additional lists to manage the remaining data.

• You wil be able to fiddle around with the threadhold limit in the central administration.

Login to Central Admin

Go to Application Management -> Manage Web Applications

Pick the Web application for which you want to change the LVT (If you only have 1 web app plus the central admin one, the one you want to pick is the 1 web app; changing this for the central admin does you no good)

In the ribbon above, click General Settings. That will bring down a menu, from which you should pick Resource Throttling

Change the LVT (first item in this list) to another value and press OK, but please try to keep it to a reasonable number!

This workaround is not the most recommended way as this will impact the efficiency factor and there might be table locking issue. If you are looking at deleting a list with more than 5000 items then you would be able to adopt this workaround.**