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 viewfields and rowlimit. Would love to know if orderby helps! 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.

  • I would suggest ContentIterator should be helpful.. Use query.ListItemCollectionPosition – Gaurravs Feb 1 '16 at 7:05
  • it helps when data returned is high – Taran Goel Feb 1 '16 at 7:07
  • Can you tell what you mean by TOP 20, most recent modified or created 20 ? – Gaurravs Feb 1 '16 at 7:11
  • it meas the highest number of items returned would be 20 – Taran Goel Feb 1 '16 at 7:13

Your Answer

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

Browse other questions tagged or ask your own question.