MySQL Forums
Forum List  »  Delphi

Posted by: Bruno Marto
Date: December 27, 2006 12:44PM


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.

Options: ReplyQuote

Written By
December 27, 2006 12:44PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.