SQLite Object Cache vs WPSpeed – WordPress Speed, Cache & Performance Optimization (Core Web Vitals, PageSpeed 100)

A persistent object cache helps your site perform well. This one uses the widely available SQLite3 extension, and optionally the igbinary and APCu extensions to php. Many hosting services offer those extensions, and they are easy to install on a server you control. What is this about? 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 page cache; 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. Caches 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 memoization cache. 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. Who should use this? If your site runs on a single web server machine, and that server provides the SQLite3 and igbinary extensions to php, this plugin will almost certainly make your site work faster. And if that server provides the APCu extension, this plugin uses it too. Some hosting providers offer redis cache servers. If your provider offers redis, it may be a good choice. You can use it via the Redis Object Cache plugin. Sites using redis have one SQL database and another non-SQL storage server: redis. Other hosting providers offer memcached, which has the Memcached Object Cache plugin. And some large multipurpose cache plugins, such as the LiteSpeed Cache, also offer object caching based on one of those cache server software packages. 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. But, for single-server site configurations, SQLite, possibly assisted by APCu, performs well. And the vast majority of sites are single-server. APCu APCu 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. Please look at Installation to learn how to configure this plugin to use APCu. The plugin works fast without it, and faster with it. 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. WP-CLI You can control this plugin via WP-CLI once you activate it. Please type this command into your shell for details. wp help sqlite-object-cache Credits Thanks to Till Krüss. His Redis Object Cache plugin serves as a model for this one. And thanks to Ari Stathopoulos and Jonny Harris for reviewing this. Props to Matt Jones for finding and fixing a bug that appeared on a heavily loaded system. Thanks to Massimo Villa for testing help, and to nickchomey for a comprehensive code review. All defects are, of course, entirely the author’s responsibility. And thanks to Jetbrains for the use of their software development tools, especially PhpStorm. 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. How can I learn more about making my WordPress site more efficient? We offer several plugins to help with your site’s database efficiency. You can read about them here.

