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