Excel importer performance issue

0
Hello, In one of our Mendix application we are using excel importer to import data. We are seeing that it is taking approximately 5 minutes to import a sheet with 1000 rows and 4 columns.  We have a different mendix application running on the same version (Mendix and Excel importer) in which the same excel file is taking less than a  second to import.   Please advise on how we can optimize the excel importer. Mendix version: 7.23.3 Excel importer: 5.19.0 We tried deleting the ExcelImporter and MxModelReflection modules and re-importing them but it did not help. Console log: 2019-05-28 19:38:08.369ExcelXLSReader               Starting XLS import Template: 1  2019-05-28 19:42:48.336ExcelImporter                  Statistics, Objects of type 'Module.Entity' (...) 2019-05-28 19:42:48.336ExcelImporter                  Statistics, Objects of type 'Module.Association / Module.Entity' (...) 2019-05-28 19:42:48.770ExcelImporter                   Statistics   -   FINAL statistics, Objects of type 'Module.Entity'  (...) 2019-05-28 19:42:48.770ExcelImporterStatistics   -   FINAL statistics for association: Module.Association / Module.Entity of type 'Module.Entity'  (...) 2019-05-28 19:42:48.770ExcelXLSReader                Successfully finished importing 1     
asked
1 answers
0

Obviously the second step is the problem.

2019-05-28 19:38:08.369ExcelXLSReader               Starting XLS import Template: 1 
2019-05-28 19:42:48.336ExcelImporter                  Statistics, Objects of type 'Module.Entity' (...)

You can debug through the Excel importer module to pinpoint exactly the microflow that is slow.

answered