XF Finder join index hints

[Xon]

The XenForo finder system allows index hints applied to the 'from' clause, but not when doing joins.

ie;
SQL:

select *
from a
join b as c use index(d) on c.id = a.id

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 getEntityWith statements could apply an index depending on context or just in the entity...

Read more


free plugins
minecraft paid for free
mcmarket
mc-market
free minecraft paid plugins
free minecraft plugins
spigotmc
SpigotMC
aac free
ewg free
Minecraft Premium Plugins
ewg free download
litebans free
epicworldgenerator free
free schematics
leaked schematics minecraft
schematics
schematics leaked
schematics free
minecraft schematics free
paid minecraft schematics free
paid minecraft schematics for free
free cracked plugins
free cracked minecraft plugins
plugins
featherboard download
featherboard plugin download
antiaura download
xenforo leaked
xenforo for free
xenforo addons