if it is part of app. use soap to communicate with server and adopt your
application. Send all your commands as one string parameter to server,
and execute it all there. Such modification to is quite simple to write
using gSoap library (if your application is C++ based) or Axis (Java).
mirza
W
>Thanks Jack and Jeremy.
>But this is part of my application and I need to do
>this automatically. I don't want to write a
>server-client application to just to handle file
>transimission and do pass the update cmd to local
>server. Any idea? Thanks.
If you have ssh installed on both machines.
e file, it goes
back to sleep.
Jack
-Original Message-
From: William Wang [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 1:43 PM
To: Jack Coxen; [EMAIL PROTECTED]
Subject: RE: many updates really slow
Thanks Jack and Jeremy.
But this is part of my application and I need to do
this a
Thanks Jack and Jeremy.
But this is part of my application and I need to do
this automatically. I don't want to write a
server-client application to just to handle file
transimission and do pass the update cmd to local
server. Any idea? Thanks.
William
--- Jack Coxen <[EMAIL PROTECTED]> wrote:
>
I'm guessing here but it sounds like you have the cmd.sql file on your local
machine (in Europe). If that's the case, compress the file, ftp it to the
US server, uncompress it and do the load locally on the US server.
If you're doing the update remotely, you're probably being killed by
transmissi
On Thu, May 06, 2004 at 10:12:19AM -0700, William Wang wrote:
> Hi everyone,
>
> Please help.
>
> I have MySQL server running on host A in US and I am
> using it on host B in Europe. Every query takes about
> 0.3 seconds.
>
> Now I want to do update db with 5000 updates. So I put
> all the "UPDA