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 > transmission time. Transferring the file in toto to > the US server will be > quicker than having the communications lag of doing > sending a command from > Europe to the US, having the command execute and > then receiving the status > back in Europe...times 5000 records. > > Hope this helps, > > Jack > > -----Original Message----- > From: William Wang [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 06, 2004 1:12 PM > To: [EMAIL PROTECTED] > Subject: many updates really slow > > > 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 "UPDATES" commands in a file cmd.sql and do: > > mysql -hA < cmd.sql > > and it takes 30 MINUTES which is reasonable: 0.3 * > 5000 but unbearable. > > Is there any better way to do this? Am I doing > something stupid? Thanks a lot. > > > > > __________________________________ > Do you Yahoo!? > Win a $20,000 Career Makeover at Yahoo! HotJobs > http://hotjobs.sweepstakes.yahoo.com/careermakeover > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]