Optimized List Queries by Xon XF1 MOVED

Sauron · Dec 31, 2017

Sauron submitted a new resource:

Optimized List Queries by Xon 1.3.5 - Optimized List Queries by Xon 1.3.5

Compatible XF Versions
1.4, 1.5
License
MIT Licence
Visible Branding
No
This addon is aimed at large forum with potentially tens of thousands to hundreds of thousands or more threads in a single forum. Smaller forum do not gain much benefit from this addon.

MySQL implements 'early row lookup' which results in the large select statement pulling in more data than is required. Maybe one day MySQL will fix this. Maybe.

This causes an issue as this is how conversations and threads implement...

Optimized List Queries by Xon XF1 MOVED

Sauron

Co-Founder

LegitSpigot

BSMC Amazing Member