MSDE -> mySQL -> MSDE

[Bruno Marto]

Hello,

I am working on a project that needs to compare data of one local workstation and a remote server.
The local workstation has MSDE DB and the remote server has mySQL DB.

Currently I'm performing the following operation:

retrieve the data of MSDE DB -> CSV File -> upload to remote server -> use php to insert the datain mySQL -> write to csv file -> download to local workstation -> insert into MSDE

At first, I thought the following operation : MSDE -> mySQL -> MSDE would be a million :) times faster,but I was wrong. It is much slower.
How may I improve the transaction speed of this process, knowing that I have a remote server?

All this is beeing built under a Delphi application.