Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

In SharePoint 2010, we have the List View Threshold, which defaults to 5,000, and:

Specifies the maximum number of list or library items that a database operation, such as a query, can process at the same time outside the daily time window set by the administrator during which queries are unrestricted.

So, I'm looking to determine the options for querying a document library that will have more items than the threshold limit.

Ignoring the 'unrestricted' dailty time window, will the threshold be triggered under the following scenarios on a document library with more than 5,000 items?

  1. Using CAML Queries in Content Query WebParts on indexed columns, non-paged results (Answer: Yes)
  2. Using CAML Queries in Content Query WebParts on indexed columns, paged results
  3. Using the Search API on indexed or non-index columns (Answer: No)
share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

I have not found good documentation which has "finite list" of operations that triggers the threshold limit. But this blog post is good: http://blogs.technet.com/b/speschka/archive/2009/10/27/working-with-large-lists-in-sharepoint-2010-list-throttling.aspx

But I would consider increasing threshold limits via Central Administration because if your have list/document library exceeding the threshold, unusual things starts occuring

As far as No 3. is concerned - I would say "NO" because the search API does not query the list directly but it looks into its own index and there is no practical limit on that!

Another very useful resource: http://office.microsoft.com/en-us/sharepoint-foundation-help/manage-lists-and-libraries-with-many-items-HA010377496.aspx#_Toc264017710

share|improve this answer
    
Ashish, increasing threshold limits only avoids the issue which will have to be dealt with at a later date; I do not wish to circumvent the throttling, only understand how to retrieve data when it is in effect. –  Jon Schoning Oct 21 '10 at 18:24
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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