Why does this MySQL Query hang?
Posted
by zzapper
on Stack Overflow
See other posts from Stack Overflow
or by zzapper
Published on 2010-04-07T09:25:36Z
Indexed on
2010/04/07
9:33 UTC
Read the original article
Hit count: 254
mysql-query
|hangs
SELECT *
FROM tbl_order_head AS o
INNER JOIN tbl_orders_log AS c
ON o.PAYMENT_TRANSACTION_LOG_ID=c.TRANSACTION_ID
WHERE o.VISUAL_ID = '77783';
tbl_order_head 67,000 (30 fields) records, tbl_orders_log 17000 (5 fields) records. I don't know if it would eventually return as I am running it on a live server and fear overloading.
I am doing similar queries and much more complex queries successfully.
© Stack Overflow or respective owner