Optimized List Queries by Xon

Admin submitted a new resource:

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

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…

Read more

.