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.
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.