Another issue that is easy to overlook is your indexing. If you have a lot of
indexing and keep increasing the database, expect to see a significant
slowdown during inserts into a well populated db, compared to an empty one.
Since you were trying on local machine first, and networked later, it
> It would be helpful to know how much data you are trying to pump across.
> If you are having trouble finishing in under 30 seconds over a 100mb
> connection, it must be a lot of data.
> The first thing to check is to make sure you have your connections set
> to full duplex. Even if there are o
> I just got done playing with this same scenario.
>
> If the task finishes locally OK, but totally dogs on the network, then you
> may have a network issue, NOT a MySQL issue.
>
> 1) Make sure that the switch and boxes are set to full duplex operation.
> This will eliminate collisions. Make s
client or the other way around and see
what
the transfer rates are.
Jeroen
-Original Message-
From: Brent Baisley [mailto:brent@;landover.com.]
Sent: Friday, October 25, 2002 9:20 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Performance over a network
It would be helpful to
. This is good application design.
-Original Message-
From: Brent Baisley [mailto:brent@;landover.com.]
Sent: Friday, October 25, 2002 9:20 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Performance over a network
It would be helpful to know how much data you are trying to pump
I just got done playing with this same scenario.
If the task finishes locally OK, but totally dogs on the network, then you
may have a network issue, NOT a MySQL issue.
1) Make sure that the switch and boxes are set to full duplex operation.
This will eliminate collisions. Make sure that everyt
It would be helpful to know how much data you are trying to pump across.
If you are having trouble finishing in under 30 seconds over a 100mb
connection, it must be a lot of data.
The first thing to check is to make sure you have your connections set
to full duplex. Even if there are only two ma
