Title: SQLite difference with Opcache
Last modified: May 23, 2023

---

# SQLite difference with Opcache

 *  Resolved [ms100](https://wordpress.org/support/users/ms100/)
 * (@ms100)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/sqlite-difference-with-opcache/)
 * Hello support,
   Hope you are doing well today.Yesterday I installed the Index 
   WP MySQL For Speed plugin for our Woocommerce webshop, and the first impression
   is really good. The SQLite Object Cache also has my interessent.I have been using
   [Docket Cache](https://wordpress.org/plugins/docket-cache/) with Opcache to create
   Object caching, and I think the Docket Cache plugin is working really well.Could
   you please explain the differences? What scenario would Object Cache via SQLite
   be preferred over Object Cache via Opcache?
 * I see in the [WordPress documentation](https://developer.wordpress.org/reference/classes/wp_object_cache/#persistent-cache-plugins)
   the SQLite Object Cache plugin is mentioned as alternative to Redis or Memcached.
   So I wonder if I should be swiching to your plugin 🙂
 * Hope you can explain a little bit for me.
 * Thank you in advance.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/sqlite-difference-with-opcache/#post-16760704)
 * Thanks for this question. I confess I had not studied Docket Cache until you 
   mentioned it, so I am no expert on that plugin.
 * My plugin is mentioned in the WordPress documentation for a simple reason: I 
   have been working with the WordPress Core Performance Group on database optimization,
   and we were asked to revise the documentation. Had we been aware of Docket Cache
   we would have mentioned it. I’ll probably put in a doc ticket to add it the documentation.
 * What’s the difference between the two? Mine uses [SQLite ](https://www.php.net/manual/en/book.sqlite3.php)
   to hold the cached items, and Docket Cache puts each cached item into its own.
   php file. That means my plugin uses three files (.sqlite, .sqlite-shm, .sqlite-
   wal) on the filesystem, where Docket Cache necessarily uses thousands of files.
   On shared hosting, thousands of files can cause problems. (I developed mine because
   some clients were struggling with performance on GoDaddy-hosted sites.)
 * Mine uses php’s [igbinary extension](https://www.php.net/manual/en/intro.igbinary.php)
   to serialize cache items for storage, and Docket Cache translates them to php
   code to store them. Upon loading cache items, Docket Cache can take advantage
   of php’s opcode cache; the cached items are simply php programs; if they are 
   already loaded into the opcode cache reloading them is cheap.
 * Mine uses a least-recently-updated algorithm to evict cache entries when the 
   cache grows too large. I believe Docket Cache uses a least-recently-USED algorithm.
   That algorithm is theoretically superior to mine, but adds cache-writing overhead
   whenever a cache item is read. I wanted reads to be as fast as possible.
 * If you are happy with the performance and stability of Docket Cache I see no 
   reason to switch to my plugin.
 * I hope this helps.
 *  Thread Starter [ms100](https://wordpress.org/support/users/ms100/)
 * (@ms100)
 * [2 years, 10 months ago](https://wordpress.org/support/topic/sqlite-difference-with-opcache/#post-16767051)
 * Thank you [@olliejones](https://wordpress.org/support/users/olliejones/) for 
   the reply.
 * Our hosting provider does not seem to have an issue (at this moment in time) 
   with the number of files. But I am happy to know another great Object Cache plugin
   is available.
 * I have added the SQLite Object Cache plugin to my favourites and I will definately
   follow the future developpement of the plugin. Have a great day 🙂

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘SQLite difference with Opcache’ is closed to new replies.

 * ![](https://ps.w.org/sqlite-object-cache/assets/icon-128x128.jpg?rev=2829632)
 * [SQLite Object Cache](https://wordpress.org/plugins/sqlite-object-cache/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/sqlite-object-cache/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/sqlite-object-cache/)
 * [Active Topics](https://wordpress.org/support/plugin/sqlite-object-cache/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/sqlite-object-cache/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/sqlite-object-cache/reviews/)

## Tags

 * [textile](https://wordpress.org/support/topic-tag/textile/)

 * 2 replies
 * 2 participants
 * Last reply from: [ms100](https://wordpress.org/support/users/ms100/)
 * Last activity: [2 years, 10 months ago](https://wordpress.org/support/topic/sqlite-difference-with-opcache/#post-16767051)
 * Status: resolved