Robert

Exactly the same with W3 disabled. Query monitor only show “1 slow query” and it’s only .3s, it’s: “SELECT SQL_CALC_FOUND_ROWS wp_posts.ID…”

Also, when I reload that same page that I posted those actions for, that same section shows this:

<!-- [ACTION] it_get_template_part: 1.2804729938507-->

        <!-- [ACTION] it_get_template_part: 1.2859311103821-->

<!-- [ACTION] it_get_template_part: 1.2939331531525-->

<!-- [ACTION] it_before_content_page: 1.3134970664978-->

<div class="row solo single-page post-loop">

And optimization is still running on my other site – when that is done I will try disabling, and removing, all remants of W3, do this testing again, and then try Super Cache again.

Hello again – and thank you again – that code is very handy!

Going through the source I will paste below the section that shows the largest jump in time – it goes from 1.x seconds to over 9 seconds (if I’m reading this right). It seems to be related to my postmeta table – which is 510mb in size. My system, by the way, is running at 1% capacity, 24% hard drive space is used, 6% of memory, the swap file isn’t being touched, and my WP admin – I have Server IP & Memory Usage plugin installed – shows 2% out of 256mb being used.

<!-- [ACTION] it_get_template_part: 1.2125279903412-->

<!-- [ACTION] it_before_content_page: 1.2327218055725-->
<!-- [ACTION] update_post_meta: 1.234071969986-->
<!-- [ACTION] update_postmeta: 1.2340857982635-->
<!-- [ACTION] updated_post_meta: 5.5960309505463-->
<!-- [ACTION] updated_postmeta: 5.5961148738861-->
<!-- [ACTION] update_post_meta: 5.5985569953918-->
<!-- [ACTION] update_postmeta: 5.5985748767853-->
<!-- [ACTION] updated_post_meta: 9.4862499237061-->
<!-- [ACTION] updated_postmeta: 9.4862818717957-->

Is it just my db size? I have caching going on so when I reload the same post it, of course, loads much quicker – still slow I feel – at around 3-7 seconds.

Will do Acchia – I just created an image and loaded it onto a new server and going to run the optimization as well. brb.

Thanks! I installed Query Monitor – great tool! – and seeing some errors – this php error:

Trying to get property of non-object

And then two slow query notifications

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
WHERE 1=1
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private')
ORDER BY RAND()
LIMIT 0, 1

SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (248075)
ORDER BY meta_id ASC

but those .5 seconds and .06 seconds – doesn’t seem that would account for such a delay. I also get similar notification when loading the home page – which isn’t slow at all.

I posted the url but that post isn’t displaying.

https://healthitlink.com

no plugins added. And I don’t have other sites on the same server – but I do have this site on other server – and on those testing servers posts are just as slow.

The database is very clean – the size is unchanged from 2 months ago – give or take 2mb (and it’s 1gb db), the data is static, no changes/edits, etc…no orphans, and I’m running W3 for caching – Super Cache wasn’t quite as good on my site.

Sorry about that!

https://healthitlink.com

No new plugins – I’ve tried it with no plugins installed, using the default theme, and that didn’t change anything.

I don’t have other sites on this server but I do have this site on other servers – and they all do the same thing.

Hi!

Thanks for the replies!

I will check that debug information tomorrow.

Since I posted these questions I’ve noticed some very buggy things happening and I’m not certain it has to do with your plugin – but in testing your plugin it’s allowed me to notice this stuff. That said, when I deactive your plugin, I know longer have these problems:

1. Can’t click on anything on my site. The hover works, it changes to a clickable pointer but when I click, nothing happens – on anything! No search, no home page return, menus don’t work. I have to go in and “save permalinks” – and then it works until I try another search – then it breaks.

2. If I click on a category, I get a white screen. I disable the plugin, save the permalinks, and it all works again.

3. And the search is still slow. But, it does seem to be about 50% faster with a default theme running.

This all happens with only two plugins installed and activated – your plugin and WP-Types – and my site has 10,000 custom post types creates with WP-Types. I can’t test by disabling Types because then I have no posts ?? But it seems the two plugins don’t work well together.

And you’re right about the themes – I crreated a mirror site, with 2gb of memory and still had these same issues using the default themes.

All I want is to create a cool search feature that will search/filter custom posts and fields…and to win the lottery…I don’t think either are going to happen! lol

But I will post the debug info tomorrow…thanks again!
Rob

This was the problem and the fix:

755 for folders and 644 for files is the default permissions of files and is quite good for starters. I think you need to look not permissions but the ownership of the wordpress folder.

For example, webpages and folders should be owned by the www-data user. Try:
Code:
chown -R www-data:www-data /var/folder/of/wordpress

By the way – I changed the functions.php for my theme to 775 and I still don’t see an “update” button.

Hi Laliz, thanks again!

I found several ways to download….I appreciate your advice….:)
Rob

Hello Laliz,

Thanks for the info!

I knew that about the stats – but what I don’t know is why does my site need that information if I have no fb/twitter/pinterest sharing or liking abilities? There’s nothing on my site that has any association to any of these other sites.

The default WP themes require Google fonts?

There must be a way to not use Google fonts – not everybody that uses WordPress has access to Google ??

Hi Jack,

Thanks for the info – doesn’t look too hard ??

I appreciate the time!
Rob

Hey Jack – thanks for the response! And it’s all a mountain ??

I get most of it…but it’s not just the front page…I have themes I use that display “the top 10…the most viewed…the highest rated…” etc…and it seems those are not getting recognized by WP because they’re custom post types.

By the way – if anybody knows how to completely block these referrer’s from this plugin how to remove my url from their database..PLEASE let me know because this is a nightmare!

Thanks!