ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kengkaj Sathianpantarit" <kengka...@gmail.com>
Subject Re: Performance question - INSERT statement using ibatis.
Date Sat, 07 Mar 2009 08:58:34 GMT
Have you used batch execution?

Best Regards,
Kengkaj S.
email: kengkaj.s@gmail.com
----- Original Message ----- 
From: "JeanNiBee" <John.Bateman@nuance.com>
To: <user-java@ibatis.apache.org>
Sent: Saturday, March 07, 2009 1:09 PM
Subject: Performance question - INSERT statement using ibatis.


I’m just curious if you any one has performance tips I could us when
inserting (or updating) many rows of data in the database.

My tests are currently querying 10k rows of data from a DB and processing
this data w/ a Row handler... these 10k rows turn into what I'll call about
400 modules (Summarized data / counts of what the row handler iterated
over). All this runs in about 20 seconds. Once this is complete I have to
update that Moule state in my database, no matter what I try (wrt java
optimizagion of memory / object creation etc) I can't get better than 1
insert/update per second. Seems VERY poor to me.

Note: I am using MSSQL Server 2005.

I"m using 'vanilla' ibatis w/ a query file and nothing special with respect
to connection pooling and all that so anything you all can point me too
would be good.

I'll check out my execution plan in the meantime but I am not sure this will
find anything as it's a simple 'INSERT' or 'UPDATE'. No crazy indices on the
table or anything like that.

Thanks for the help!
View this message in context: 
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

View raw message