Advertisement:

Author Topic: why my forum so many queries ?  (Read 528 times)

Offline billrune

  • Semi-Newbie
  • *
  • Posts: 32
why my forum so many queries ?
« 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.

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,570
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: why my forum so many queries ?
« Reply #1 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.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline billrune

  • Semi-Newbie
  • *
  • Posts: 32
Re: why my forum so many queries ?
« Reply #2 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

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,570
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: why my forum so many queries ?
« Reply #3 on: September 06, 2019, 11:34:37 PM »
Yes under
 Administration Centerâ–º Server Settingsâ–º Caching
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline billrune

  • Semi-Newbie
  • *
  • Posts: 32
Re: why my forum so many queries ?
« Reply #4 on: September 06, 2019, 11:35:05 PM »
my cache set is level 1 cache

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,570
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: why my forum so many queries ?
« Reply #5 on: September 07, 2019, 01:03:26 AM »
You can raise it as well.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline SpacePhoenix

  • Semi-Newbie
  • *
  • Posts: 95
Re: why my forum so many queries ?
« Reply #6 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

Offline Pipke

  • Full Member
  • ***
  • Posts: 478
    • [NRNS]
Re: why my forum so many queries ?
« Reply #7 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;

Offline billrune

  • Semi-Newbie
  • *
  • Posts: 32
Re: why my forum so many queries ?
« Reply #8 on: September 07, 2019, 06:51:58 AM »
thank you very much

Offline Biology Forums

  • SMF Hero
  • ******
  • Posts: 3,747
    • StudyForcePS on Facebook
    • @studyforceps on Twitter
Re: why my forum so many queries ?
« Reply #9 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!