ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Lamey <cla...@localmatters.com>
Subject Re: Bad Performance Using Ibatis?
Date Fri, 01 Sep 2006 13:59:20 GMT
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
> 

Mime
View raw message