Xon - Optimized List Queries

Xenforo 2.2.x Xon - Optimized List Queries 2.5.0

No permission to download Buy VIP
  • Hi Guest, Do you have an idea for us? Post it here and maybe you will win the VIP Master package! (VIP For the rest of your membership!)
Compatible XF Versions
  1. 2.1.x
  2. 2.2.x
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 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 how conversations and threads implement paging.

This addon provides some optimized query for getting threads in a forum with large number of threads, or for conversations with a very high page count.

Ideally conversations would implement the position system like posts do, which would be even faster than using sub-selects to force 'late row lookup'.

For more information see:
Configuration
Under "Performance":
191038
Author
WinSys32
Downloads
0
Views
83
Extention type
zip
File size
20.9 KB
Hash
7799ee0c8e8395f4832b4ab0723ffb15
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from WinSys32