I've been using LEFT JOIN and NATURAL LEFT JOIN for awhile on queries to medium-sized tables (2500->50,000 items) that aren't TOO large by ane means, but have seemingly been having some issues with this. Can anyone here explain to me the memory usage between doing things like: SELECT SUM(tab1.val) FROM tab1 NATURAL LEFT JOIN tab2 GROUP BY tab2.val2 SELECT SUM(tab1.val) FROM tab1 LEFT JOIN tab2 ON tab1.id=tab2.id GROUP BY tab2.val2 SELECT SUM(tab1.val) FROM tab1, tab2 WHERE tab1.id=tab2.id GROUP BY tab2.id ??? seemingly, only the last one is the most reliable - the others start running out of memory as the tables get larger and larger. And then again, sometimes it, too, runs out of memory (different tables/query) and when I go back to a LEFT JOIN, it works fine. -Chris --------------------------------------------------------------------- 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
