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
