SD DB Cache Unleashed

SD DB Cache Unleashed
Maybe you want to check demo store before reading description?

What is cache?

Let's say that we have a very complex function that is used in our computing program very frequently. One way of speeding up our computing system as a whole is to save result from our complex function, and use it instead of calculating it every time. Subsystem responsible for storing and accessing our result is called cache.

Writing a good cache is a very complex task, and biggest problem that needs to be solved is data invalidation. As data changes, result from our function could also change. And if result changes, we want to delete previous result from cache and recalculate it.

Luckily, good people that made mysql server incorporated a good cache system in it and we have to make a good use of it.

DB Cache Unleashed

This extension improves "compatibility" with mysql cache, effectively enabling mysql to automatically cache more OC database queries.

DB Cache Unleashed utilizes mysql cache that will automatically invalidate stale data. As far as we know it, no other caching extension for Opencart will delete stale data from cache "as it happens". Cached queries are shared between different pages, making cache "warm-up" very quickly.

Benchmark

We performed benchmark on OC 1.5.6.4 with about 25 000 products in 1000 categories. Benchmark for this extension was performed on installation with "Premium DB Indexes" already installed. Speedup is about 7x, and is much higher if "Premium DB Indexes" extension is not present.

Is this extension for me?
This extension will speed up only user area. If you are using full page cache, user experience will remain same, but cache regeneration will be faster. For shops that have many products/categories/orders we recommend using "Premium DB Indexes" with this extension.


What exactly this extension does?
1. disables counting of product views
2. rewrites sql queries so they can be cached by mysql cache

Find out more about our plugin here on official plugin page.

Please be sure to check side-by-side performance comparison between shops with our optimization extension and without it. Both OpenCart instances are of absolutely same configuration handling identical amount of categories and articles or for your convenience, please follow the link to optimized and unoptimized versions to see for yourself.

Additional info and resources:


UNIVERSAL version

This version is much more compatible with templates such as Journal 2.

Templates (such as Journal 2) are known to bypass some or all of the core files that are changed by this extension. UNIVERSAL version works differently, so templates can not "turn off" changes. This version changes mysqli and/or mpdo database driver so it can intercept and rewrite queries.


Please read documentation before purchase or when installing new version.




BONUS Downloads:
These modifications are not part of extension and are not supported.
* BONUS-categories-speedup.ocmod - for OC2+ - alters OC function for fetching categories to use 1 sql. This function is used by some extensions and themes (Journal,...) to build cetegory menus with nested categories. If you have such menu, this modification could speedup your shop.




Buy
Price
$36.00

  • Developed by OpenCart Community
  • Documentation Included

Rating

Compatibility
2.0.0.0, 2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0, 1.5.4, 1.5.4.1, 1.5.5, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4, 1.5.4, 1.5.4.1, 1.5.5, 1.5.5.1, 1.5.6, 1.5.6.1, 1.5.6.2, 1.5.6.3, 1.5.6.4, 2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0, 2.0.0.0, 2.0.1.0, 2.0.1.1, 2.0.2.0, 2.0.3.1, 2.1.0.1, 2.1.0.2, 2.2.0.0

Last Update
24 Apr 2016

Created
8 Dec 2014
46 Sales
29 Comments
SuperDruid
SuperDruid
Member since: 8 Apr 2014

View all extensions Get Support