I am unsuccessfully attempting to cause an
SPQueryThrottledException locally in order to debug a problem a customer is having.
SPSiteDataQuery to query several sites which contain 4000 to 8000 items each, totalling over 43000. The query is being run against an elevated instance of the root SPWeb of the site collection.
The query is filtered using both the
<Lists> elements, but not by any other attribute, and is not querying recursively. It runs at the Site Collection scope.
The query has run successfully when triggered by user accounts of Contribute level permissions and higher (although this is redundant given the elevation). Lower permission levels would fail for other reasons.
The twist is this: When running locally the query succeeds, but when running in the customer's live instance, the query fails when more than 5000 items are queried in total.
We both have the same Throttling settings:
- 5000 normal limit
- 20000 admin/audit limit
- Out of hours query limit removal is disabled
- 8 field lookup limit (which we're nowhere near)
So why is the querying running successfully here, with item requests far beyond even the admin limit?