I have a store procedure that loads a data to hands-on table when data is more like 7Lakh records it takes more than 40 sec to load the data, now the client is asking to reduce the load time to 10 sec ,
i have optimized my store procedure but no luck,
Now my question is there any technique to load part of the data say 1 lakh and allow the user to do some activity in the UI, in the meantime I can load the remaining records.
How can i achieve it
What I have tried:
Still Working on it, tried auto mapper but no luck