How do I increase the MAX_JOIN_Size when my script gives an error about it being too low?

MySQL will not execute select statements that directly examine a very large number of rows.  Either adjust your select statement to make it more efficient, such as using index fields instead, or set SQL_BIG_SELECTS=1 in the session before executing the select statement.

To set the SQL_BIG_SELECTS=1, use the following code:

$db->sql_query(“SET SQL_BIG_SELECTS=1”);

Article ID: 21
Created On: Mon, Mar 2, 2015 at 5:07 PM
Last Updated On: Thu, Apr 23, 2015 at 10:39 AM

Online URL: https://www.heartinternet.uk/support/article/how-do-i-increase-the-max_join_size-when-my-script-gives-an-error-about-it-being-too-low.html