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]
