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 the 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" <mysql@lists.mysql.com>
Sent: Wednesday, May 03, 2006 7:03 PM
Subject: Table so slow to read
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 database copy (exactly the same tables) the
program give me the result fast.
The two servers are exactly the same (mysql 5.0.15), the application
was developed in Delphi with Zeos componentes
What could it be the problem?
Over the server there are 75 connections, but we have
max_connections=200;
Thanks.
--
Saludos cordiales.
------------------------------------------------------------------------
Ing. Gabriel Mahiques
Dto. Control de Gestión
ELECTROINGENIERA S.A.
Telefono: 474 1414
Uspallata 1461. Barrio San Martín. CP: X5008HSH
Córdoba. República Argentina.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
********** DISCLAIMER **********
Information contained and transmitted by this E-MAIL is proprietary to
Sify Limited and is intended for use only by the individual or entity
to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable
law. If this is a forwarded message, the content of this E-MAIL may
not have been sent with the authority of the Company. If you are not
the intended recipient, an agent of the intended recipient or a
person responsible for delivering the information to the named
recipient, you are notified that any use, distribution, transmission,
printing, copying or dissemination of this information in any way or
in any manner is strictly prohibited. If you have received this
communication in error, please delete this mail & notify us
immediately at [EMAIL PROTECTED]
Watch India vs. England LIVE, Hot videos and more only on Sify Max!
Click Here. www.sifymax.com
Get to see what's happening in your favourite City on Bangalore Live!
www.bangalorelive.in
--
Saludos cordiales.
------------------------------------------------------------------------
Ing. Gabriel Mahiques
Dto. Control de Gestión
ELECTROINGENIERA S.A.
Telefono: 474 1414
Uspallata 1461. Barrio San Martín. CP: X5008HSH
Córdoba. República Argentina.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]