Database optimization and caching of sql queries in OpenCart 2.0-2.2
Opportunities:
1. Hybrid SQL query caching system (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. The "by words" filter is supported to exclude SQL queries from the caching process (case-insensitive).
3. The "by URL" filter is supported to exclude individual pages from the SQL query caching process (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 better to check compatibility on a test server.
5. Have you installed the module? Nothing needs to be configured for caching. SQL queries automatically begin to be cached (taking into account filters), without the need to configure anything else.
6. Another distinctive feature of caching SQL queries is that if the same query is used when generating different web pages or is simply executed repeatedly, then only one cache is used. A simple example, opened the same product from different categories — the options will be cached only 1 time.
7. It can be used both with the creation of indexes and without.
8. During installation, the module immediately creates a typical setting, you just need to enable the cache.
9. Easy to turn on and easy to turn off.
Limitations and nuances:
1. Since this is a database-level caching module, it is necessary to take into account that such features as displaying the actual balance of the product or the current price in the card are not supported (the data is cached).
2. Only SQL queries starting with select are cached.
3. The sound file is replaced registry.php
4. Caching is applied only to the client part, in the admin part all requests are executed as usual.
5. Keep in mind that caching is an additional burden. For example, when the product page is opened for the first time, it may take longer to load (a cache is created).
Info: https://shop.opencart-russia.ru/imdboptimizer
Opportunities:
1. Hybrid SQL query caching system (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. The "by words" filter is supported to exclude SQL queries from the caching process (case-insensitive).
3. The "by URL" filter is supported to exclude individual pages from the SQL query caching process (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 better to check compatibility on a test server.
5. Have you installed the module? Nothing needs to be configured for caching. SQL queries automatically begin to be cached (taking into account filters), without the need to configure anything else.
6. Another distinctive feature of caching SQL queries is that if the same query is used when generating different web pages or is simply executed repeatedly, then only one cache is used. A simple example, opened the same product from different categories — the options will be cached only 1 time.
7. It can be used both with the creation of indexes and without.
8. During installation, the module immediately creates a typical setting, you just need to enable the cache.
9. Easy to turn on and easy to turn off.
Limitations and nuances:
1. Since this is a database-level caching module, it is necessary to take into account that such features as displaying the actual balance of the product or the current price in the card are not supported (the data is cached).
2. Only SQL queries starting with select are cached.
3. The sound file is replaced registry.php
4. Caching is applied only to the client part, in the admin part all requests are executed as usual.
5. Keep in mind that caching is an additional burden. For example, when the product page is opened for the first time, it may take longer to load (a cache is created).
Info: https://shop.opencart-russia.ru/imdboptimizer