Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
After upgrade dbqueries increased!
Avatar
WilRC
Member
sp_UserOfflineSmall Offline
Aug 31, 2015 - 5:09 am

Turned off again. Please feel free to acces the adminpanel. I have provided you the login details.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 31, 2015 - 5:19 am

OK - so are you Ok with me turning on/off components as long as I leave it as it should be?

And you didn't answer my other question regarding the WP theme. And a couple more:

Do you use Blog Linking on ALL posts? Do you use it on Comments?

Prior to recent updates - did your front page always show so many post exceprts?

andy-signature.png
YELLOW
SWORDFISH
Avatar
WilRC
Member
sp_UserOfflineSmall Offline
Aug 31, 2015 - 5:48 am

The WP theme is upgraded recently. 
We don't use Blog linking on all posts only if manual edit a blog link. Not on default.
On comments we don't use blog linking either.

Our frontpage always did have so many post exceprts. 
Headlines 2x
latest news 12x
T-news 2x
K-news 2x
A-news 2x

Avatar
WilRC
Member
sp_UserOfflineSmall Offline
Aug 31, 2015 - 5:52 am

It seems to be caused by the blog linking plugin. Deactivate this pluing will drop the queryload to 138!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 31, 2015 - 6:01 am

And the question about me changing component settings?

Oh yes - blog linking. That is why I have been asking about it above and why I wanted to know if the WordPress theme had been changed recently - especially the front page. It will probably come down to what filters and actions are being called by the WP theme to populate all of those excerpts. Some will trigger the query to determine if there is a blog link in place and some will not. Perhaps this has changed. Or perhaps at this moment you have a higher number of blog linked items on the front page. It would be useful and helpful to get to the bottom of it if we can.

The good news is that multiple calls to load the same data row will have a minuscule effect on overall performance as mySQL does a good job of caching data. But it is not ideal.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 31, 2015 - 9:49 am

Our 'News' page is similar in that it has small excerpts from various posts (ALL of which are linked to forum topics) but the link query is only actioned once and that is for the actual main post. So I think this comes down to the way the blog post excerpts are being called an compiled on your home page and that is what we need to try and pin down.

andy-signature.png
YELLOW
SWORDFISH
Avatar
WilRC
Member
sp_UserOfflineSmall Offline
Aug 31, 2015 - 3:43 pm

OK clear, how can help you with this?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 31, 2015 - 3:49 pm

Would you be willing to make small code edits on your staging server so we can try and isolate the WP hook(s) that is getting called by our home page?

andy-signature.png
YELLOW
SWORDFISH
Avatar
WilRC
Member
sp_UserOfflineSmall Offline
Sep 1, 2015 - 12:43 am

Sure no problem, staging is the best environment for testing!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Sep 1, 2015 - 5:32 am

Excellent. I went to your staging site and turned Blog Linking back on just so I could try a few settings. No help yet. And I am not really sure where to start as the obvious things didn't seem to help.

And before we go any further - if you haver any caching in place on the staging server could you turn t off while we run some tests?

The file you need to look at is-  by default - at /wp-content/sp-resources/forum-plugins/blog-linking/sp_linking_plugin.php

It starts with a whole swathe of 'add_action' and 'add_filter' directives. If possible, I would like you to comment some of these out, one at a time, to see if you can find the main culprit. I think for starters the ones we need to work with are:

'sph_setup_forum' (see note below)
'the_content'
'the excerpt'
'sph_blog_support_start'
'sph_aioseo_canonical_url'
'sph_canonical_url

Please note that 'spf_setup_forum' has 2 entries. Please test them 1 at a time.
'the_content' and 'the_excerpt' should be tested individually and then again together.

Is this all doable?

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625