Optimized List Queries by Xon

xF2 Add-on Optimized List Queries by Xon 2.6.0

No permission to download
XFMG support
  • New options "Better XFMG Album List Page Threshold" and "Better XFMG Media-items List Page Threshold". For sites with large number of media items, try setting these values to 0
  • Shim reactions received lists (and reactions given if User Essentials is installed)
  • Add various addon options into their own grouping
  • Patch for XF2.1.8 and earlier sorting by position/post_date when getting latest replies, this causes an unexpectedly poor query performance
  • Fix shim for News Feed index choice
  • Re-release v2.3.0 without debug code
  • Require XF2.1+
  • Fix "Better xxx List Page Threshold" options actually accepting 0 as a valid value.
    • This is useful to work-around poor MySQL 8+/MariaDb 10.4 performance issues with Collaborative Threads add-on
  • Fix 'show older items' in news feed would not return as expected
  • Fix XF2.1 compatibility issue when viewing recent activity news-feed as a user who is following other users
  • Fix typo causing "Unknown relation _db accessed on xf_news_feed"
  • Trim non-required left-joins when generating the eager join inner query