1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

What is a good amount of Queries you Should have?

Discussion in 'XenForo Questions and Support' started by faeronsayn, Nov 22, 2012.

  1. faeronsayn

    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?
     
  2. Arty

    Arty Well-Known Member

    No
    Get rid of add-ons that you don't need.
     
    faeronsayn likes this.
  3. faeronsayn

    faeronsayn Well-Known Member

    Do the number of nodes / usergroups affect the speed of the site?
     
  4. Digital Doctor

    Digital Doctor Well-Known Member

    Post some data about how slow your site is.
     
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    No. But excessive numbers of nodes and groups can cause slowness when editing your nodes. This is only a possible issue at save time. There is no problem at run time.
     
    faeronsayn likes this.
  6. Digital Doctor

    Digital Doctor Well-Known Member

    Jake Bunce and faeronsayn like this.
  7. faeronsayn

    faeronsayn Well-Known Member

  8. Digital Doctor

    Digital Doctor Well-Known Member

    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.
     
    Jake Bunce and faeronsayn like this.
  9. faeronsayn

    faeronsayn Well-Known Member

    These requests are usually caused by addons right? Would running Tapatalk and Forumrunner at the same time be the cause of larger requests?
     
  10. faeronsayn

    faeronsayn Well-Known Member

    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?
     
  11. melbo

    melbo Well-Known Member

    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
     
    Jake Bunce and faeronsayn like this.
  12. melbo

    melbo Well-Known Member

    Turn on debug mode and then turn off one addon at a time and refresh your home page might give you a clue.
     
  13. Digital Doctor

    Digital Doctor Well-Known Member

    How about showing us a list of all your addons.
     
    Jake Bunce likes this.
  14. faeronsayn

    faeronsayn Well-Known Member

    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?
     
  15. Digital Doctor

    Digital Doctor Well-Known Member

Share This Page