Add-ons Optimized List Queries by Xon 2.11.0

[XenForo]

XenForo submitted a new resource:

Optimized List Queries by Xon - A collection of replacement queries for getting lists of stuff aimed at large forums

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...

Read more about this resource...

 

[XenForo]

XenForo updated Optimized List Queries by Xon with a new update entry:

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

Read the rest of this update entry...

 

[XenForo]

XenForo updated Optimized List Queries by Xon with a new update entry:

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

Read the rest of this update entry...

 

[alodda]

Latest version IS 1.8.0 not 2.7.1

 

[Marks-Man]

Latest version IS 1.8.0 not 2.7.1

yep, @XenForo the version above is 1.71 not 2.71