Collaborative Threads

Collaborative Threads 2.11.1

No permission to buy ($45.00)
XF1 Version

Q. With this add-on enabled, there is very poor performance.
A. Later versions of MySQL/MariaDB will use "block nested loop" joins, which can have very poor performance.
  • Ensure the option "Thread list: use separate query to fetch collaborative thread user information" is enabled.
  • For MySQL 8+ , set optimizer_switch='block_nested_loop=off' in the server's config
  • For MariaDb 10.4+, set optimizer_use_condition_selectivity=1 in the server's config
Or use Optimized List Queries v2.3.0 with the "Better Thread List Page Threshold" option set to 0
Top Bottom