Optimizing the database of an online store is a very difficult issue that sometimes requires separate research.

And the most unpleasant thing in this process is that only someone who knows sql-queries and understands databases (DB) can do at least some optimization.

Just so that clients don’t have to do what they don’t need to know, IMDBOptimizer was created. Capabilities:

1. A hybrid system for caching SQL queries (DB + files), which allows to increase the speed of HTML-page generation (tested on standard OpenCart with 5500 products – performance gain from 30% to 70-80%) and partially balance the load between the disk and the database.
2. Supported filter “by words” to exclude SQL queries from the caching process (case insensitive).
3. The filter “by URL” is supported to exclude individual pages from the caching of SQL queries (case insensitive).
4. Since only SQL queries are cached, such a module can be successfully used in conjunction with other caching modules (for example, v2pagecache). However, it is best to check compatibility on a test server.
5. Have you installed the module? You don’t need to configure anything for caching. SQL queries are automatically cached (based on filters), without the need to configure anything else.
6. Another distinctive feature of caching of SQL queries is that if the same query is used to generate different web pages or is simply executed repeatedly, then only one cache is used. A simple example, opened the same product from different categories – options will be cached only 1 time.
7. Can be used with or without index creation.
8. During installation, the module immediately creates a typical setting, you just need to enable the cache.