Hi, what makes insert faster when doing it every 100 objects? In each case the same number of inserts will be generated.
Can, beside using templates, Cayenne be configured to do something like: INSERT INTO *tbl_name* (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9); That is one insert for 3 rows, which is more efficient (mysql). -Borut 2010/10/18 Michael Gentry <[email protected]> > Hi Borut, > > In addition to what Andrus said about caching Towns, Streets, and > PostOffices, you should also try to do your commits in larger > groupings. One commit at a time will be slower than you want for > something like this. Try grouping 100 or so at a time before you > commit. > > mrg >
