Question: recommended cached data size

Please see the plugin’s FAQ on this point.

A cache size of 64MiB – 128MiB should not, on a modern 64-bit server with at least a couple of GiB of RAM and stored on an SSD, cause operational problems. The plugin is careful to use indexed access O(log(n)) throughout, so performance should degrade slowly as the cache gets bigger. And SQLite3 is lightweight and efficient.

But I hesitate to make promises here, because there is so much variability between installations. It would be helpful if you could follow up here with your experience,

Thanks for your answer. I appreciate it!

Unfortunately, I won’t be able to provide any feedback since I had to install your plugin. I was experiencing critical interruptions, very similar and worse than the one mentioned in this request, despite not receiving any significant logs in my server. For many days, my website was inaccessible at certain times of the day (usually mostly in the morning), causing continuous timeout errors for several hours. After finding that discussion and reading that someone was facing the same timeout issue, I decided to permanently remove the plugin, and the issue has finally disappeared. In fact, prior to uninstalling the plugin, my website was consistently inaccessible for several hours each day. After removing the plugin, I no longer experience the issue (for 4 days now).

I really don’t know what the cause could be, but I think the site becomes unreachable when an operation to clean up old data within the database created by the plugin is supposed to occur. I can’t be certain of it, but I haven’t found another explanation that makes sense. I am very sorry because I loved this plugin, and the benefits it provided were very significant for me. However, I cannot allow my website to be unreachable for over 3 hours every day

Thanks for reporting this serious defect. I will attempt to isolate and fix it.

@olliejones thank you for your interest in fixing this issue. I will be happy to reinstall the plugin in case you are able to isolate the issue and push a fix in a new release. I think it’s the best plugin that helps improve performance while preserving CPU resources. It was truly unfortunate to have to uninstall it. If you’re interested in some data on how I used the plugin, I had chosen a 40MB cached data size. However, I frequently noticed the cached database size reaching up to 60-62MB.

Version 1.3.6, just released, should help with the timeout issue.

Thanks for your message, @olliejones.
I will install the plugin in the next few days to test the new version. I will share feedback with you.
I will also make sure to add these lines to my wp-config.php file:

define('WP_SQLITE_OBJECT_CACHE_DB_FILE', '/var/tmp/.object-cache.sqlite');
define('WP_SQLITE_OBJECT_CACHE_TIMEOUT', 15000);

Since I will add the cache database to the tmp folder, and it seems this folder is not accessible, I believe it would be useful to add the size of the cache database to the plugin settings page.

Hi @olliejones,

I’ve been using the plugin for a week, and I haven’t experienced any timeout issues. The new update was really effective. Thank you. In case I experience similar problems in the future, I will open a new discussion here. Thanks again!