How Many DB Queries Does Your Home Page Portal Run?

[rdn]

I like stuff really simple...

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

A lot faster

 

[Autonamus]

Timing: 0.1156 seconds
Memory: 16.009 MB
DB Queries: 21

 

[melbo]

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.

Did you find the cause?
My forum_list queries have recently risen

 

[rdn]

Did you find the cause?
My forum_list queries have recently risen

Do you have xentag?

 

[melbo]

I do have xentag. Does this run a query against every node?
I'm not really sure when this started since I don't check debug mode very often.

My addon list is here: https://xenforo.com/community/threads/high-queries-on-forum_list.93727/

 

[Moshe1010]

Did you find the cause?
My forum_list queries have recently risen

I don't remember what I ate this morning, so there is no way I can recall an issue I had a year ago. Just disable your add-ons my way! one by one and check you query count.

 

[rafass]

What's means then if some addon increase all this queries?
Addon disabled: Timing: 0,3811 seconds Memory: 13,577 MB BD Queries: 15
Addon enable: Timing: 0,6117 seconds Memory: 14,016 MB BD Queries: 55
There are some problem with that addon?

 

[Paul B]

A single add-on ideally shouldn't be adding that many queries.
However, if you have multiple add-ons then it's possible that each one will add one or two queries, which all add up.

 

[rafass]

In fact I'm talking about 1 single addon. only 1 who add all that queries.
with all my addons enable my queries are only 15*
but with that addon the queries increase to 55*
Should I contact the developer and don't use that addon for a while?
*(in home page)

 

[Paul B]

It may be worth contacting them to see if anything can be done.

Out of interest, which add-on is it?

 

[rafass]

I'll tell you via pm

 

[melbo]

I found that it was XenTag.
80+ queries enabled, normal disabled.

 

[Paul B]

Pleased to say mine runs at between 9 and 16, depending on how many threads and polls are featured.

It's more than I'd like but when the home page is replicating several different content types and features all on one page, including threads, polls, profile posts, pagination and respecting permissions, it's inevitable that the query count will increase slightly.

 

[rafass]

Hello @melbo have you fixed the issue with Xentag?
80+ queries are a lot!
What was the reply of the developer? it doesn't affect the performance?

 

[melbo]

not fixed. There were other reports of high queries in the xentag support thread too but not really much response.

 

[TickTackk]

Not really a portal but a news system, just 7 and memory usage is around 5.17MB

 

[rafass]

not fixed. There were other reports of high queries in the xentag support thread too but not really much response.

Hello Melbo, I've been testing with Xentag lately and there are not additional queries in forum_list unchecking the hashtag option
Anyway I'm not using the sidebar widget.

 

[melbo]

Not using hashtags but we are using sidebar widget to show trending tags.

 

[rafass]

Not using hashtags but we are using sidebar widget to show trending tags.

All these widgets in the sidebar increase so much the queries.
Here my numbers without widgets:

XF 1.4.6, PHP Version 5.5.24, Memcached + OPcache, 100+ addons, all running in VPS SSD https://foro.io

 

[rdn]

XF Forum with 1.1M post, 200K+ members, 60K Topics, 40+ addons, 100+ Forum nodes.
Index/Home on Debug Mode Page Load:

Timing: 0.0205 seconds Memory: 5.086 MB DB Queries: 7
Timing: 0.0266 seconds Memory: 4.873 MB DB Queries: 10
Timing: 0.0198 seconds Memory: 5.086 MB DB Queries: 7
Timing: 0.0198 seconds Memory: 5.086 MB DB Queries: 7
Timing: 0.0201 seconds Memory: 5.086 MB DB Queries: 7
Timing: 0.0210 seconds Memory: 5.086 MB DB Queries: 7
Timing: 0.0204 seconds Memory: 5.086 MB DB Queries: 7
Timing: 0.0226 seconds Memory: 5.086 MB DB Queries: 7