itzumar
Posts: 88
|
Posted: 01/06/2014, 10:29 AM |
|
Database Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
how to write this querry in code chrage studio to executemain querry can any well help?????
SET SQL_BIG_SELECTS=1
_________________
Umar |
|
|
eratech
Posts: 513
|
Posted: 01/06/2014, 4:15 PM |
|
Umar - that looks like a Database error (MySQL probably), not Codecharge.
Unless you change your query WHERE to have fewer rows then it will probably still happen.
If you are doing JOINs you might be getting bigger datasets than you think - therefore you get the MAX_JOIN_SIZE error. For example, google "cross-product" joins which often cause problems.
Check out this similiar question on stackoverflow with several solutions:
http://stackoverflow.com/questions/950465/mysql-sql-big-selects
Eric
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia |
|
|
|