Hi All,
I have a scenario to get filtered data from one list which has around 50,000 items.
Scenario 1:
I have a list having 50,000 items (without folder structure). When I query the list I got listview threshold exceed exception when result set is greater than 5000. I also indexed the fields in which I am filtering the data.
Scenario 2 :
I created another list and stored 50,000 list items in 5 folders (10,000 list items in each folder). When I query folders of this list, I got all the filtered data which are greater than listview threshold without exception.
Note :
1) The user has only read permission in site.
2) Threshold limit is 5000 for normal user and 20,000 for administrator.
3) Not using “SPQueryThrottleOption.Override” property.
I am amaze why I am not getting listview threshold exceed exception when result set scanned by query in any folder is greater than threshold limit.
The source code is attached for getting data from list folder’s.
I need help in this case.
Regards,
Sanjay
Why don’t you adjust the list view threshold on the server? It is probably a fluke in the underlying APIs in SharePoint, or, it is related to how your particular query is processed.
I would simply say that it probably should be throwing the exception on the folder query also, but isn’t.
Maybe I’m missing the point of your question.
