Florin Andrei writes:
> SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \ > tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123'; > > The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let > it run over night, in the morning i still didn't got any results, so i > killed the query). What're the table structures (most importantly: what indices exist)? What does the data look like? What did EXPLAIN return? Anything else we should know? (that's a catch-all question from a sleepy and intoxicated person, in case you're wondering) //C - scratching his beard -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
