ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marc.Heim...@prolifics.de
Subject Re: Optimizing a lot of requests at time
Date Thu, 07 Jun 2007 10:20:25 GMT
Batches to the rescue!

Have a look at the SqlMap API, there are startBatch and executeBatch 
In the docs is an example on how to use those.

Marc Heimann
Software Engineer

Prolifics Deutschland GmbH
Notkestr. 3, D-22607 Hamburg
phone +49 (0)40 890 667-70
fax    +49 (0)40 890 667-99
2007 IBM Award Winner for Overall Technical Excellence
SOA... Building Future Business Solutions Today
Handelsregister: Hamburg, HRB 89903
Geschäftsführer: Ulrich Frotscher

Stéphane Hanser <s.hanser@omegames.com> wrote on 07.06.2007 12:13:03:

> Hi,
> I’m currently programming a tool in order to migrate a database to 
> another. I have a lot of control to do and data to change. I wrote 
> this tool in java using ibatis to access both databases. However, I 
> need to make several hundreds of insert requests and it takes me a 
> lot of time. I used a profiler to analyze the source and noticed 
> that each request is really time consuming. I wondered if there was 
> a way to speed it (by doing  1 000 requests at time for instance)
> Thank you in advance,
> Stéphane H.
View raw message