Skip to Content
0

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

Dec 07, 2016 at 02:15 PM

119

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Krishna Kishor Kammaje
Dec 07, 2016 at 02:30 PM
0

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. ?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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.

0
Viswanath Golakoti

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

1