[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?