Optimized List Queries by Xon 2.11.0

[Shayan Xtreme]

Shayan Xtreme submitted a new resource:

Optimized List Queries by Xon - Optimized List Queries by Xon

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

 

[douglassouza]

We found some errors while trying to install the following add-on:Optimized List Queries 2.11.0
The following errors must be resolved before continuing:

• Optimized List Queries requires Standard Library by Xon v1.7.1+.

 

[Shayan Xtreme]

We found some errors while trying to install the following add-on:Optimized List Queries 2.11.0
The following errors must be resolved before continuing:

• Optimized List Queries requires Standard Library by Xon v1.7.1+.

first, install this https://babia.to/resources/standard-library-by-xon.10263/ add-ons then try to install this Optimized List Queries

 

[douglassouza]

Shayan Xtreme Thanks​