Optimized List Queries by Xon

xF2 Add-on Optimized List Queries by Xon 2.10.0

No permission to download
Compatible XF Versions
  1. 2.0
  2. 2.1
  3. 2.2
Additional Requirements
php 5.6+
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 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 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 veryhigh 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":

1545403033435-png.191038




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 licencing arrangements.
Author
Admin
Size
26.8 KB
Extension
zip
Downloads
30
Views
1,421
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from Admin

Latest updates

  1. 2.10.0 - Feature update

    Support conversation lists with large number of conversations (Requires SV/StandardLib v1.10+...
  2. 2.9.0 - Feature update

    Add support for Audentio's Feeds add-on, specifically the Thread Feeds
  3. 2.8.0 - Maintenance update (with breaking changes)

    Update getEarlyJoinThreshold signature to be consistent, which is a backwards compatibility...

Similar resources

Advanced Node List Widget Admin
A handy widget for displaying nodes in your sidebar
0.00 star(s) 0 ratings
Downloads
2
Updated
Email List Verify Integration Admin
Allows checking if the email exists before it can be used using Email List Verify.
0.00 star(s) 0 ratings
Downloads
10
Updated
Exclude Subcategory resources from list - XF2 AnimeHaxor
Exclude subcategories resources from being displayed in category resource list.
0.00 star(s) 0 ratings
Downloads
4
Updated
Expanded Category List Menus Admin
Choose whether category widget menus will be expanded or collapsed by default
0.00 star(s) 0 ratings
Downloads
1
Updated
GTRS Boost list Admin
gtrs boost fetch, boost informations
0.00 star(s) 0 ratings
Downloads
2
Updated
AdBlock Detected

We get it, advertisements are annoying!

Sure, ad-blocking software does a great job at blocking ads, but it also blocks useful features of our website. For the best site experience please disable your AdBlocker.

I've Disabled AdBlock