how to fetch 3000 records from ODATA in FIORI/UI5 without effecting performance.

[Viswanath]

Hi Everyone,

How to fetch 3000 records from ODATA in FIORI/UI5 without effecting performance.

When I am using growingThreshold=20 performance is good but I am getting only 20 records at a time.

If I am using growingThreshold=2000 it's impacts performance (6.5 mins) to display all records.

Could anyone please suggest how to fetch all record without any performance issue.

Thanks,

Best Regards,

Viswanath

[kammaje_cis]

When you scroll down after 20, you can make another call for next 20 and so on. That is the concept of 'Growing'.

You need to ensure that pagination is implemented in the Gateway service.

There is no way not to get impacted by performance if you are fetching 3000 rows. Why would you require all 3000 at a time. ?

[Viswanath]

Thanks for your response.

To download all record to excel we want all records at a time. If not we are able to download only 20 records at a time. After scroll we can download next 20 records.

[former_member201114]

you could download a whole entity set just by adding $format=xlsx to the service url