Optimized List Queries by Xon

Optimized List Queries by Xon 2.5.0

No permission to download
Compatible XF 2.x versions
  1. 2.1
  2. 2.2
Additional requirements
php 7.0+
Standard Library by Xon
MIT Licence
Visible branding
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 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":

Contributing features or bug fixes
Please create a Github Pull request via the "More Information" link.


If you appreciate this add-on, please consider a contribution via PayPal. Details will be provide via private conversation.

Please contact me if you wish for different licencing arrangements.
First release
Last update
5.00 star(s) 2 ratings

More resources from Xon

Latest updates

  1. 2.5.0 - XF2.2 compatibility update

    Requires php 7.0+ Now depends on Standard Library by Xon Confirmed XF2.2+ support
  2. 2.4.0 - Feature update

    Shim reactions received lists (and reactions given if User Essentials is installed) Add various...
  3. 2.3.1 - Maintainance update

    Patch for XF2.1.8 and earlier sorting by position/post_date when getting latest replies, this...

Latest reviews

A great add-on that solves forums issues not only with query performance. But besides this, the ugliness of the developers that causes the XenForo Media Gallery rules. Thanks to this add-on, mysql can completely solve the problem with slow queries, in addition, it is ruled by such a disgrace https://xenforo.com/community/threads/xf-finder-join-index-hints.173114/. If you have an average forum, then you should think about this addition already.
Big forums suffer a lot of performance issues. It's great to see a top notch addon author like Xon try to lessen the load and make things faster. Thanks!