I have a CQWP that queries an entire Site Collection. The Site Collection contains around 10,000+ documents. I use the CQWP to try to get the 25 most recent documents from this 10,000.

Problem is, it fails. It shows me this error:

Your query returned a greater number of results than the web application's query throttling limit. Please adjust the configuration of this Web Part o increase the throttling Limit.

Has anyone worked around this? Did you develop your own custom webpart instead?



one way you can work around this is to use the lightning conductor webpart.

it runs on an elevated account which will not look at the threshold.

needless to say, this needs to be used with caution, but the built in cache features helps reduce performance impact

another approach is to use content iterator

SharePoint Server provides a new API, ContentIterator, to help with accessing more than 5,000 items in a large list without hitting a list throttling limit and receiving an SPQueryThrottleException. ContentIterator implements a callback pattern for segmenting the query for processing a single item at a time. Consider using this capability if you need to process a large number of items that may exceed a throttling limit.

  • Thanks Tiago! Content Iterator looks promising. Will have a go with that.
    – Water
    Aug 12 '14 at 8:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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