Optimizing a lot of requests at time

[Stéphane Hanser]

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.