Are you batching the inserts? If not, then a commit is done after each insert, which is very slow.
On Fri, 2006-09-01 at 14:21 +0200, Ralf Assmann wrote: > Hi there, > > making a performance test with ibatis, we got a very slow runtime. > Inserting 100000 rows into a table, we took more than twice the time > than using own-written prepared statements. The time was definitely > lost during the transaction time writing the data to the database, > calling sqlMap.insert(...). > > Does anyone know if this runtime is normal while using ibatis or is > there any xml-parameter to optimize it? > > Many thanx, > > > Ralf >
