Thursday, December 5, 2013

In SharePoint object model while getting the data from large
lists through SPQuery, we can get SPQueryThrottleException saying that “The
attempted operation is prohibited because it exceeds the list view threshold
enforced by the administrator”. We can get rid of this exception by
using Content Iterator (CI). Content Iterator provides implementation interface
for SharePoint objects to regularize the amount of data to be transferred. This
will helps queries in on the lists to not put the load on database excessively.
It will iterate the content in the list instead of executing the query. So that
it will process each item in the list to avoid the throttling limits.

We can process the content iterator to crawl the list items.
Following is the sample code will give us the detail about Content Iterator
processing

Follow us in facebook

About Me

Having good experience in SharePoint 2007/2010 and .net applications. Currently, working on SharePoint 2013 and training people on SharePoint. Microsoft certified technology specialist, Microsoft Certified Professional developer in SharePoint 2010.