Working with Large Lists in Sharepoint

So when we decided to move to Sharepoint 2010 every one was excited and so were the uses because as per the readings we can make larger lists (then what we already have) yes its never enough 🙂 

As they say SharePoint Lists supports Items upto 50 million  – During read operations. 

However the challenge has always been to make the data in the large list available for retrieval and display in timely and efficient manner.
Although the users can create as many items as they want the query operation shows down as the list grows in size. 

So what do poor administrators like you and me do … 

Introducing our life saver : Resource Throttling

Resource Throttling is new with SharePoint 2010 and is set on site collections by default standard users are throttled when retrieving 5000 items from the list with a warning of 3000, these warnings can be changed using PowerShell.

the mechanics works like this:
if a user is pulling data with 4999 items the query runs all the data without any error.
however if the user or query tries to retrieve 5001 items an expensive query will be returned. 

so what we can do is we can use Central Admin to set a time frame when these expensive queries cannot be run for example a query cannot be run at some time frame like 9 to 6 and then later these query would yeild results. 

this can be done from Central admin>Application Management > Manage web application > select your application> General settings > Resource Throttling. 


hope this would help 🙂 


Advertisements

About Pratik Vyas

Hi Readers, Welcome to Pratik’s SharePoint Blog. First of all Thank you very much for taking interest and spending time to tour my Blog I am in the ocean of SharePoint since January 2008 (almost 4 years), and still I feel I have to go more deep. I am working with a well known MNC as a SharePoint Consultant. Here I used consultant because I do a little development and customization with administration. I am very much interested in Microsoft products. I have started blogging since 2008 but I can say in real manner I have started it in 2011 (as I have posted only 4-5 blogs from 2008 to 2011 J) I believe there isn’t anything impossible in SharePoint, the only thing is sometimes we have to think something off track. I have posted couple of blogs which was discovered by going some off track, we can simply say it TRICKS. Feel free to reach me in case of any issues or queries I will be more than happy to help you. Good bye and Happy Reading, Cheers !!
This entry was posted in All about SharePoint 2010, resource throttling, Working with Large Lists in Sharepoint. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s