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

How Many DB Queries Does Your Home Page Portal Run?

Discussion in 'Forum Management' started by DRE, Mar 8, 2014.

  1. DRE

    DRE Well-Known Member

    The more stuff I put on there, the higher it goes. I'm trying to put as much as I can put on my home page while remaining under 30 database queries. So far I'm at 23.
     
    Sheldon likes this.
  2. oman

    oman Well-Known Member

    Timing:
    0.1874 seconds
    Memory:
    16.711 MB
    DB Queries:
    16
     
  3. Sheldon

    Sheldon Well-Known Member

    Isn't that logical DRE? Hahaha. The more you put, the more it goes up?
     
    DRE likes this.
  4. Jaxel

    Jaxel Well-Known Member

    The # of queries is kind of irrelevant. Its mostly about the efficiency of queries.

    I can make a 3 query process into 1 single query using nested selects, but it will run 200x slower.
    Example: http://xenforo.com/community/threads/need-help-optimizing-a-query.64884/
     
    eberkund and Luke F like this.
  5. DRE

    DRE Well-Known Member

    You mean obvious, yeah definitely lol.
     
  6. DRE

    DRE Well-Known Member

  7. Jaxel

    Jaxel Well-Known Member

    http://8wayrun.com has 21 at minimum (there is a lot of caching going on that reduces queries in XenPorta; so it can vary depending on whether or not a cache needs to be refreshed).

    http://yokappa.tv has 4

    No matter what, you will have at least 3 queries, they are necessary for sessioning in XenForo.
     
    DRE likes this.
  8. MattW

    MattW Well-Known Member

    upload_2014-3-8_7-14-32.png

    &

    upload_2014-3-8_7-15-2.png
     
    DRE likes this.
  9. Mouth

    Mouth Well-Known Member

    Timing:0.4379 seconds
    Memory: 9.102 MB
    DB Queries: 14

    Clearly I have something to review, 0.4 seems quite high.
    I'm using Widget Portal Home Page
     
  10. digitalpoint

    digitalpoint Well-Known Member

    I like stuff really simple...

    Timing: 0.0164 seconds
    Memory: 4.103 MB
    DB Queries: 3
     
    maszd, rafass and Steve F like this.
  11. Sheldon

    Sheldon Well-Known Member

    No, I meant logical, that was why I typed it out.
     
    The Forum Heroes likes this.
  12. Kerby

    Kerby Active Member

    13 /forums
    21 /portal
     
  13. Tracy Perry

    Tracy Perry Well-Known Member

    On one

    Timing: 0.3163 seconds
    Memory: 19.505 MB
    DB Queries: 10

    On another

    Timing: 0.1408 seconds
    Memory: 12.981 MB
    DB Queries: 9
     
  14. Moshe1010

    Moshe1010 Well-Known Member

    Timing: 0.0644 seconds
    Memory: 12.309 MB
    DB Queries: 11
     
  15. DRE

    DRE Well-Known Member

    Looks like I have the most out of all y'all so far. Dang. I wonder what vB5 home page queries are looking like?
     
  16. Moshe1010

    Moshe1010 Well-Known Member

    I have 50 before cache kicks in. I'm trying to find what add-on is causing it since it duplicated a permission check for each node I have, which is very weird.
     
  17. woei

    woei Well-Known Member

    I have enabled debug mode, but how can you display the query information?
     
  18. Brogan

    Brogan XenForo Moderator Staff Member

    Click on the timing link.

    upload_2014-3-9_12-11-18.png
     
  19. woei

    woei Well-Known Member

    Timing: 0.1488 seconds
    Memory: 8.410 MB
    DB Queries: 25

    This is the homepage, showcase enabled. Is there an option to see this information as admin only without enabling debug mode?
     
  20. Brogan

    Brogan XenForo Moderator Staff Member

    Enable it for your IP address only.
    Code:
    if($_SERVER['REMOTE_ADDR'] == '0.0.0.0'){$config['debug'] = true;}
     
    Adzkii and woei like this.

Share This Page