Optimized List Queries by Xon 2.13.0

newimage · 2020/07/10

newimage submitted a new resource:

Optimized List Queries by Xon 2.4.0 - Optimized

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.

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

Read more about this resource...

newimage · 2021/04/04

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

newimage · 2021/09/01

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

2.9.0 - Feature update

Add support for Audentio's Feeds add-on, specifically the Thread Feeds

Read the rest of this update entry...

newimage · 2022/02/13

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

2.10.0

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

Read the rest of this update entry...

newimage · 2022/02/13

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

1.8

Ask a question v1.8 changes:
Fixed issue with Enhanced search if using HTTPS index.

Read the rest of this update entry...

axtona · 2022/10/10

thanks to dear member @jessy updated Optimized List Queries by Xon with a new update entry:

V2.11.0

Add support for @Bob's Review Management System

Read the rest of this update entry...

axtona · 2024/07/19

thanks to dear member @jessy updated Optimized List Queries by Xon with a new update entry:

changelog

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

Read the rest of this update entry...

axtona · 2026/02/07

A new update for Optimized List Queries by Xon 2.13.0 is now available for free download. Big thanks to the contribution from our member @axtona !

change log

Require StandardLib v1.23.0+

Only post sort usage patch on old enough XF version

Improve XFMG v2.3+ compatibility

Read the rest of this update entry...