xF2 Add-on Optimized List Queries by Xon 2.11.0

[ENXF NET]

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

Read more about this resource...

 

[ENXF NET]

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

2.1.1 - Maintenance update

• Improve how the 'node type' cache is extended to be more resilient.

Read the rest of this update entry...

 

[ENXF NET]

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

2.1.2 - Maintenance update

• Trim non-required left-joins when generating the eager join inner query

Read the rest of this update entry...

 

[ENXF NET]

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

2.2.1 - Bugfix update

• Fix typo causing "Unknown relation _db accessed on xf_news_feed"

Read the rest of this update entry...

 

[ENXF NET]

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

2.2.2 - Bugfix update Add bookmark

• Fix XF2.1 compatibility issue when viewing recent activity news-feed as a user who is following other users

Read the rest of this update entry...

 

[ENXF NET]

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

2.2.3 - Bugfix update

• Fix 'show older items' in news feed would not return as expected

Read the rest of this update entry...

 

[ENXF NET]

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

2.3.0 - Feature update

• Require XF2.1+
• Fix "Better xxx List Page Threshold" options actually accepting 0 as a valid value.
  • This is useful to work-around poor MySQL 8+/MariaDb 10.4 performance issues with Collaborative Threads add-on

Read the rest of this update entry...

 

[ENXF NET]

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

2.3.0

• Re-release v2.3.0 without debug code

Read the rest of this update entry...

 

[sucre13]

ENXF NET update

 

[ENXF NET]

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

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

Read the rest of this update entry...

 

[ENXF NET]

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

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

Read the rest of this update entry...

 

[ENXF NET]

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

2.5.0 - XF2.2 compatibility update

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

Read the rest of this update entry...

 

[ENXF NET]

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

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

Read the rest of this update entry...

 

[ENXF NET]

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

 

[elmenda]

update please

 

[sucre13]

update please

elmendahere you have

 

[ENXF NET]

here you have

sucre13You can update it in resource on the forum

 

[ENXF NET]

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

2.7.0 - Feature update

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

Read the rest of this update entry...

 

[ENXF NET]

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

 

[ENXF NET]

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

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.

Read the rest of this update entry...