Optimized List Queries by Xon 1.8.0

[Shadow_Eagle]

Ashutosh submitted a new resource:

Optimized List Queries by Xon - Optimized List Queries by Xon

Compatible XF Versions1.2 , 2.2Visible BrandingNo
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...

Read more about this resource...

 

[Dekomori]

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

1.8.0

1.8.0

Read the rest of this update entry...