SQL Bulk Insert Data into SAP HANA

Hello,

in an Application Engine script we are using the SQLBulkInsertData function to write ~100.000 rows to SAP HANA.

This process takes around 10 minutes and it seems like the inserts are executed row by row instead of being inserted in larger bulks.

Do you have any ideas of how to speed this up?

Thanks and best regards

Mario

Find more posts tagged with

That should not happen with SQLBulkInsertData. Any chance there's a loop wrong in your script? Can you show your code (or parts of it)?

i think only postgre and ms sql have optimized bulk insert implemented at the moment.

Hm I think this is not the case. When executing the exact same script with a connection to SQL Server, it finishes within a few seconds.

Ok, that would explain it. Thanks!