Active Record: SET SQL_BIG_SELECTS

[eluser]stef25[/eluser]
When running a query that join data from 3 large tables I'm getting an error that says

Code:

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

SET SQL_BIG_SELECTS can be sent in a mysql config file but apparently also "on a session basis". Anyone know how I can use this in CI's Active Record implementation?

[eluser]InsiteFX[/eluser]
You can try this, but I have not tested it!

Code:

$this->db->query('SET SQL_BIG_SELECTS=1');

InsiteFX

[eluser]Unknown[/eluser]
It does work for me. Thanks!