This addon 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 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 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 veryhigh 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:


Configuration
Under "Performance":



Télécharger V2.3.0 :

Version 2.3.1 Maintainance update :

Patch for XF2.1.8 and earlier sorting by position/post_date when getting latest replies, this causes an unexpectedly poor query performance
Fix shim for News Feed index choice

Télécharger V2.3.1 :

Version 2.4.0 Feature update :

Shim reactions received lists (and reactions given if User Essentials is installed)
Add various addon options into their own grouping

Télécharger V2.4.0 :

Version 2.5.0 XF2.2 compatibility

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

Télécharger V2.5.0 :

Version 2.6.0 - Feature update ;

XFMG support
New options "Better XFMG Album List Page Threshold" and "Better XFMG Media-items List Page Threshold". For sites with large number of media items, try setting these values to 0

Télécharger V2.6.0 :

Version 2.6.1 - Add feature flag

Add option "Fetch all the nodes at once instead of per-type", for forums with a large enough node-count the per-row XenForo Finder overheads become unacceptable

Télécharger V2.6.1 :

Version 2.7.0 - Feature update

Minor code cleanup
Support threadmark rss feed threadmark listings (Requires Threadmarks v2.11.2+)

Télécharger V2.7.0 :

Version 2.7.1 - Bugfix update

Require Standard Lib v1.7.1+
Adjust class extensions for finders to allow other add-ons to override function getEarlyJoinThreshold().
Developer Warning; access (ie public/protected) is inconsistant and left-as is to avoid backward compatible breaking changes

Télécharger V2.7.1 :

Version 1.8.0 - Maintenance update (with breaking changes)

Update getEarlyJoinThreshold signature to be consistent, which is a backwards compatibility breaking change.
Update Threadmarks Pro (paid) and Watch Threads Filter (paid) add-ons before this add-on.
3rd party add-on may require updating.

Télécharger V2.8.0 :

Version 2.9.0 - Feature update : Add support for Audentio's Feeds add-on, specifically the Thread Feeds

Télécharger V2.9.0 :

Version 2.10.0 : Support conversation lists with large number of conversations (Requires SV/StandardLib v1.10+ for this feature)

Télécharger V2.10.0 :

Version 2.11.0 Feature update : Add support for @Bob's Review Management System.

Télécharger V2.11.0 :

Version 2.12.0 - XenForo 2.3 support :
This addon is now available on https://atelieraphelion.com/

• Require StandardLib v1.20.0+
• Require php 7.2+
• XF2.3 support
• php 8.4+ compatibility fixes

Télécharger V2.12.0 :

Version 2.13.0 - Bugfix & Maintainance update :

• Require StandardLib v1.23.0+
• Only post sort usage patch on old enough XF version
• Improve XFMG v2.3+ compatibility

Télécharger V2.13.0 :