XenForo
Administrative
- Thread starter
- Admin
- #1
The XenForo finder system allows index hints applied to the 'from' clause, but not when doing joins.
ie;
SQL:
This is desirable as at some optimization levels recent MySQL version do not correctly select the right index (or ignore it entirely!) for a join.
This would ideally result in a change to the "join" with clauses so the various
Read more
ادامه مطلب...
ie;
SQL:
Code:
select *
from a
join b as c use index(d) on c.id = a.idThis is desirable as at some optimization levels recent MySQL version do not correctly select the right index (or ignore it entirely!) for a join.
This would ideally result in a change to the "join" with clauses so the various
getEntityWith statements could apply an index depending on context or just in the entity...Read more
ادامه مطلب...