• We've added extra Spam Protection. if you get problem with account registration / registration rejected. please contact us
Frank

Free Optimized List Queries by Xon 2.6.0

No permission to download
Compatible XF 2.x versions
  1. 2.1
  2. 2.2
Additional Requirements
php 7.0+
Standard Library by Xon
Visible branding
No
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 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




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
Frank
Downloads
26
Views
700
First release
Last update
Rating
4.00 star(s) 2 ratings

More resources from Frank

Latest updates

  1. 2.6.0 - Feature update

    XFMG support New options "Better XFMG Album List Page Threshold" and "Better XFMG Media-items...
  2. 2.4.0 - Feature update

    Shim reactions received lists (and reactions given if User Essentials is installed) Add various...
  3. 2.3.1 - Maintainance update

    Patch for XF2.1.8 and earlier sorting by position/post_date when getting latest replies, this...
  4. 2.3.0

    Re-release v2.3.0 without debug code.
  5. 2.3.0 - Feature update

    Require XF2.1+ Fix "Better xxx List Page Threshold" options actually accepting 0 as a valid...
Top
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