Overview
This plugin persists your WordPress object cache into an SQLite file to reuse data across requests, saving your database from redundant queries. Its biggest strength? It works perfectly even if your server completely lacks Redis, Memcached, or APCu. As long as your host supports PHP's SQLite3 extension, setting it up is surprisingly quick and simple.
Distribution Page: https://wordpress.org/plugins/sqlite-object-cache/
Conclusion
If you're on a shared hosting plan that doesn't provide Redis or Memcached, but you still want the massive benefits of object caching, this plugin is definitely your first choice. For any standard hosting setup, it provides immediate performance gains, so it's worth turning on and checking your statistics.
Why We Recommend It
- No Advanced Middleware Required
You don't need complex server setups like Redis or Memcached to enjoy the benefits of a persistent object cache on shared hosting. - Clear Maintenance Boundaries
Since cache data is inherently disposable, the developer is very clear that you don't need to back up the SQLite file, simplifying your backup routine. - WP-CLI Support
Withwp sqlite-object-cachecommands available, you can breeze through the setup in seconds if you prefer the terminal.
What It Can Do
- Persist Object Cache to SQLite
Drops anobject-cache.phpdrop-in to store caching data over time. - Enforce Size Limits
Sets max allowed cache size in MiB, automatically pruning the oldest entries when full. - APCu Integration
Optionally leverages APCu (if installed) to read data directly from RAM for even faster delivery. - Multisite Support
Fully functional on WordPress network setups (refer to FAQ to locate settings). - Statistics Dashboard
Offers a clear visual distribution of cache hits, misses, and execution times.
Best Use Cases
If you are running a blog or business site on standard shared hosting, and you feel like the admin dashboard is incredibly sluggish or you're trying to shave time off your TTFB (Time to First Byte). Just be mindful to uninstall any existing persistent object caching plugins before you switch, to avoid nasty conflicts.
Things to Note
- It is strictly incompatible with multi-server (load-balanced) setups according to the official FAQ. Placing the SQLite file on a shared network drive like NFS will likely lead to file locking disasters.
- Always check your 'Site Health' screen to ensure your server meets the minimum PHP limitations and has the SQLite3 module enabled before installing.
Summary
When you're at the stage where you want to add object caching to a shared hosting setup without access to Redis, this is an incredibly practical path to take. You can easily rely on it until your traffic explodes enough to justify upgrading to a managed environment with Redis!