Solved: 1 Year, 6 Months, 2 Weeks ago What can I disable to reduce number of queries?
#1
Solved: 1 Year, 6 Months, 2 Weeks ago
So, on my index page there is always 12 queries called, and I am okay with that. 
But on showthread.php and forumdisplay.php there is around 25 queries called. 
Any advice how can I reduce that number as much as it's possible?
iAndrew & NickGHQ - Respect!!
Reply
#2
Solved: 1 Year, 6 Months, 2 Weeks ago
perhaps you can remove forum jump menu for all forums.
may not be more than that (IIRC, you are using few plugins only)

actually there should be no need to reduce the queries !
Reply
#3
Solved: 1 Year, 6 Months, 2 Weeks ago
Reduced 1 Query  Toungue
Yes, I am using only "View Groups" and "Styled Usernames" plugins. Nothing else.
iAndrew & NickGHQ - Respect!!
Reply
#4
Solved: 1 Year, 6 Months, 2 Weeks ago
What is the performance of the pages being loaded? You can see by going into debug mode from the link in the footer. Are some pages taking a fairly long time to load?

I ask because it's fairly normal for some MyBB pages to have a large number of queries, but the queries are usually very fast. I have a very old VPS with limited hardware and they run in an average of about ~1/1000 second each.

Most likely, either one particular query is being very slow (which happens more often than would be expected), or they are all unusually slow. If every query is slow, it might be a hosting/server issue. If it's just one query, it's easier to address and to fix that one query.

25 queries itself isn't a huge number of queries necessarily, so perhaps looking a little deeper into them might be the answer performance-wise. What does the debug page look like on various pages for you?
Reply
#5
Solved: 1 Year, 6 Months, 2 Weeks ago
You mean this? https://prnt.sc/s3i1ut
iAndrew & NickGHQ - Respect!!
Reply
#6
Solved: 1 Year, 6 Months, 2 Weeks ago
Hmm,

Your database queries are running extremely quickly based on the debug info. Even though there are more queries than on the index, the total DB processing time is still about 7ms (which is very good).

I wouldn't worry too much about them.If it was more than 50, it might be a cause for concern, but 25 is still a relatively low number for MyBB. Smile
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)