WPSpeed is a powerful and complete WordPress performance plugin, built to achieve the highest Google PageSpeed scores — including 100 on mobile — while improving Core Web Vitals (LCP, CLS, INP) and dramatically reducing loading times. Using an innovative system that generates lightweight HTML copies of your pages and bypasses WordPress execution, WPSpeed delivers static, cached output for maximum speed. Combined with automatic optimization, image compression, lazy loading, minification, and advanced resource control, WPSpeed becomes an all-in-one solution that can fully replace multiple optimization plugins. 👉 Unlike traditional caching plugins, WPSpeed generates lightweight static HTML versions that bypass WordPress execution entirely reducing TTFB to near-zero. WPSpeed is the easiest plugin to speed up your WordPress website being capable to find the optimal configuration automatically and integrating the Google PageSpeed test. WPSpeed is ideal for users searching for: fast WordPress plugin to improve front-end and back-end performance improve TTFB WordPress (reduce Time To First Byte) reduce server load on shared hosting or high-traffic sites fix INP (Interaction to Next Paint) and other Core Web Vitals issues optimize Elementor performance and reduce heavy builder scripts WordPress performance optimization cache plugin with static HTML caching mobile speed optimization (reach 100/100 PageSpeed) image optimization with WebP/AVIF minify and combine JavaScript/CSS lazy load images, iframes and heavy HTML elements You can watch the impressive video and check the demo site: 🚀 Try WPSpeed Live on WordPress Playground 🚀 🚀 GET THE PRO VERSION 🚀 FREE vs PRO ⚠️ FREE version limitations: – Only the homepage is optimized – Only 1 page can use full optimization Upgrade to the PRO version to: Optimize all pages Enable static HTML caching (.htaccess caching) Boost TTFB dramatically Unlock full image optimization rules Remove all limitations Receive expert on-site support Purchase a PRO license: GET THE PRO VERSION VISIT PRODUCT PAGE Interested in our WordPress Speed Performance Service? Contact us now at [email protected] by providing an admin account to our expertise team for a free test installation on your website and performance optimization. 🚀 Key Features 🔥 Adaptive Contents™ Generate a lightweight version of your website that dramatically increases PageSpeed scores while preserving full functionality. ⚡ Instant Page™ Ultra-fast navigation using just-in-time preloading. Loads the next page before the user even clicks. 🧠 Auto Configuration + Integrated PageSpeed Test WPSpeed finds optimal settings automatically and integrates Google PageSpeed Insights directly in the plugin. 🏎 Static HTML Cache Serve pages as static HTML and bypass WordPress execution for maximum performance and extremely low TTFB. 🧹 Minify JS, CSS & HTML Reduce file size, remove whitespace, optimize delivery and combine multiple assets into fewer requests. 🎯 Above-the-Fold CSS Extraction Extract critical CSS and load the rest asynchronously to eliminate render-blocking resources. 📦 Defer / Async / Preload Advanced control of CSS, JS and Web Fonts to improve LCP and reduce blocking time. 🖼 Image Optimization (WebP / AVIF / Lossless) Resize, compress and optimize large images Convert images to next-gen formats (WebP + AVIF) Create srcset automatically Optimize background images 💤 Lazy Load (Images, Iframes, HTML Elements) Load heavy content only when necessary to fix LCP and improve scroll performance. 🗂 Resource Control Remove unused CSS, JS and fonts. Rewrite URLs to CDN automatically. 🔧 Htaccess Optimization Apply browser caching, compression and more via automatic rules. 🧱 DOM Reduction Remove unnecessary DOM elements and load heavy blocks asynchronously. 🌐 HTTP/2 Optimizations Support for server push and resource preload. 🛡 Conflict Management Full exclusions system for scripts and styles to resolve issues easily. WPSpeed functionalities include: •Scripts minification: Javascript can be minified to reduce the total scripts size and save bandwidth •Stylesheets minification: CSS can be minified to reduce the total CSS size, save bandwidth and extract the ‘Above-the-fold’ CSS •HTML minification: The HTML source code can be minified to reduce the total page size and save bandwidth •Combine multiple JS and CSS files: Javascript and CSS can be combined in single files to minimize the HTTP request overhead •Adaptive Contents™: this technology makes it possible to generate a lightweight version of the website to raise up the page speed score without losing website functionalities •Instant Page technology™: Instant Page uses just-in-time preloading. This feature, compatible with both desktop and mobile devices, preloads a page right before a user clicks on it •Auto configuration and integrated Google PageSpeed: WPSpeed is capable to find the optimal configuration automatically and integrates the Google PageSpeed test •Page cache: Integrated and optimized technology for page caching to avoid heavy requests to your server and database. The PRO version supports the .htaccess page caching so that pages are served up as static HTML completely bypassing the execution of WordPress and dramatically increases performance and reducing the TTFB •Defer and preload of assets: CSS, JS and Web Fonts can be loaded in defer, async or preload mode •Lazy-load images: Images and iframes that are out of view can be lazy-loaded only when the user scrolls down the page to display them •Lazy-load HTML elements: Heavy HTML elements that slow down the LCP can be easily lazy-loaded •Images optimization: Large images can be rescaled, resized and optimized on the fly to dramatically reduce the page size and bandwidth •Optimization of background images: WPSpeed is capable to optimize also images that are set as a background through HTML and CSS styles •Lossless optimization: Large images in PNG and JPG format can be optimized on the fly using a lossless algorithm •Srcset creation for images: WPSpeed is capable to automatically create an image srcset using up to 4 differently-sized images for various resolutions •Images conversion to WebP and AVIF: Images can be converted in realtime to the WebP and AVIF next generation format •Assets removal: It’s possible to remove CSS/JS files and Fonts to avoid the loading of unnecessary resources •Htaccess optimization: A series of optimizations can be applied to the htaccess file in order to leverage the browser caching •CSS extraction: WPSpeed is capable to extract basic CSS styles and load them above the fold to avoid render blocking resources •DOM tree reduction: Excessive DOM elements can be automatically removed and loaded asynchronously •Combine images: It’s possible to generate a single container image for multiple backgrounds applied through CSS •HTTP/2 optimizations: WPSpeed works with HTTP/2 compatible servers to enable server push •CDN support: Links for all assets can be automatically rewritten to point to your CDN domain •Fix conflicts easily: WPSpeed integrates a powerful exclusions system to fix conflicts due to minification of scripts Documentation Download and read the PDF documentation or visit our FAQ page on the main plugin site for more information on how the plugin works and how to configure it to improve your scores for Google PageSpeed Insights and GTMetrix. If you have a license for the PRO version you can contact us for on site support at [email protected] Advanced Features and Premium Support If you need assistance on your website by our expertise team to find optmimal settings of WPSpeed and reach the maximum score, please purchase a license and contact us at [email protected] to get on site service.