Christofer Dutz wrote:
Hi,

I just ran into a very strange problem. I have two simple tables with BIGINT(16) PKs. The primary table has 7500 records and the secondars has 15000. If I execute:

SELECT * FROM lad JOIN snd ON lad.id = snd.lad_id

The query takes 8 seconds. If I execute this one:

SELECT * FROM lad LEFT JOIN snd ON lad.id = snd.lad_id

I quit the query after 5 minutes.

Why is this so?

Chritofer Dutz


Christofer,

You'll need to provide the list with more information for anyone to be able to help you. What version of MySQL are you running? Can you paste the output of "show create table snd; show create table lad;" Also, do you have other processes using the server that could have locked one of the tables? When the query is taking a long time, try opening a second connection to the server and running "show full processlist;" to see what else is going on.


Regards,
Devananda vdv

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to