Server issue The page is responding too slow after adding "New Threads Widget" in sidebar.

Affected version
2.2
#1
I have just upgraded my website from xf1 to xf2, all things are good but just noticed that as I have added the "New Threads" widget into sidebar, the page is responding bit slow. I have visited all other pages on website, even the thread where this widget is not enabled and all other pages are loading instantly.

Right now I have disabled this widget so please suggest any solution, So I can re-enable it.
 

Chris D

XenForo developer
Staff member
#2
I've temporarily enabled a new threads widget here and it seems to work fine.

Are you able to re-enable it on your own site, temporarily and also enable debug mode by adding the following to src/config.php:
PHP:
$config['debug'] = true;
We'll be able to use the debug output to figure out if we can optimise anything here.
 
#5
@Chris D Disabled the optimizer and it seems, it is working fine now. Thanks
Code:
SET GLOBAL optimizer_switch='block_nested_loop=off'
Note: The above solution is only work if mysql server is minimum to v 5.7
 
Top