none
sharepoint list item count exceeds the threshold limit RRS feed

  • Question

  • Hi...

    I have a list with 7000 list items and the items are grouped by one column. If 4 iems has to come under some group, it is showing only few items not all the four items. How can it shows all the four under that group value...Any Help...to resolve this.....

    Thanks,

    Thursday, June 27, 2013 9:18 AM

Answers

  • One of the major reasons that this List View Threshold (LVT) feature was created is to protect the server from unintentional load that may either bring it down, or at least cause other users higher latency or failures. Changing this limit (default 5000) is quite simple, but I wouldn't recommend it unless you are positive that it will not negatively affect your system

    However you can change the threshold limit with compromise in performance

    1- Login to Central Admin

    2- Go to Application Management -> Manage Web Applications

    3- 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)

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

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

    You can also by pass the 5000 limit by running this PowerShel script

    $WebApplication = Get-SPWeb http://

    $List = $WebApplication.Lists["My List"]

    $List.EnableThrottling = $false

    $List.Update()

    Go through this article

    http://blogs.msdn.com/b/dinaayoub/archive/2010/04/22/sharepoint-2010-how-to-change-the-list-view-threshold.aspx

    http://pravahaminfo.blogspot.in/2012/10/how-to-increase-list-view-threshold.html


    Mark ANSWER if this reply resolves your query, If helpful then VOTE HELPFUL <hr> <b><a href="http://insqlserver.com">Everything about SQL Server | Experience inside SQL Server </a></b>-<a href="http://insqlserver.com">Mohammad Nizamuddin </a><br/>

    Thursday, June 27, 2013 9:42 AM

All replies

  • One of the major reasons that this List View Threshold (LVT) feature was created is to protect the server from unintentional load that may either bring it down, or at least cause other users higher latency or failures. Changing this limit (default 5000) is quite simple, but I wouldn't recommend it unless you are positive that it will not negatively affect your system

    However you can change the threshold limit with compromise in performance

    1- Login to Central Admin

    2- Go to Application Management -> Manage Web Applications

    3- 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)

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

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

    You can also by pass the 5000 limit by running this PowerShel script

    $WebApplication = Get-SPWeb http://

    $List = $WebApplication.Lists["My List"]

    $List.EnableThrottling = $false

    $List.Update()

    Go through this article

    http://blogs.msdn.com/b/dinaayoub/archive/2010/04/22/sharepoint-2010-how-to-change-the-list-view-threshold.aspx

    http://pravahaminfo.blogspot.in/2012/10/how-to-increase-list-view-threshold.html


    Mark ANSWER if this reply resolves your query, If helpful then VOTE HELPFUL <hr> <b><a href="http://insqlserver.com">Everything about SQL Server | Experience inside SQL Server </a></b>-<a href="http://insqlserver.com">Mohammad Nizamuddin </a><br/>

    Thursday, June 27, 2013 9:42 AM
  • Thank You...

    Can we resolve it using indexing...without changing the threshold value...

    If yes, please provide the procedure and explain how it will resolves...

    Thanks,

    Thursday, June 27, 2013 10:26 AM
  • K Nagarani,

    Can you please elaborate on "If 4 iems has to come under some group, it is showing only few items not all the four items."? It looks like its the problem with the view and not related to threashold.

    Since your list is already above the threashold, it wont allow you to Index the columns now. One workaround I can think of is to increase the threashold then try to index the required columns and then again revert the threashold back to the original value. Hope this helps. 


    Please mark as 'Propose as Answer' or 'Vote' as appropriate.

    Thursday, June 27, 2013 1:15 PM