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
>>
>>
|