Search This Blog

Wednesday, October 10, 2012

How to increase the List View Threshold value for particular list in Sharepoint 2010 Using Powershell


I've been working on a list with items exceeding the 5000 default list view threshold limit.
I know that I can easily go to Central Administration,Select your Web Application,Click on General Settings Then Select Resource Throttling,By default it is 5000,Change the value,put your number in the text box.
But this is applicable to entire web application then automatically some times the performance of the system is very slow.
But my goal was NOT to enable this for the entire Web application.
 I only wanted to make an exception to this one list.

So I started digging into the SPList properties and found a property called "EnableThrottling".
 Setting this property to "false", allowed me to bypass the 5000 limit for this one list.

I used the following PowerShell commands to achieve this:

$WebApplication = Get-SPWeb http://<SiteCollectionName>

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

$List.EnableThrottling = $false

$List.Update()

18 comments:

  1. Hello there! Do you know if they make any plugins to protect against hackers?
    I'm kinda paranoid about losing everything I've worked hard
    on. Any suggestions?

    Stop by my weblog ... raspberry ketones diet

    ReplyDelete
  2. If you desire to increase your experience only keep visiting this website and be updated with the newest news posted here.


    Review my web blog Test Force Extreme

    ReplyDelete
  3. My brother suggested I might like this website. He used to be entirely right.
    This publish truly made my day. You can not consider simply how a lot time I had spent for this information!
    Thank you!

    My web page; Zinn collection review

    ReplyDelete
  4. Hi I am so excited I found your website, I really found you
    by accident, while I was researching on Bing for something else,
    Anyways I am here now and would just like to say thanks a
    lot for a incredible post and a all round thrilling blog (I also love the theme/design), I don’t have time to go through it all at the minute but I
    have book-marked it and also included your RSS feeds,
    so when I have time I will be back to read a
    lot more, Please do keep up the fantastic work.


    Also visit my site; Goji Berry Reviews

    ReplyDelete
  5. I’m not that much of a internet reader to be honest
    but your blogs really nice, keep it up! I'll go ahead and bookmark your site to come back later on. All the best

    my web blog - Buy Garcinia Cambogia

    ReplyDelete
  6. It's amazing to go to see this website and reading the views of all mates regarding this article, while I am also keen of getting experience.

    Here is my blog post ... Garcinia cambogis review

    ReplyDelete
  7. I'm really loving the theme/design of your web site. Do you ever run into any browser compatibility issues? A number of my blog visitors have complained about my website not working correctly in Explorer but looks great in Firefox. Do you have any recommendations to help fix this problem?

    my page - http://cosimarevivalblog.com/

    ReplyDelete
  8. bookmarked!!, I like your blog!

    my page: http://atlaslm.com

    ReplyDelete
  9. I go to see everyday a few blogs and information sites to read articles, except this web site provides
    feature based writing.

    my web page - Raspberry ketone

    ReplyDelete
  10. Hi, i think that i saw you visited my weblog so i came to “return the
    favor”.I'm trying to find things to improve my site!I suppose its ok to use some of your ideas!!

    Also visit my site; Dermal meds review

    ReplyDelete
  11. If you would like to take a good deal from this piece of writing then you have to apply these methods to
    your won blog.

    My homepage :: Rvtl

    ReplyDelete
  12. Thanks for finally talking about > "How to increase the List View Threshold value for particular list in Sharepoint 2010 Using Powershell" < Liked it!


    http://njhealthcenter.com/node/368

    Also visit my website; Pure Garcinia Cambogia - http:
    //www.axlebook.com/blogs/73959/74635/pure-gce-review
    -

    ReplyDelete
  13. I feel this is among the so much important information for
    me. And i'm satisfied studying your article. But wanna remark on few normal things, The web site taste is great, the articles is actually excellent : D. Good job, cheers

    Have a look at my web page: garcinia cambogia reviews

    ReplyDelete
  14. Thank You for great info...

    ReplyDelete
  15. Exϲellent post. Keep writing such kind of infoгmation on your page.Im гeally impressed
    by it.
    Hello there, You have perfoгmed aan exсellent job.
    I'll definіtely digg it and in mƴ view recommend to my friends.
    I am sure tyey will be benеfited from this weƅsite.


    my blog ... http://www.salefivefinger.com/webhostingpad-coupons, tcijournal.com,

    ReplyDelete
  16. When someone writes an piece of writing he/she maintains the idea
    of a user in his/her mind that how a user can understand it.
    So that's why this article is outstdanding. Thanks!

    Review my web-site :: Home Invasion Millburn NJ

    ReplyDelete
  17. Information was good, I like your post.
    Looking forward for more on this topic.
    SharePoint Development Tutorials

    ReplyDelete
  18. you forgot 2003 in the blog title

    ReplyDelete