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 26, 2015 - 10:50 am

Hi, I've updated SP yesterday and I saw with Q-Monitor that total db-queries loaded on my frontpage has increased to 90 queries total. I have only loaded the the Sp recent post widget active op the frontpage. Simplepress pages is loading 66 queries, that's great. What is going wrong?

I think an update of our theme has caused this problem! So it is not related to SP.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 26, 2015 - 12:04 pm

Before talking about the number of queries what version were you updating from?

andy-signature.png
YELLOW
SWORDFISH
Avatar
WilRC
Member
sp_UserOfflineSmall Offline
Aug 30, 2015 - 12:05 pm

I just turned off all plugins and make them active one by one again.

By activate SP my dbqueries increased from 134 -> 241 on my frontpage!

I updated SP from 5.5.09 to 5.5.10! Before the update SP was only loading 5 queries on my frontpage. Where does this goes wrong? I can give you access to our devellopment area?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 30, 2015 - 1:06 pm

if you look at the change log between 5.5.9 and 5.5.10 you will find that the only two significant changes were to the password form on users profiles and the construction of the option new registration email. These were because of poorly documented changes in WP that we missed and felt were important enough to warrant a speedy update. Nothing to do with database activity or queries. No changes that would make any difference whatsoever to home page loading.

if you want to dump the SP queries on your home page to a text file of some sort and PM them to me then I would be happy to take a quick look.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Aug 30, 2015 - 3:50 pm

If you concentrate on a single WP Post ID and look at the source being generated you will see that the Post ID appears in 15 separate queries - although mostly they are duplicates repeated over and over.

The curious thing is that if you do not run the page with the query monitor then you still get 15 and the query monitor display is still being generated even though not shown.

So are you sure this is a not a problem with the query monitor plugin?

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

I don't think that Query Monitor is duplicating queries. I did disabled all plugins and turned them on one by one. By turning on SP the frontpage increased with 95 queries. Very strange, maybe something went wrong during the upgrade proces?  

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

I will take another look this morning. But...

Did you actually turn off the query monitor when you were testing this?

And has anything else been updated? In particular - any changes to the WP theme?

And no - I don't see any way an update can change anything it wasn't specifically created to change. There were no changes to the blog linking plugin in the last few updates which is why I am slightly suspicious.

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

And.... can you try an experiment? Can you turn off the short forum topic listing in the sidebar widget and see if that is responsible?

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

I have turned off the plugin template and tags. Queryload went down from 245 to 231

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

They appear to still be on and showing up. So can't look at the difference

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
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: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626