Optimized List Queries by Xon

xF2 Add-on Optimized List Queries by Xon 2.6.1

No permission to download
Compatible XF Versions
2.0, 2.1, 2.2
Visible Branding
No
Additional Requirements
php 7.0+
Link XF Versions
XF2.1: https://enxf.net/resources/optimized-list-queries-by-xon.834/version/4755/download
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 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":
optimized-list-queries.png

Contributing features or bug fixes
Please create a Github Pull request via the "More Information" link.
Author
ENXF NET
Downloads
49
Views
538
Last update
Rating
5.00 star(s) 1 ratings

More resources from ENXF NET

Latest updates

  1. 2.6.1 - Add feature flag

    Add option "Fetch all the nodes at once instead of per-type", for forums with a large enough...
  2. 2.6.0 - Feature update

    XFMG support New options "Better XFMG Album List Page Threshold" and "Better XFMG Media-items...
  3. 2.5.0 - XF2.2 compatibility update

    Requires php 7.0+ Now depends on Standard Library by Xon Confirmed XF2.2+ support

Latest reviews

very nice too and i have a found never better tool
Top