Good day everyone,

I am using PDI to migrate a database from Oracle to MySQL, I am having some performances issues depending the environment (it works damn fast in the testing one, much slower in the actual prod environment) I am running it in. So I would like to know a little bit what is the tool doing under the hood.

At first I thought that it copied data from 50k rows into local then insert them into the destination Database. But from the logs of the database it seems more like if it was copy data across all the time in smaller chunks. What is the behavior? Is there a way to custom it?

Thank you.