Data import performance improvement through hot folder

[Former Member]

Hello Team, I am using hot folder to load data into product catalog..There are only two attribute where i am loading 200+mm of data into that . But currently i am seeing only 1mm of record inserting in 3+ hrs. I would like get 1 MM of record get done with in 1 hrs. Could you please share few points to improvise the data import.

I am using hana as data base . Also impex worker thread increase to 6 as we do have 6 . cpu

[Former Member · Accepted solution]

Hi i have modified below properties and able to reduce almost 2+ hrs to load 1MM.

 acceleratorservices.batch.impex.max-threads =24
 impex.legacy.mode = true
 impex.import.workers=9