Optimized List Queries by Xon

Optimized List Queries by Xon 2.11.0

No permission to download
  • 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
  • Like
Reactions: vwts and imno007
  • Re-release v2.3.0 without debug code
  • Require XF2.1+
  • Require php 7.0+
  • 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
  • Like
Reactions: vwts
  • 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
  • Like
Reactions: imno007 and SyTry
  • Fix typo causing "Unknown relation _db accessed on xf_news_feed"
  • Like
Reactions: dethfire
  • Shim news-feed to ensure better index handling
  • Trim non-required left-joins when generating the eager join inner query
  • Improve how the 'node type' cache is extended to be more resilient.