I am querying a large list with around 25000 items but the data returned is quite small, like 20 items top. Can you please let me know the best practices to do so, for e.g. orderby Indexed column.
I am currently using
rowlimit. Would love to know if
There's something interesting about caching of data returned, not sure about it though!
As data returned is small I don't think
contentIterator will help. I tried the time to execute query with it and without it, doesn't improve.