Minimizing time duration when retrieving 13k records from excel file

1
It takes hours to import 13k records from excel files considering the logics used. I believe we are already using the best coding practices so far to prevent longer waiting time during retrieval
asked
2 answers
1

Hi John, 

 

You might be experiencing a a Java Heap Size limitation.  

Try increase the Heap size and test it!

 

 

 

answered
0

Hi John,

How many columns do you want to import? Hours definitely seem to be off. What is your excel import setup? Are you utilizing a staging entity and create a new entry for each row? Or is your template configured in a way that has a direct DB sync and maybe more than one key?

Are you using custom import microflows for date time or something similar?

 

answered