Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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


Helpful Answer

Not what you were looking for? View more on this topic or Ask a question