Odata service taking longer time to execute

[former_member391501]

Hi experts ,

In backend program I have only one query

Select Name1 Telf2 from kna1 into corresponding fields of table it_final.

Having about 11000+ records ,through program with in a sec giving output properly .

While calling odata service for above code it's taking too much time. Waiting(TTFB) response taking too much time near about 3sec and content download taking 0.58 sec .Total time consuming 4sec.

My question is it my Abap coding issue / UI side problem / Network issue because I m using VPN.

Kindly help me out I m stuck in this ,I m not getting where is the actual problem.

Thanks & regards.

Atul Salgare

[kevin_xu4]

Hi Atul,

You can use the Performance Trace tool (transaction /IWFND/TRACES) to do the trouble shooting mentioned in the link below.

https://archive.sap.com/documents/docs/DOC-51820

https://blogs.sap.com/2016/01/13/sap-gatewayperformance-analysis-of-odata-service-call/

Furthermore, you can refer to the other helpful links below to improve your Odata service

https://help.sap.com/viewer/68bf513362174d54b58cddec28794093/7.4.19/en-US/c6fd2651c294256ee10000000a...

https://help.sap.com/viewer/68bf513362174d54b58cddec28794093/7.4.19/en-US/27eb9cc3f04d44fda07ff19cc2...

https://help.sap.com/viewer/68bf513362174d54b58cddec28794093/7.4.19/en-US/d5a326519eff236ee10000000a...

Best Regards,

Kevin

[former_member391501]

still taking 2.22sec time.

[former_member185414]

Can you check how long its taking in backend system alone. Also is this problem only for your service or some sample services provided by SAP as well ?