Free Xon - Optimized List Queries 2.12.0

[XFDownloadStore]

XFDownload submitted a new resource:

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

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 one day MySQL/MariaDB will fix this. Maybe.

This causes an issue as this...

Read more about this resource...

 

[XFDownloadStore]

XFDownload updated Xon - Optimized List Queries with a new update entry:

2.12.0

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

Read the rest of this update entry...