BattleParty Fetch Statement heavily unperformant.

ta2edchimp / BattleReporter

Advanced editable BattleReport platform for EVE Online.

1 stars 1 forks source link

BattleParty Fetch Statement heavily unperformant. #78

Closed ta2edchimp closed 9 years ago

ta2edchimp commented 9 years ago

The sql statement at BattleParty.php:L144-163 sucks heavily.
May raise

SQLSTATE[42000]: Syntax error or access violation: 1104 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

Optimization required urgently.