Best group member, I did this query on a very small database. And it gave error with some MAX_JOIN_SIZE error. I have never seen this, and how can I avoid this to happen? Do I have too many joins in one query? Should I write the joins differently?
++++++++++++++++++++++++++++++ SQL query: SELECT part.joindate AS dateadded, part.profile, part.prefname, part.email, pass.password, pdf.id AS pass1, pdf.password AS pass2, partype.type_desc FROM cmmember LEFT OUTER JOIN cmtest ON ( cmmember.id = cmtest.cmmember_id ) LEFT OUTER JOIN tblparticipants part ON ( part.memberid = cmtest.test_id ) LEFT OUTER JOIN parpass pass ON ( pass.memberid = part.memberid ) LEFT OUTER JOIN profilepdf pdf ON ( pdf.memberid = part.memberid ) LEFT OUTER JOIN tblpartype partype ON ( partype.type_num = part.par_type ) WHERE cmmember.id =6 AND ( pdf.pdftype = 'par' OR pdf.pdftype IS NULL ) ORDER BY part.joindate DESC , part.prefname, part.email LIMIT 0 , 30 MySQL said: #1104 - The SELECT would examine more rows than MAX_JOIN_SIZE. Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ok ++++++++++++++++++++++++++++++ Best regards, Peter Lauri -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
