Hi.
I know that's already been discussed few times in the past, but I have found the performance of Table Output quite staggering.

I had to upload records to a table on a remote server so I tried with PDI.
Text input file, Table Output using MySQL.
The loading speed was 40/50 records/seconds.

Since it would have taken hours to complete, I gave up and use Toad instead (http://www.toadworld.com/).
It loaded all my records in less than 1 hour!

Since the PC was the same, same file, same internet connection, same destination database (and table), what is PDI doing differently?

My configuration:
PDI 4.4
Win Server 2003
MySQL driver: mysql-connector-java-5.1.22-bin.jar

MySQL version on remote database: 5.1.68-cll

What should I change in my PDI configuration to match the upload speed of TOAD?

Mick