What is a good amount of Queries you Should have?

faeronsayn

Well-known member
I've been trying to speed my site up, and have been looking into anything that can be done for it to become faster. I've already installed popular caching methods like APC and memcached, I've also got most of the performance settings enabled.

I've turned on debugging mode to realize that approximately 25 - 30 queries are executed in one page load. Which I find a little too high.

I'm simply wondering what a good number of queries executed should be to speed the forum up. What addon's usually cause the increase in queries? Do template edits / more themes cause the site to slow down or increase queries? What can I do to reduce the amount of queries executed?
 
www.shadygamer.com/forum/ (Make sure you test the forums, not shadygamer.com)

http://www.webpagetest.org/result/121126_86_D7X/
- I used: Chrome and Dulles.

First View (10.355s)
Repeat View (4.539s)

Slow spots
Tapatalkdetect.js (404)
impr.superpages.com - clickThrough
doubleclick.net - ads(403)

Requests 141.
That's alot of requests - 141.
Not sure how you can fix the tapatalkdetect.js 404.
You've got lots of great addons / tweaks on your site ... but they are performing alot of queries.
Overall, despite the poor stats ... your site doesn't feel that slow to me.
Xenforo.com/community
http://www.webpagetest.org/result/121126_QY_DKA/
xenforo.com/community/
First View (3.488s) - 29 requests
Repeat View (1.901s) - 6 requests
Obviously 6 requests is faster to do than 141.
 
www.shadygamer.com/forum/ (Make sure you test the forums, not shadygamer.com)

http://www.webpagetest.org/result/121126_86_D7X/
- I used: Chrome and Dulles.

First View (10.355s)
Repeat View (4.539s)

Slow spots
Tapatalkdetect.js (404)
impr.superpages.com - clickThrough
doubleclick.net - ads(403)

Requests 141.
That's alot of requests - 141.
Not sure how you can fix the tapatalkdetect.js 404.
You've got lots of great addons / tweaks on your site ... but they are performing alot of queries.
Overall, despite the poor stats ... your site doesn't feel that slow to me.
Xenforo.com/community
http://www.webpagetest.org/result/121126_QY_DKA/
xenforo.com/community/
First View (3.488s) - 29 requests
Repeat View (1.901s) - 6 requests
Obviously 6 requests is faster to do than 141.

These requests are usually caused by addons right? Would running Tapatalk and Forumrunner at the same time be the cause of larger requests?
 
How can one figure out which addons make most of the requests / queries? I might have some of those add-ons, and they might have better alternatives..

Any ideas?
 
You can run Tapatalk and disable tapatalkdetect which is only to inform those who land on your page via a phone that you have TT installed. I disabled it for other reasons. Namely, Pagespeed complained that I was running external js in the middle of a page load.

If you are 404ing the js, make sure to disable the listener as shown below:
http://xenforo.com/community/thread...e-7-webos-nokia-app.14335/page-10#post-239121
 
Code:
CCPLZ Hide Links From Guests 1.0.0

Create Post on Report 1.0.0

Custom BBCode Manager v1.3.2


DaTheme Advanced Styling Rules 1.0.2


Display Staff Members 1.1.2


Hide Ip of Super Admin 1.0

Online Status 1.1


Prefix Forum Listing 1.1.0

ragtek First Post Moderated 1.0.0


ragtek [Planet Liebe] Automatic URL Aliases - Automatic URL conversion 1.2.3


Require Thread Prefixes 1.0


Social Beta 2

sonnb - Prevent double post 1.0.1


sonnb - Profanity Filter 1.0.4

ControlsTemplate Modification System 1.2


Top Users 1.1.2


User Essentials 1.0.9


****** - Advanced Forum Statistics 1.2.0


XFA - Previous and Next thread link 1.0.0


[8wayRun.Com] XenUtiles (Tools) 1.1.5


[Ice] LiveStream 1.3

[Ice] Shop 1.0.1


[RT] Spoiler 1.0.1


[ValveTime.net] QuoteCollapse 1.2

I was wondering, disabling addons will be just as good as uninstalling them right? Performance wise?
 
Top Bottom