Maximum volume of Data fetched from SAP table at a time using SAP ODATA

[marimuthuvellaichami]

Hi Experts,

I am new to SAP ODATA.
Please help me to get this answer.
How many records we can fetch from single table at a time using SAP ODATA.

My database table contains 25,000 records. Is it possible to fetch all the records at a time?

Thanks,

Mari...

[kammaje_cis · Accepted solution]

Mari,

There is no such limit at the Gateway level. But keep in mind that there might be various timeouts like sql / http / RFC at various server levels. (ECC/ Gateway / web dispatcher), which might stop you from doing that.

But I do not see any practical scenario for fetching 25,000 records at a time. If it is UI5, you have to use lazy loading feature (pagination). Why do you need to fetch so many records at a time?

Regards

Krishna

[marimuthuvellaichami · Accepted solution]

I don't know the actual purpose.
My client wanted this feature.

[marimuthuvellaichami]

Thank you Krishna, Jibin and Ashwin for your answers..

Its very helpful..

[AshwinDutt]

Hello Marimuthu,

There is no such limit defined on number of records to be fetched.

But we need to make sure we fetch reasonable number of records based on some inputs which will go as part of $filter parameters and get back only matching records from table. This intern will give better performance and would be a good design.

Always fetch only matching records and apply filters as much as possible.

Regards,

Ashwin

[jibin_joy]

Hi Marimuthu ,

Based on my Knowledge , no limit   in data but it is recommended not to get all records !!!

Regards,

Jibin Joy