MyBB Community Forums

Full Version: Healthy Ammount of SQL Queries?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
I was just wondering what a healthy ammount of SQL queries would be.

Here are some of my stats;
Index: 15
Forum: 30
Thread: 45

I thought that 45 is a bit much and came here to ask for your thoughts?

Thanks
May be you're running any plugin that show something on postbit ?
I am doing, I have a few.
Do you think 45 is too much?

I dont have anything to reference it against.
That's they are running on each post making it a lot of queries. And yes 45 is slightly high as compared to the average.
What's the average?
45 is slightly high but not outrageous for showthread. The rest are good.

My HF queries:

10 index
17 forumdisplay
29 showthread

I do everything I can to minimize queries.
With a forum of your significance Labrocca, id be the same.
Thanks for your replies guys, ill get onto prioritizing my plugins.
With a fresh installation without any plugins I get those queries:

Index: 11
forumdisplay: 18
showthread: 21
newreply: 17
memberlist: 12
userprofile: 13
We're currently trying to lessen the query count. It seems to us that a couple of mybb queries could be combined, I'm not even talking plugins here. We're getting 60 on showthread.

The reputation system adds a lot. Google SEO adds two. Thanks adds a few.

We've tried to experimentally disable rep, but are not getting a decrease in reputation queries.

index 15
forum 28
thread 40
profile 23
Pages: 1 2