Performance issue in fetching data using ODATA
I have a requirement where-in I need to retrieve the data using Odata from ECC server and display it in UI5 form such that at a time only a single record is displayed and the user can click on previous and next buttons to view the prev/next record respectively. Now I can see 2 possibilities to achieve this but not sure which one should be followed considering performance issues
1) Retrieve all the records at once using GetEntittySet call and then display one at a time in the UI form Controls.
2) Retrieve only the current record using GetEntity call and call this webservice each time the user clicks on Prev and Next Button.
I guess if the total records are few , probably the 1st approach should not give any issues but considering if the total records are in lakh , would the 1st approach cause any performance issues.
Please suggest what is the general approach we follow in real time in such scenarios