2. PHPRunner General questions
  3. SQL_BIG_SELECTS=1
This topic is locked

SQL_BIG_SELECTS=1

 		11/18/2021 11:45:21
PHPRunner General questions
D
 droogers author

When I tried to execute the list I got this failure.

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

On the event: List page: before SQL query I filled in this code.

global $conn;
db_exec("SET SQL_BIG_SELECTS=1;",$conn);
Sergey Kornilov admin 11/18/2021

No experience with SQL_BIG_SELECTS or with this issue but this article at Stackoverflow talks about what else you can try.
D
 		droogers author 11/18/2021

Is the code correct ? Now I use $conn. Do I have to use $strSQL ?
Sergey Kornilov admin 11/18/2021

Most likely this syntax is fine, though I would recommend using Database API.

In either case the problem is that this statement alone will not be enough. You need to read the Stackoverfow article I mentioned and see what else you can try.