Optimized List Queries by Xon

Premium XF2 Add-ons Optimized List Queries by Xon 2.10.0
A collection of replacement queries for getting lists of stuff aimed at large forums.

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 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":
1604830414662.png



Contributing features or bug fixes
Please create a Github Pull request via the "More Information" link.

Contributions

If you appreciate this add-on, please consider a contribution via PayPal. Details will be provide via private conversation.

Please contact me if you wish for different licensing arrangements.
  • Icy Bro
Reactions:FateKid
Author
FateKid
Downloads
0
Total Views
394
Released
Version
2.10.0
Rating
5.00 star(s) 1 ratings

More files from FateKid

Share this resource

Similar resources

[AndyB] Attachment list plus FateKid
Improves look of attachment list below posts.
0.00 star(s) 0 ratings
Downloads
0
[AndyB] Forum list count FateKid
Shows number of forum list views by visitor type.
0.00 star(s) 0 ratings
Downloads
0
[AndyB] Forum list live FateKid
Updates the forum list page automatically.
0.00 star(s) 0 ratings
Downloads
0