[Xon] Optimized List Queries 2.13.0 2026-03-05

[NitroNitro is verified member.]

Nitro submitted a new resource:

[Xon] Optimized List Queries 2.13.0 - Provides some optimized query for getting threads in a forum with large number of threads

Requires Standard Library addon.

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/Reactions/XFMG 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...

Read more about this resource...