How to Increasing the performance of High-Volume load data test from SAP ECC to Google Spreadsheet

[former_member245614]

Hello Experts,

I performed a load volume test for 100k records of sales order details sync from SAP ECC system to Google Spreadsheet, it is taking around 40 minutes.

Thanks,

M Raveendranad.

[Sandra_Rossi]

So, you're calling the web service once. It means that the whole process has only to do with Internet transmission, Google server processing, etc. The performance "issue" has nothing to do with ABAP. Isn't it obvious?

Either run it in background (wait for the HTTP response) or asynchronously (don't wait for the HTTP response).

[former_member245614]

Hello Sandra Rossi,

Thanks for your quick reply.

If any possible scenarios, Please help me.

Thanks & Regards,

M Raveendranad.

[Sandra_Rossi]

I guess you still didn't undertand our answers... The only solution is to ask your Internet provider to install optical fiber directly between your system and Google's one, like OC-3072... 🙂

[pokrakam]

As I said in my original answer, and as Sandra also pointed out again:

Please remove the line to send the data. Comment out the bit in your red block. Run report again.

If it took 40 minutes before and takes 30 seconds afterwards, it means your program is spending 39 minutes and 30 seconds on the internet. Get a faster internet connection to bring this number down.

If, however, your report still takes a long time then you can look at ABAP options.

[pokrakam]

Let me get this straight, you want to improve your ABAP report to send data faster across the internet?

I'm sorry to disappoint you, but the internet is not like a water pipe where you can increase the pressure to make water flow faster.

Unless your program is really really really bad, the slowest part is almost certainly outside of SAP. Write your data to an internal table and then compare the times. The difference is how much time the network and google take up.

[Sandra_Rossi]

And if the issue is about the "the time bound limit, While Scheduling a Foreground job", then do it in background, there's no timeout (and you could also do it in parallel background jobs if you want).

[Jelena]

Well said. I'm also very curious why on earth would anyone need to send thousands of records from SAP to Google spreadsheet to begin with...

[BJarkowski]

Backup 🙂