by Oliver Jones
5 (47 reviews)
SQLite Object Cache
A fast persistent object cache backend for the rest of us, powered by SQLite and accelerated by APCu
Compatible with WP 6.9
v1.6.0
Current Version v1.6.0
Updated 1 month ago
Last Update on 26 Nov, 2025
Synced 13 hours ago
Last Synced on
Rank
#2,468
—
No change
Active Installs
9K+
-0.2%
KW Avg Position
22.2
-0.4 better
Downloads
90.5K
+7 today
Support Resolved
50%
—
No change
Rating
100%
Review 5 out of 5
5
(47 reviews)
Next Milestone 10K
9K+
10K+
156
Ranks to Climb
-
Growth Needed
8,000,000
Active Installs
Pro
Unlock Exact Install Count
See the precise estimated active installs for this plugin, calculated from real-time ranking data.
- Exact install estimates within tiers
- Track install growth over time
- Milestone progress predictions
Need 935 more installs to reach 10K+
Rank Changes
Current
#2,468
Change
Best
#
Downloads Growth
Downloads
Growth
Peak
Upgrade to Pro
Unlock 30-day, 90-day, and yearly download history charts with a Pro subscription.
Upgrade NowReviews & Ratings
5.0
47 reviews
Overall
100%
5
47
(100%)
4
0
(0%)
3
0
(0%)
2
0
(0%)
1
0
(0%)
Tracked Keywords
Showing 5 of 5| Keyword | Position | Change | Type | Updated |
|---|---|---|---|---|
| apcu | 1 | — | Tag | 16 hours ago |
| SQLite | 1 | — | Tag | 16 hours ago |
| object cache | 3 | — | Tag | 16 hours ago |
| cache | 19 | — | Tag | 16 hours ago |
| performance | 87 | — | Tag | 16 hours ago |
Unlock Keyword Analytics
Track keyword rankings, search positions, and discover new ranking opportunities with a Pro subscription.
- Full keyword position tracking
- Historical ranking data
- Competitor keyword analysis
Support Threads Overview
Resolved
Unresolved
4
Total Threads
2
Resolved
2
Unresolved
50%
Resolution Rate
Track This Plugin
Get detailed analytics, keyword tracking, and position alerts delivered to your inbox.
Start Tracking FreePlugin Details
- Version
- 1.6.0
- Last Updated
- Nov 26, 2025
- Requires WP
- 5.5+
- Tested Up To
- 6.9
- PHP Version
- 5.6 or higher
- Author
- Oliver Jones
Support & Rating
- Rating
- ★ ★ ★ ★ ★ 5
- Reviews
- 47
- Support Threads
- 4
- Resolved
- 50%
Keywords
Upgrade to Pro
Unlock keyword rankings, search positions, and detailed analytics with a Pro subscription.
Upgrade NowSimilar Plugins
WP Adminify – White Label WordPress, Admin Menu Editor, Login Customizer
7K+ installs
#2,735
Master Addons For Elementor - White Label, Free Widgets, Hover Effects, Conditions, & Animations
40K+ installs
#929
WP-Sweep
100K+ installs
#284
SSL Insecure Content Fixer
100K+ installs
#292
TinyPNG – JPEG, PNG & WebP image compression
100K+ installs
#307
Frequently Asked Questions
Common questions about SQLite Object Cache
Yes. To see the Settings page, choose Settings > Object Cache from the first site, or any site, in the multisite installation.
Exactly predicting each site's speedup is not possible. Still, benchmarking results comparing it to other object caching schemes are promising. Please see this. If you run a benchmark, please let the author know by leaving a comment on that page or using the support forum.
The default setting for Cached Data Size is 16 megabytes (MiB). This plugin allows the actual cached data size to grow larger than that, and occasionally removes old -- the least recently updated -- data to trim back the size to the setting. Take a look at the Statistics page. If your actual cached data usage under All Groups is consistently larger than the setting, double the setting. If you operate a large and busy site, try an initial setting of 32 MiB, then adjust it based on the growth of the actual size. Notice that this setting controls the size of the data in the cache. That is the size shown under All Groups. The data file used by SQLite is larger than that.
SQLite is fast and efficient database software. It doesn't require a separate server. Instead, it is built into php using the SQLite3 extension. SQLite programs don't need to open network connections to send requests and wait for replies.
igbinary is a php extension that provides an efficient way to serialize and compress the kinds of data objects stored in caches. It, in some cases, uses less than half the storage space of the built-in php data serializer. If igbinary is available in your php configuration, this plugin uses it, unless you force it not to by setting WP_SQLITE_OBJECT_CACHE_SERIALIZE to true in wp-config.php.
APCu is php extension offering an in-memory storage medium. You can configure this plugin to use it to speed up cache lookups.
On most operating systems the size of the APCu cache is, as installed, 32MiB. If you need to increase this size you can add a line to your php.ini file mentioning the apc.shm_size configuration option. For example, the line apc.shm_size = 64M sets the size to 64MiB. Please consult your operating system or hosting provider documetation for information on how to do this. Notice that sometimes multiple WordPress installations that run on the same server share the same APCu cache, so provide enough space for them all. And keep in mind that this plugin only uses APCu to accelerate its operations, so the consequences of setting its size too small are not great.
No. Your MariaDB or MySQL database sql server still holds all your content. All your site's imports, exports, backups and other database operations continue to function normally. This plugin uses SQLite simply to hold named values. For example, a value named "post|3" will hold a temporary, easy-to-retrieve cached copy of post number 3. When it needs that post, WordPress can fetch it quickly from SQLite.
No, you don't. This plugin doesn't use SQLite as a full-fledged database server. A persistent object cache needs some kind of storage mechanism. SQLite serves this plugin as a fast and simple key / value storage mechanism. Some hosting providers offer the scalable high-performance redis cache server. You can use it via Redis Object Cache plugin. Sites using redis have one SQL database and another non-SQL storage scheme: redis. Some other hosting providers offer memcached, which has the Memcached Object Cache. But many hosting providers don't offer either redis or memcached, while they do offer SQLite. This plugin enables your site to use a persistent object cache even without a separate cache server. And, because everything happens within your web server, the performance is good.
Probably. Page caching and persistent object caching are completely separate functions in WordPress. But, some multi-feature caching plugins support optional object caching using redis or memcached. If that feature is enabled in your page cache plugin, you should not use this plugin. You can find out whether your page-cache plugin also enables persistent object caching. Look at the Drop-in section of the Plugins -> Installed Plugins page. If it mentions the drop-in called "object-cache.php" then your page cache plugin is handling persistent object caching. You should disable that feature before using this plugin. Users of this plugin have found that it works well with WP Rocket, LiteSpeed Cache, WP Total Cache, WP Super Cache, and WP Fastest Cache. It also works with Cloudflare and other content delivery networks. The author has not learned of any incompatibilities in this area. (If you find one please start a support topic!)