SharePoint 2010 - List view threshold: What does not trigger the threshold?

I have not found good documentation which has "finite list" of operations that triggers the threshold limit. But this blog post is good: blogs.technet.com/b/speschka/archive/200... But I would consider increasing threshold limits via Central Administration because if your have list/document library exceeding the threshold, unusual things starts occuring. For example, you may be blocked from doing this operation because accessing that many items could adversely affect other users of the site 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: office.microsoft.com/en-us/sharepoint-fo... It is always advised to use ContentIterator which provides methods to iterate list items, lists, sites to regulate the amount of data that is transferred (i.e. , to avoid throwing a SPQueryThrottledException). Also, this training video will help you a lot in answering some of your questions: msdn.microsoft.com/en-us/sharepoint/ff42....

I have not found good documentation which has "finite list" of operations that triggers the threshold limit. But this blog post is good: blogs.technet.com/b/speschka/archive/200... But I would consider increasing threshold limits via Central Administration because if your have list/document library exceeding the threshold, unusual things starts occuring. For example, you may be blocked from doing this operation because accessing that many items could adversely affect other users of the site.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: office.microsoft.com/en-us/sharepoint-fo... It is always advised to use ContentIterator which provides methods to iterate list items, lists, sites to regulate the amount of data that is transferred (i.e. , to avoid throwing a SPQueryThrottledException).

Also, this training video will help you a lot in answering some of your questions: msdn.microsoft.com/en-us/sharepoint/ff42....

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 I agree with you. I think for your no 2, the behavior should be same (answer=yes) because CAML query is used by views.

Apart from that I am sure you would have seen "Working with Large Folders and Lists" topic in SDK. Also you can take an approach of returning only a couple of thousand records to your users and suggest them to refine your search criteria if the things they are looking for is not found in those few thousand records. – Ashish Patel Oct 21 '10 at 20:44 Great resources, thanks.

Does No 2 = Yes even if it is paged so that it only displays 100 items on each page displayed to the user? – Jon Schoning Oct 22 '10 at 15:13 Let me correct this a little bit. The correct answer is "it depends".

You can have a million items in List/Library with default 5000 threshold limits and it would work fine as long as you access the items correctly. The resources link in my answer would help to understand how should you write queries or access the list. To be specific, if you use ContentIterator object for paging, you are okay.

– Ashish Patel Oct 22 '10 at 15:53.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.