The Old Man

Many thanks!

Thank you, that fixed jt. Also installed Optimole, will clearing the cache affect Optimole? Thank you!

Hi,

Sorry, which option do you mean, Browser caching?

Or is it “Overwrite the cache-control header for WordPress’s pages using web server rules”? I do have that enabled already and I’m using Apache not Nginx, but the link to the rules is missing where it says:

”Read here if you use Apache (htaccess): for overwriting to work, make sure that the rules added by Super Page Cache for Cloudflare are placed at the bottom of the htaccess file. If they are present BEFORE other caching rules of other plugins, move them to the bottom manually.”

Thank you. I was reading through the FAQ again and I was thinking for pages that CF haven’t yet cached that I might benefit from the Fallback Cache to avoid that long pause of up to 30 seconds on uncached pages.

I did a quick check and the Smartcrawl sitemaps list:

Site A: 144 pages and posts
Site B: 132 posts and pages

Do you think it would be worthwhile?

Another question if I may? I noticed in GTMetrix that whilst the page shows as cached, every CSS, JS and image asset except the actual HTML always shows “cf-cache-status REVALIDATED” which I’ve never noticed before. I know it means that has still been served by the CF cache, but is that normal?

Last question! Is there a way to exclude a path from the preloader or could you add a field in the settings to do it? I have an external third party gallery that isn’t powered by WordPress in a subfolder that has its own sitemaps and wanted to make sure that the crawler wasn’t wasting time/resources crawling that section of the site?

Many thanks!

• This reply was modified 1 year ago by The Old Man.
• This reply was modified 1 year ago by The Old Man.

Thanks for the link, that was a really interesting read! I honestly never realised those aspects. I think everyone just assumes that they will cache your pages as you would expect so yes, it is a little unsettling that they may not on quieter sites. I’m happy with the caching. It’s just good to know roughly how many pages are cached. I now use the option to Cron the preloader twice a day to be on the safe side, I’ll explain below

I use your plugin with Divi Theme and without it, the loading times are just terrible. One of my 2 sites let’s call it site A uses more CPU than the other Site B with uncached pages taking up to 28 seconds to load despite the server doing nothing, both don’t allow members or comments (8 core NVME VPS, 8GB RAM, Redis, MariaDB, PHP-FPM) but I’ve yet to track down the actual root cause even using all the usual methodology. I found the preloader useful as the cached pages load very fast. So as long as they are cached, that’s fine.

Site A: https://gtmetrix.com/reports/sarahjaneredmond.com/jDNATMFA/

https://gtmetrix.com/reports/prestatyn-scala.info/ogt4UzoM/

Hi again,
Thanks I understand. When you open that link though and it shows you a list of all pages that have been cached, there is a count at the top. Is it possible to make use of that count? Where does the data come from?

??

Screenshots of the issue:

https://www.dropbox.com/scl/fi/cqyed6f9u90pq41cqt5yn/IMG_2227.jpg?rlkey=zzrrxtqns63r8xr0u9zbqwwzt&dl=0

https://www.dropbox.com/scl/fi/o6nvj731y857wbqn8crvn/IMG_2228.jpg?rlkey=1hdxlovziqvlqats0jem1uodk&dl=0

My current index structure for the wp_options table, which seems to be working okay:

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment

PRIMARY	BTREE	Yes	No	option_name	741	A	No
option_id	BTREE	Yes	No	option_id	741	A	No
autoload	BTREE	No	No	autoload	4

FYI: related discussion:

https://www.ads-software.com/support/topic/bug-3-2-4-bloating-wp-options-table-with-duplicate-rows/

• This reply was modified 1 year, 4 months ago by The Old Man.

Hello! Thanks for the reply.

Can you kindly let us know what plugin version was used before upgrading to the latest version?

I’ve ran the plugin for a long while so I’m assuming it would have been v3.2.3.

Screenshots of the issue:

https://www.dropbox.com/scl/fi/o6nvj731y857wbqn8crvn/IMG_2228.jpg?rlkey=1hdxlovziqvlqats0jem1uodk&dl=0

https://www.dropbox.com/scl/fi/cqyed6f9u90pq41cqt5yn/IMG_2227.jpg?rlkey=zzrrxtqns63r8xr0u9zbqwwzt&dl=0

However, it may not be down to the actual plugin. I’ve come to the realisation it may not be representative of your plugin but more a symptom of the index configuration was probably not preventing duplicate rows by using a unique index. I don’t know what the actual existing index configuration was before without looking at my backups, but removing all the duplicates bar one then applying a unique index to the table has stopped it reoccurring. I assumed previously that the plugin was inserting new rows instead of updating an existing row if it already exists.

The current index configuration:

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment

PRIMARY	BTREE	Yes	No	option_name	741	A	No
option_id	BTREE	Yes	No	option_id	741	A	No
autoload	BTREE	No	No	autoload	4	A	No

I found the same issue and similar number of duplicate rows with the Smart Crawl plugin, and you can see discussion here:

https://www.ads-software.com/support/topic/repeating-wds_blog_tabs-rows-bloating-wp_options-table/

Thank you.

• This reply was modified 1 year, 4 months ago by The Old Man.
• This reply was modified 1 year, 4 months ago by The Old Man.

Hello Kris,

Sorry for the delay in responding, do you still need me to email support?

Is this a multisite installation?

No, definitely a single, small site, hosted on a VPS.

Without that index, a duplicated wds_blog_tabs record will be created on each request (regardless the WordPress installation is single or multisite). If your site receives a lot of traffic, that could explain the situation.

I think this is Index-related and is the cause of the issue, as I now have found more examples with option names and values from other plugins, but only 2 with 1000’s of entries, the majority had just 2, the ‘WP Offload Media Lite for Amazon S3, DigitalOcean Spaces, and Google Cloud Storage’ plugin had a similar amount to yours, but otherwise the highest was about 70 duplicate rows as much as I can recall.

I took some screenshot examples at the time to upload here but there seems to be no facility to add them to my posts, but to see exactly what the Indexes previously were, I’ll have to check my backups made before.

Since I removed all of the duplicate rows bar 1 unique row of each, and added the correct unique indexes, the table has stopped growing. I also tried manually adding a duplicate row and of course Mysql complained it wasn’t unique so refused it.

Further, it looks like all 68k rows are identical.

Well that’s great news, thank you! ????

Hi David,

I have changed my review from 3 to 5 stars. On my Windows 11 PC I now only see 1 banner which is on the WordPress Updates page. Originally on my iPad with Safari browser, I was seeing several of them on various pages including the homepage and media library but I have no idea why. Perhaps it was some kind of caching issue.

Many thanks.

Hi @graham-smith ,
The toggle should now be added in the admin bar! To help the plugin, feel free to leave a review ??

Huge thanks for this, wonderful stuff. Will do!

So sorry to hear of your accident, best wishes to you for a full and speedy recovery. Thank you for everything you do and your kindness and generosity.

Confirmed, working great now.

BTW, there is a duplicate label when choosing a separator icon, it appears twice. Works, just a bit confusing!