Optimized List Queries by Xon 2.6.1

[themka]

Optimized List Queries by Xon

This add-on is aimed at large forum with tens of thousands to hundreds of thousands or more threads in a single forum. Smaller forum do not gain much benefit from this add-on.

Member List/Forum/Conversation/Reactions/XFMG lists:

MySQL/MariaDB implements 'early row lookup', when combined with LIMIT & OFFSET with a large offset, results in the large select statement pulling in more data than is required. Maybe one day MySQL/MariaDB will fix this. Maybe.

This causes an issue as this...

[svgdemo]https://forum.warezm.com/scriptler/optimized-list-queries-by-xon.2213/[/svgdemo]
[svgfile]https://forum.warezm.com/scriptler/optimized-list-queries-by-xon.2213/[/svgfile]

​