Performance and scalability: speed up data saving
good day, 1. i have grid that hosts more than 2000 records. 2. i get the xml of the grid. 3. parse the xml to an ArrayList. 4. call the DAO. 5. save the data in db through procedure. but in db, i employ a for loop to iterate through the arrayList. so it's taking almost 45 seconds to store. is there a way to speedup the saving process. instead of parsing the xml in step 3, can we parse xml in procedure and save?