Welcome to our Community
Be apart of something great, join today!
Register Log in

XenForo Add-on Optimized List Queries by Xon 2.10.0 - Feature update

No permission to download
Optimized List Queries by Xon
Compatible XF Versions
  1. 2.0
  2. 2.1
  3. 2.2
Visible Branding
Please notice that this addon requires Standard Library by Xon 1.7.0+!

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 how conversations and threads implement paging.

This addon provides some optimized query for getting threads in a forum with large number of threads, or for conversations with a very high page count.

Ideally conversations would implement the position system like posts do, which would be even faster than using sub-selects to force 'late row lookup'.

For more information see:
Under "Performance":
  • 1604830414662.png
    72.9 KB · Views: 42
  • Like
Reactions: Vitreus
First release
Last update
0.00 star(s) 0 ratings

More resources from zaldo

Latest updates

  1. 2.10.0 - Feature update

    Support conversation lists with large number of conversations (Requires SV/StandardLib v1.10+...