itzumar
Posts: 88
|
Posted: 06/05/2013, 5:17 PM |
|
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
what is the solution????????????????????????
_________________
Umar |
|
|
DataDoIT
|
Posted: 06/05/2013, 5:38 PM |
|
what is the question????????????????????????
|
|
|
itzumar
Posts: 88
|
Posted: 06/05/2013, 5:59 PM |
|
when i execute querry which have big database than following error come as follow :
"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"
am using php and mysql. my question is that how to resolve this error?
_________________
Umar |
|
|
DataDoIT
|
Posted: 06/05/2013, 8:28 PM |
|
Your options are to either adjust those variable values on the server
(http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_max_join_size),
or reduce the number of joins in your SQL statements or query.
|
|
|