What's new
  • Upgrade Your Account
    Hello Guest ! Upgrade your account to download from our sections Here.
    How to upgrade your account to download resources Learn More.
    Guest need to see List rather permanently banned Members Learn More.
    Guest need to read through our rules and regulations Learn More.
Optimized List Queries by Xon

Add-ons 2x Optimized List Queries by Xon 2.2.4

No permission to download
Status
Not open for further replies.

NullXF

Team NullXF
XF Root
Messages
10,510
Resources
3,567
Reactions
4,351
NullXF 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.

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 causes an issue as this how conversations and...
Read more about this resource...
 
Status
Not open for further replies.