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.
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 th
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 t
