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 "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.
Network latency is killing you. Send the cmd.sql file to host A and execute it locally. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
