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
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
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 mysql@lists.mysql.com
Sent: Wednesday, May 03, 2006 7:03 PM
Subject: Table so slow to read
Hi
