suggestion for impex loading with high number of lines

[crescenzorega]

Hi,

we need to upload an impex file that contains nearly 50,000 lines.

Manual or initialization loading takes a long time, do you have any suggestions to speed up loading?

Regards,

Crescenzo

[geffchang · Accepted solution]

Have you tried increasing the number of threads? In local.properties, you can adjust impex.import.workers, depending on the number of cores of your machine.

See: https://help.sap.com/viewer/d0224eca81e249cb821f2cdf45a82ace/2005/en-US/959c1988185445d4aae46f849828...

[crescenzorega · Accepted solution]

Hi geff.h.n.chang,

i've already gotten a big improvement in loading times by changing INSERT_UPDATE to INSERT.

Now i will try to further optimize the times by reading what is written in the link you indicated.

Regards,

Crescenzo

[geffchang · Accepted solution]

crescenzorega Let me know if it works. 🙂

[crescenzorega · Accepted solution]

Hi geff.h.n.chang

it is not clear to me if I have to set the value of #cores or if it is detected by the platform automatically.

Regards,

Crescenzo

[geffchang · Accepted solution]

crescenzorega #cores is a constant. The platform will detect it. Or, you can explicitly define a fixed value for the property.