OllieJones

<p>A <a href="https://developer.wordpress.org/reference/classes/wp_object_cache/#persistent-cache-plugins" rel="nofollow ugc">persistent object cache</a> helps your site perform well. This one uses the widely available <a href="https://www.php.net/manual/en/book.sqlite3.php" rel="nofollow ugc">SQLite3</a> extension, and optionally the <a href="https://www.php.net/manual/en/intro.igbinary.php" rel="nofollow ugc">igbinary</a> and <a href="https://www.php.net/manual/en/book.apcu.php" rel="nofollow ugc">APCu</a> extensions to php. Many hosting services offer those extensions, and they are easy to install on a server you control.</p>
<h4>What is this about?</h4>
<p>It’s about making your site’s web server perform better. An object cache does that by reducing the workload on your MariaDB or MySQL database. This is not a <a href="https://developer.wordpress.org/advanced-administration/performance/cache/" rel="nofollow ugc">page cache</a>; these persistent objects go into a different kind of cache. These objects aren’t chunks of web pages ready for people to view in their browsers, they are data objects for use by the WordPress software.</p>
<p><a href="https://en.wikipedia.org/wiki/Cache_(computing)" rel="nofollow ugc">Caches</a> are ubiquitous in computing, and WordPress has its own caching subsystem. Caches contain short-term copies of the results of expensive database lookups or computations, and allow software to use the copy rather than repeating the expensive operation. This plugin (like other object-caching plugins) extends WordPress’s caching subsystem to save those short-term copies from page view to page view. WordPress’s cache happens to be a <a href="https://en.wikipedia.org/wiki/Cache_(computing)#Memoization" rel="nofollow ugc">memoization</a> cache.</p>
<p>Without a persistent object cache, every WordPress page view must use your MariaDB or MySQL database server to retrieve everything about your site. When a user requests a page, WordPress starts from scratch and loads everything it needs from your database server. Only then can it deliver content to your user. With a persistent object cache, WordPress immediately loads much of the information it needs. This lightens the load on your  database server and delivers content to your users faster.</p>
<h4>Who should use this?</h4>
<p>If your site runs on a single web server machine, and that server provides the <a href="https://www.php.net/manual/en/book.sqlite3.php" rel="nofollow ugc">SQLite3</a> and <a href="https://www.php.net/manual/en/intro.igbinary.php" rel="nofollow ugc">igbinary</a> extensions to php, this plugin will almost certainly make your site work faster. And if that server provides the <a href="https://www.php.net/manual/en/book.apcu.php" rel="nofollow ugc">APCu</a> extension, this plugin uses it too.</p>
<p>Some hosting providers offer <a href="https://redis.io/" rel="nofollow ugc">redis</a> cache servers. If your provider offers redis, it may be a good choice. You can use it via the <a href="https://wordpress.org/plugins/redis-cache/" rel="ugc">Redis Object Cache</a> plugin. Sites using redis have one SQL database and another non-SQL storage server: redis. Other hosting providers offer <a href="https://memcached.org/" rel="nofollow ugc">memcached</a>, which has the <a href="https://wordpress.org/plugins/memcached/" rel="ugc">Memcached Object Cache</a> plugin. And some large multipurpose cache plugins, such as the <a href="https://wordpress.org/plugins/litespeed-cache/" rel="ugc">LiteSpeed Cache</a>, also offer object caching based on one of those cache server software packages.</p>
<p>The cache-server approach to object caching comes into its own when you have multiple load-balanced web server machines handling your site. SQLite doesn’t work correctly in a multiple-web-server environment.</p>
<p>But, for single-server site configurations, SQLite, possibly assisted by APCu, performs well. And the vast majority of sites are single-server.</p>
<h4>APCu</h4>
<p><a href="https://www.php.net/manual/en/book.apcu.php" rel="nofollow ugc">APCu</a> is an in-memory storage medium. It lets php programs, like WordPress, store data in shared memory so it’s very fast to retrieve when needed. If APCu is available on your host server, you can configure this plugin to use it. It reduces the typical cache lookup time to one-fifth or less of the SQLite lookup time, which is itself a few tens of microseconds. Performance counts, especially on busy web sites.</p>
<p>Please look at <a href="https://wordpress.org/plugins/sqlite-object-cache/#installation" rel="ugc">Installation</a> to learn how to configure this plugin to use APCu. The plugin works fast without it, and faster with it.</p>
<p>WP-CLI: Even if APCu is in use, caching with SQLite is necessary when your web site uses WP-CLI, because WP-CLI programs do not have access to the APCu cache. This plugin writes all cached data both to APCu and to SQLite and makes sure the two are synchronized.</p>
<h4>WP-CLI</h4>
<p>You can control this plugin via WP-CLI once you activate it. Please type this command into your shell for details.</p>
<pre><code>wp help sqlite-object-cache
</code></pre>
<h4>Credits</h4>
<p>Thanks to <a href="https://profiles.wordpress.org/tillkruess/" rel="nofollow ugc">Till Krüss</a>. His <a href="https://wordpress.org/plugins/redis-cache/" rel="ugc">Redis Object Cache</a> plugin serves as a model for this one. And thanks to <a href="https://profiles.wordpress.org/aristath/" rel="nofollow ugc">Ari Stathopoulos</a> and <a href="https://profiles.wordpress.org/spacedmonkey/" rel="nofollow ugc">Jonny Harris</a> for reviewing this. Props to Matt Jones for finding and fixing a bug that appeared on a heavily loaded system. Thanks to <a href="https://speedable.net/about-us/" rel="nofollow ugc">Massimo Villa</a> for testing help, and to <a href="https://github.com/nickchomey" rel="nofollow ugc">nickchomey</a> for a comprehensive code review. All defects are, of course, entirely the author’s responsibility.</p>
<p>And thanks to Jetbrains for the use of their software development tools, especially <a href="https://www.jetbrains.com/phpstorm/" rel="nofollow ugc">PhpStorm</a>. It’s hard to imagine how a plugin like this one could be developed without PhpStorm’s tools for exploring epic code bases like WordPress’s.</p>
<h4>How can I learn more about making my WordPress site more efficient?</h4>
<p>We offer several plugins to help with your site’s database efficiency. You can <a href="https://www.plumislandmedia.net/wordpress/performance/optimizing-wordpress-database-servers/" rel="nofollow ugc">read about them here</a>.</p>


