Optimized List Queries by Xon

Optimized List Queries by Xon 2.3.0

No permission to download
  • 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
  • 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.
  • Extend node list loading code to reduce query count on viewing the forum list or a forum with child nodes.
    • Removes 2-4 queries depending on the number of unique node types (forum/link forum/category/page/etc) in the node list.
    • Avoids sending a potentially huge list of node ids into MySQL queries for node type's extra content.
  • Like
Reactions: dethfire