How Many DB Queries Does Your Home Page Portal Run?

[DRE]

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.

 

[oman]

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.

Timing:
0.1874 seconds
Memory:
16.711 MB
DB Queries:
16

 

[Sheldon]

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.

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

 

[Jaxel]

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.

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/

 

[DRE]

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

You mean obvious, yeah definitely lol.

 

[DRE]

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/

Oh really? Hmm. K so how many queries do you have total though?

 

[Jaxel]

Oh really? Hmm. K so how many queries do you have total though?

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.

 

[MattW]

&

 

[Mouth]

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

 

[digitalpoint]

I like stuff really simple...

Timing: 0.0164 seconds
Memory: 4.103 MB
DB Queries: 3

 

[Sheldon]

You mean obvious, yeah definitely lol.

No, I meant logical, that was why I typed it out.

 

[Kerby]

13 /forums
21 /portal

 

[TPerry]

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

 

[Moshe1010]

Timing: 0.0644 seconds
Memory: 12.309 MB
DB Queries: 11

 

[DRE]

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

 

[Moshe1010]

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

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.

 

[woei]

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

 

[Paul B]

Click on the timing link.

 

[woei]

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?

 

[Paul B]

Enable it for your IP address only.

if($_SERVER['REMOTE_ADDR'] == '0.0.0.0'){$config['debug'] = true;}