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. Ever
s 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
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
n 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 slo
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
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
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 MINU