Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: billrune on September 06, 2019, 10:32:12 PM

Title: why my forum so many queries ?
Post by: billrune on September 06, 2019, 10:32:12 PM
this forum - Page created in 0.098 seconds with 19 queries.
my forum - Page created in 1.143 seconds with 78 queries.
Title: Re: why my forum so many queries ?
Post by: vbgamer45 on September 06, 2019, 10:33:15 PM
Do you have a lot of mods installed? That generally causes that to happen if is constant.
You can also look into caching options in SMF as well.
Title: Re: why my forum so many queries ?
Post by: billrune on September 06, 2019, 11:28:54 PM
no mod install. only installed multi language.
i don't know where to check/set the cache. could you tell me ?

thanks
Title: Re: why my forum so many queries ?
Post by: vbgamer45 on September 06, 2019, 11:34:37 PM
Yes under
 Administration Centerâ–º Server Settingsâ–º Caching
Title: Re: why my forum so many queries ?
Post by: billrune on September 06, 2019, 11:35:05 PM
my cache set is level 1 cache
Title: Re: why my forum so many queries ?
Post by: vbgamer45 on September 07, 2019, 01:03:26 AM
You can raise it as well.
Title: Re: why my forum so many queries ?
Post by: SpacePhoenix on September 07, 2019, 01:57:22 AM
Try logging the queries so you might be able to find the culprit: https://dev.mysql.com/doc/refman/8.0/en/query-log.html
Title: Re: why my forum so many queries ?
Post by: Pipke on September 07, 2019, 05:36:36 AM
You can show debug info in SMF and see which query is repeating itself by edit Settings.php and add to the end (before ?>)
Code: [Select]
$db_show_debug = true;
Title: Re: why my forum so many queries ?
Post by: billrune on September 07, 2019, 06:51:58 AM
thank you very much
Title: Re: why my forum so many queries ?
Post by: Biology Forums on September 08, 2019, 01:40:20 AM
If you need help cleaning up the forum, I can help you out. PM me for details!