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

Affected version
2.2
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
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.
 
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:
I have tested it again and set the debug = true as you suggested, but there is nothing showing on frontend as output of this.
 
@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