How to set SQL_BIG_SELECTS = 1 from VB(legacy ASP) with ADODB environment?
- by conecon
I encountered
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
error with my ASP code.
ASP code has server side ADODB connection with MySQL and connection seems not be able to execute multiple query. How to implement SQL_BIG_SELECTS = 1…
