Hi,
I´m using MySQL version 4.0.5 in Windows and I want to make a JOIN between
two tables that have approximately 20,000 records and 20 columns. As all
the records
from one of the tables must appear in the result of the SQL( the tables
don´t have the same
number of records) , I ought to use a
On 21 Nov 2002, at 8:46, Juan C. P. Garrido wrote:
When I make the LEFT JOIN between the two tables, it takes a long time,
and it seems that the machine is crashed , because everything I try to make
in the machine is extremely slow, so I have to reset it manually.
Do you have indexes on the
Juan,
Thursday, November 21, 2002, 12:46:55 PM, you wrote:
JCPG Iam using MySQL version 4.0.5 in Windows and I want to make a JOIN between
JCPG two tables that have approximately 20,000 records and 20 columns. As all
JCPG the records
JCPG from one of the tables must appear in the result of the
Keith C. Ivey wrote:
On 21 Nov 2002, at 8:46, Juan C. P. Garrido wrote:
When I make the LEFT JOIN between the two tables, it takes a long time,
and it seems that the machine is crashed , because everything I try to make
in the machine is extremely slow, so I have to reset it manually.
