How to Optimize performance issue while importing/Exporting CSV data in mendix along with additional logic.

Hi Team,   I have to import a CSV file which is having 15 columns in it with almost 1000+ records. While importing validation checks are happening along with adding new original entity based on the CSV records, so to process this its taking lot of time to import which I need to optimize. Can any one suggest me best way to optimize my code so that importing CSV with validation will faster.
1 answers

Hi Ajitha Deborah D,


Are validation checks also reading data from the database? If so, I would reduce the time to get that data in, using XPath (to prevent all data from being consumed) and use indexes. If feasible (from data/memory size), load data to validate against, in a List and use list operations to perform tasks. 


Go Make It