SQLite Object Cache
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.
Top keywords
- cache17×2.27%
- server12×1.60%
- apcu10×1.33%
- site10×1.33%
- wordpress10×1.33%
- object9×1.20%
- database7×0.93%
- object cache7×0.93%
- redis6×0.80%
- web6×0.80%
- caching5×0.67%
- offer5×0.67%
Super Page Cache – Cloudflare Cache, Page Speed & Core Web Vitals
Super Page Cache is a powerful full page cache plugin for WordPress that caches static files (CSS, JS, images) and HTML webpages at both server disk-level and the global Cloudflare CDN. Get enterprise-level performance with zero configuration required. Super Page Cache improves site speed by enabling server-side caching, cache preloading, local Google Fonts, and removing unused CSS and JavaScript, boosting Core Web Vitals and load times. Works right out of the box with or without Cloudflare. Powerful disk caching saves files locally on your server. To use Cloudflare CDN, just enter your API Key or Token. The intuitive dashboard includes detailed settings and built-in documentation, though most users won’t need to change the defaults. ⚡ Quick Links Documentation → Complete setup and configuration guide Support Forum → Community help and expert support YouTube Videos → Step-by-step visual guides for every feature Go Pro → Advanced features and priority support 🚀 How Does The Plugin Work? Disk Caching (Works Without Cloudflare): Server-level caching saves HTML pages and static files directly to your server, loading pages instantly without any CDN. Cloudflare CDN (Optional): Connect your Cloudflare account to leverage 200+ edge locations using modern Cache Rules. Works with FREE Cloudflare Plan – no paid account required. Achieve higher Pingdom and GTmetrix scores with edge delivery. Supports Free, Pro, and Enterprise Cloudflare plans with auto-purging, cron jobs, and integrated metrics. 🔥 Core Features (Free Version) 🚀 Complete Caching Solution Disk Caching: Lightning-fast server caching with Cloudflare fallback CDN Integration: Optional Cloudflare CDN with 200+ edge locations Cache Controls: Exclude cookies, query params, URIs, AMP, feeds, REST API Cache Lifespan: Custom expiration or never-expire settings Header Management: Preserve critical response headers Cache Buster: Logged-in users never see cached content Performance Metrics: Track cache effectiveness ⚡ Performance Optimization Google Fonts: Combine and serve locally for better Web Vitals Lazy Loading: Images, videos, iframes, background images Lazy Load Exclusions: By keywords, URL patterns, or CSS classes Assets Manager: Enable/disable CSS/JS per page Browser Caching: Auto-configure .htaccess rules 🛠️ Advanced Cache Management Auto-Purging: Clear cache on content updates including related pages Granular Purge: HTML only or entire cache with assets Preloader: From sitemaps, menus, or recent posts (manual/CRON) Background Processing: Uses Action Scheduler Queue-Based Purging: Prevent server overload Backend Bypass: Prevent admin dashboard caching Per-Page Control: Exclude via editor metabox Toolbar Purging: Instant purge from WP toolbar 🔧 Developer & Power User Features Redesigned Dashboard: Intuitive navigation with grouped settings Built-in Documentation: Tips within the dashboard Cache Backends: advanced-cache.php or cURL-based Defer JS Filter: spc_defer_script to exclude scripts Role Permissions: Control who can purge cache Cloudflare API: All plans via API Key or Token Export/Import: Settings as JSON Preserve on Deactivation: Retain settings for staging 🗄️ Database Optimization Database Cleanup: Remove revisions, auto-drafts, trash, spam, transients Scheduled Maintenance: Daily, weekly, or monthly Table Optimization: SQL OPTIMIZE TABLE for defragmentation Selective Cleanup: Choose which data types to clean 🌐 Universal Compatibility Premium Hosts: Kinsta, WP Engine, SpinupWP, and more eCommerce: WooCommerce, Easy Digital Downloads Server Caches: Varnish, OPcache auto-purge Prefetch: Internal links via Instant.page 💎 Super Page Cache PRO with Advanced Performance Features Ignore Marketing Parameters: Better cache hit rate (UTM, affiliate, tracking codes) Defer JavaScript: Eliminate render-blocking JS. Learn more Delay JavaScript: Load JS on interaction only. Learn more Advanced Lazy Loading: Viewport detection, above-the-fold optimization Advanced Exclusions: Exclude specific JS/pages from caching Priority Support: Faster email response times Upgrade to Pro 🎯 Usage Note Disable page caching in other plugins (WP Rocket, LiteSpeed Cache, W3 Total Cache). Safe to use alongside Optimole, Autoptimize, Perfmatters, ShortPixel for asset optimization. ⭐ What Users Say ★★★★★ “Response times dropped from 400ms+ to below 200ms. Almost the same as my static S3 site—using the free version!” – @jurijs0 ★★★★★ “A game-changer for our website’s performance! Noticeable improvement in loading times, boosted engagement and SEO.” – @brandnexusstudios Leave a review | Follow us on Twitter | YouTube Super Page Cache is backed by Themeisle, powering 1M+ WordPress sites with 450+ five-star Trustpilot ratings.