Notifications
Clear all

wpForo 1.x.x [Closed] 17 database queries on non-wpforo pages

21 Posts
6 Users
2 Reactions
1,714 Views
Posts: 37
Topic starter
(@philraymond)
Trusted Member
Joined: 5 years ago
Posts: 37
Topic starter
(@philraymond)
Trusted Member
Joined: 5 years ago

Still wondering about this, thanks.

9 Replies
Robert
Admin
(@robert)
Joined: 9 years ago

Support Team
Posts: 10591

@philraymond,

These SQLs may come from widgets. Do you have wpForo widgets in non-forum pages?

Are these the only SQL you see on non-forum pages?

dimalifragis
(@dimalifragis)
Joined: 5 years ago

Famed Member
Posts: 2611

@robert I just checked my site and it is true (what the OP wrote).

I use no widgets of wpforo in home page and i see several queries from wpForo. Other pages also (blog posts for example).

Can you clarify this for me also?

Thanks

Robert
Admin
(@robert)
Joined: 9 years ago

Support Team
Posts: 10591

@dimalifragis,

The seven is good. wpForo is a WordPress plugin and some SQL should run on each WordPress page loading. Such as:

  • User online checker,
  • Current page is a wpForo page checker,
  • And many general processes are going to check if wpForo should do something or not...

This is correct. There is not any issue here.

dimalifragis
(@dimalifragis)
Joined: 5 years ago

Famed Member
Posts: 2611

@robert 25 wpForo queries in my home page, i would not call it normal.

Anyways, apparently this is the way it is.

Robert
Admin
(@robert)
Joined: 9 years ago

Support Team
Posts: 10591

@dimalifragis,

I meant seven not 25. Please read my post again. And for 25 I asked to leave a list of all queries. In all our test website there is no 25 queries. This is a site specific issue and some plugins are hooked in wpForo actions, so they add more queries on your website. The native wpForo doesn't have 25 queries on non-wpForo page.

dimalifragis
(@dimalifragis)
Joined: 5 years ago

Famed Member
Posts: 2611

@robert

This is from a newly installed staging WP 5.3 site, with 4 plugins and wpForo installed.  No mods, nothing changed or whatever. A stock WP installation. Stock theme.

I have disabled also those 4 plugins, and nothing changed.

Robert
Admin
(@robert)
Joined: 9 years ago

Support Team
Posts: 10591

@dimalifragis,

Ok thank you for the list. I only see SQLs, which gets option values from wp_options table. These are very small queries with 0.0003 sec execution time. All together is 0.0075 sec. This is something you can ignore without any worry. The real and serious SQLs like posts, topics, users getting SQLs don't exist. A one of such SQL may take ten times more seconds than the 25 options getting SQLs.

Moreover, all these 25 SQLs should be cached, and they are cached in our test websites. The SQLs should work once, not on each page loading. For some reason they are not cached on your forum. We'll take a deep look in the core for the next update. As additional information that could help us, please attach a list of all plugins you use (in a txt file).

dimalifragis
(@dimalifragis)
Joined: 5 years ago

Famed Member
Posts: 2611

@robert It is not only me, @philraymond started this topic. I just verified his findings.

I understand what you say and yes they are small and fast queries. But they are queries.

As i posted above i have NO PLUGINS active and the default WP theme is active. So whatever happens (caching or not) is from wpForo and not from anything else.

Still i find kinda strange for a plugin to execute so many queries in all pages.

Apparently this is the way it is.

 

Robert
Admin
(@robert)
Joined: 9 years ago

Support Team
Posts: 10591

@dimalifragis,

Ok, thank you. We'll check it deeper and make sure the SQLs for getting options are well cached for the next update.

Posts: 37
Topic starter
(@philraymond)
Trusted Member
Joined: 5 years ago

I don't use any wpForo widget anywhere, and yes, that was all of the wpForo SQL queries on non-forum pages.

2 Replies
dimalifragis
(@dimalifragis)
Joined: 5 years ago

Famed Member
Posts: 2611
Posted by: @philraymond

I don't use any wpForo widget anywhere, and yes, that was all of the wpForo SQL queries on non-forum pages.

Read carefully what Robert asked:

Are these the only SQL you see on non-forum pages?

I think your answer (yes) is not correct, not possible to see only wpForo queries in any page.

(@philraymond)
Joined: 5 years ago

Trusted Member
Posts: 37

@dimalifragis Thanks, but I didn't think he would be asking about other queries because obviously there are many other queries from the core, theme, and plugins.

Page 2 / 2