ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zsolt" <zkoppanyl...@intland.com>
Subject RE: Bad Performance Using Ibatis?
Date Fri, 01 Sep 2006 14:45:17 GMT
You probably need bulk insert.

insert into ... values(...),(...)

That is very fast.

Zsolt

>-----Original Message-----
>From: Ralf Assmann [mailto:ralf.assmann@innovations.de]
>Sent: Friday, September 01, 2006 2:22 PM
>To: user-java@ibatis.apache.org
>Subject: Bad Performance Using Ibatis?
>
>
>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