Im facing with performance issue. My current flow is, create association between column in one table to the other master data, about 14 master data. I created a microflow with excelImporter to handle that, it work normally with small data. But when i tried to import an excel file with 80k record, it take long time to run, sometime it crash the app. Any body have getting the same problem with it ? Any way to solve that ? Thanks.
This has been asked many times before on this forum so I think you can find more answers on the forum. With large amounts of Excel rows it is best to process the records (after the ImportByTemplate Java action from the Excel Importer module) in batches via the task queue. Large being 50.000+ rows.
Thanks @Ivo Sturm. The problem here while importing the file that crashed the app with the error like that