[sql] SQL_MAX_JOIN_SIZE i SET SQL_BIG_SELECTS Opcje

[pturkowski]

Witam,
sprawa jest ponadkrytyczna. Probujac wykonac zapytania dostaje:

[HTML] pobierz, plaintext 
user warning: 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 query: SELECT DISTINCT(node.nid),
users.name AS users_name, users.uid AS users_uid, profile_prenom.value AS profile_prenom_value,
profile_city.value AS profile_city_value, profile_regionlive.value AS profile_regionlive_value,
profile_placeoliving.value AS profile_placeoliving_value, profile_startdateevs.value AS profile_startdateevs_value,
profile_enddateevs.value AS profile_enddateevs_value, profile_cooriginevs.value AS profile_cooriginevs_value,
profile_coevs.value AS profile_coevs_value, profile_cityevs.value AS profile_cityevs_value
FROM node node LEFT JOIN users_roles users_roles ON node.uid = users_roles.uid
INNER JOIN users users ON node.uid = users.uid LEFT JOIN profile_values profile_wantmen
ON users.uid = profile_wantmen.uid AND profile_wantmen.fid = '5' LEFT JOIN profile_values profile_prenom
ON users.uid = profile_prenom.uid AND profile in /home/sites/xxx/public_html/includes/database.mysql.inc on line 172.
[HTML] pobierz, plaintext 

(to ja polamalem linie, bo normalnie to jest jedna linia)
wiec moje pytanie: jak ustawic to MAX_JOIN_SIZE na trwale, w niewiem... php.ini? albo gdzies
tu jest tak przy okazji Drupal, ale to chyba nie ma znacznia.

Pozdrawiam, i czekam z nieciepliwoscia na odpowiedzi.

OK, znalzlem ze u mnie:
MAX_JOIN_SIZE=900000
ale SQL_BIG_SELECTS=OFF
co poczac?

Ten post edytował pturkowski 18.09.2007, 10:37:58