1) See if the DNS on one machine is different. If it's trying to
resolve the host on one and failing, that might be why it's slow.
2) how did you copy the database?
3) what's the data usage like on each machine? If one machine is
used a lot and the other is used very little, then it may be
Gabriel Mahiques schrieb:
My name is Gabriel, "Saludos Cordiales" is the same than "Best Regard"
in spanish.
The server explanin is the same. The table structure is the same, the
application is the same (redirect the data source only), the quantity
of record is the same. All is the same, I copy
he database from one
server to other
Prasad escribió:
Hi Saludos cordiales.,
For both the server the explain plan is same?
-Prasad
Sify.
- Original Message - From: "Gabriel Mahiques"
<[EMAIL PROTECTED]>
To: "MySQL Lista"
Sent: Wednesday, May 03, 2006 7:03 PM
Hi frieds. I have the next problem.
I have a dedicated server with tables and I have a program that read
some tables of this server.
But when the program consults over 1 table (the query's result are a few
records) it is very slow. But if I execute the same program in other
server with a databa
