Database, Grails

Batch update performance enhancements using SQL withBatch()

Hi guys, Recently as part of a project, I had to populate a SQLite database with large amounts of data pertaining to a number of classes requiring more than 5000 inserts and updates per class. I created a new SQLite database using Groovy's Sql class. The initial strategy involved creating prepared statements and executing individual...

by Roni C. Thomas
Tag: batch update and insert
05-Jul-2011