Batches to the rescue! Have a look at the SqlMap API, there are startBatch and executeBatch statements. In the docs is an example on how to use those.
HTH 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 [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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.
<<image/gif>>
