I came across many posts about the max records fetching limit is 2000.
For the scenario where I have 500000 records and I need to fetch records based on a specific criteria which would fetch around 10000 records.
My understanding is using delegate can fetch first 2000 records meeting criteria.
I want to display all 10000 records. In this scenario Implementing pagination would help?
Or is there any optimized approach?
Please suggest how to handle such kind of scenarios.
Thank you in advance
-Pardha
Thank you. Planning to have pagination. Hope it helps.
How are users going to use 10000 records at once?
To overcome the delegation issue, you could leverage GRAPH API.
https://www.youtube.com/watch?v=ZzWdXiMzA-c
Also, here are a few more videos on managing delegation.
https://www.youtube.com/playlist?list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD
Michael E. Gernaey
9
Super User 2025 Season 1
bscarlavai33
5
Super User 2025 Season 1
getsplash
2