ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ralf Assmann <ralf.assm...@innovations.de>
Subject Re: Bad Performance Using Ibatis?
Date Fri, 01 Sep 2006 18:13:00 GMT
No, I am not batching the insert. This will not work with the 
application we want to use ibatis for ... If a make the test with 
batching, ibatis is also slower than jdbc-statements (prepared 
statements), but not twice the time.

Therefore, autocommitting is false. The commit will be done by 
sqlMap.commitTransaction(). This works, because without using this in 
the test, no data are in the database table.

Chris Lamey schrieb:
> 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

View raw message