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

Filed under:
|
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

Related posts about mysql-query

Related posts about hangs