SQLite Object Cache


This is the plugin, the community of shared-hosting users have waited for without even knowing it.



Thanks to @ollijones the plugin author for making this possible and also for tagging it a community-plugin and doing friendly support here on the forum as well.



Great!


Great Plugin & friendly and fast support


Thanks Ollie for this great plugin!



I use this in conjunction with your other plugin Index WP MySQL For Speed and have installed these on quite a lot of websites with great success. Each and every one has increased speed.



It is faster and it feels faster and that's all the client cares about 🎉


5 star plugin. Speed increasement does not go unnoticed.


Honestly I was skeptical at first because of the low number of installs, but given the lack of options for object caching on a lot of shared hosting services that I cant control with a lot of client sites I decided to give it a shot on a few.  



This plugin is amazing, it helped turn a 15 second load on back end page edits into 3-4 seconds on a plugin heavy site running on an overpopulated shared host that I wont name here, but it was honestly awful, one of the worst I've ever used and a surprisingly big name.  I was brought in to try and optimize a monster on this occasion and it helped me turn it into some form of a workhorse again for my client, with almost no setup, toggled a checkbox or two and clicked save.   



This plugin needs more downloads, there are so many sites running on garbage hosting that could use this to make the back end a working environment again.



I will be using this on any site where I do not have redis or memcache available from here on out, cheers to the developer, you are an true WP Wizard.


Absolutely Brilliant


When no Memcached, no Redis available, this is the obvious solution.


Just what I was looking for

Amazing

great project!

A fast persistent object cache backend for the rest of us, powered by SQLite and accelerated by APCu

enomoto celtislab

<p>This plug-in stores the Page HTML / REST json data that dynamic WordPress blog has been generated as a output cache by SQLite. After the cache, it can respond to the request to the ultra-high speed by using a cache without starting the WordPress of processing.<br />
In the case of REST API, caching is also performed for internal requests made by logged-in block editors, etc.</p>
<h4>Simple Setup</h4>
<ul>
<li>Enable the cache, select the cache expiration.</li>
</ul>
<h4>Cache exclusion condition</h4>
<p>Pages</p>
<ul>
<li>Login user</li>
<li>Home/Front_page, Fixed Page, Post, Custom Post and WP embedded content card only. Other than this page does not cache.</li>
<li>Page you want to exclude from the cache, you can specify from the edit screen of the meta box.</li>
<li>Pages that are protected by a password does not cache.</li>
<li>PHP error (excluding E_NOTICE, E_STRICT, E_DEPRECATED) occurred page does not cache.</li>
</ul>
<p>REST API</p>
<ul>
<li>REST method is other than GET or OPTIONS</li>
<li>REST no data response</li>
<li>REST route endpoint you want to exclude from the cache, you can specify from the edit screen of the meta box.</li>
<li>REST error response</li>
<li>PHP error (excluding E_NOTICE, E_STRICT, E_DEPRECATED) occurred page does not cache.</li>
</ul>
<h4>Cache Clear</h4>
<ul>
<li>Clear the cache of automatically corresponding post in the articles and editing changes and the like of the comment.</li>
<li>The cache is a plugins and widgets such as a change is not clear. If you make these configuration changes, etc., should be cleared to use “Cache Clear” button.</li>
</ul>
<h4>Log</h4>
<ul>
<li>When you activate the log, you can easily check the behavior and execution time of the cache. (slower only a little)</li>
<li>SQLite database keeps logs for one week.</li>
</ul>
<h4>To further speed-up</h4>
<p>Page cache processing of this plugin is processing in PHP and SQLite.<br />
You can also use a faster Expert mode. To use Expert mode you need to edit ‘php.ini’ and add auto_prepend_file.<br />
Or you can edit the .htaccess file and use mod_deflate and mod_expires or mod_pagespeed etc to make it faster.<br />
If you do .htaccess edit, edit from the well studied. Do not forget that you back up your .htaccess file.</p>
<p><a href="https://wordpress.org/plugins/plugin-load-filter/" rel="ugc">plugin load filter</a> is also recommended for speed you do not use the cache.</p>
<p>For more detailed information, there is an introduction page.</p>
<p><a href="https://celtislab.net/en/wp-yasakani-cache/" title="Documentation" rel="nofollow ugc">Documentation</a></p>


YASAKANI Cache

It's good for cheap and low performace host / shared hosting server :). Definitely better than W3TC.

Many thanks to the developer!

Simple to use yet powerful

Simpler but faster or equal to other cache plugins. Especially on slow servers.


Simple and efficient

Easy to use and speeds up your site without any effort.

Great little cache plugin!

Simple ! Easy !! Ultra-high-speed !!!. Definitive edition of the page cache. And Bot and Security Utility.

SQLite Object Cache vs YASAKANI Cache