Total 22/12/2024 : We HAVE 10746 Items and more than 3413 happy members.

IM DB Optimizer - V2.x

Version: 2.x

Item cover for download IM DB Optimizer

Overview

Optimization of the online store database is a very difficult issue, sometimes requiring 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.

That's just to ensure that customers do not have to deal with what they do not need to know, and created IMDBOptimizer. Capabilities:

  1. A hybrid system for caching SQL queries (DB + files), which allows increasing the speed of generating HTML pages (tested on standard OpenCart with 5500 products - performance increase from 30% to 70-80%) and partially balancing the load between the disk and the database.
  2. The filter "by words" is supported to exclude SQL queries from the caching process (case insensitive).
  3. The filter "by URL" is supported to exclude individual pages from the process of caching SQL queries (case insensitive).
  4. 4. Since only SQL queries are cached, such a module can be successfully used together with other caching modules (for example, v2pagecache). However, compatibility is best checked on a test server.
  5. 5. Have you installed the module? Nothing needs to be configured for caching. SQL queries automatically begin to be cached (subject to 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, they opened the same product from different categories - the options will be cached only 1 time.
  7. It can be applied both with the creation of indexes and without.
  8. During installation, the module immediately creates a typical setup, 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 caching module of the database level, it must be borne in mind that such features as displaying the actual balance of the goods 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 registry.php sound file is replaced
    4. Caching is applied only to the client part, in the admin part all requests are executed as usual.
    5. Consider that caching is an additional load. For example, when you first open the product page, it may take longer to load (a cache is created).
No comments found.
Login to post a comment
This item has not received any review yet.
Login to review this item
This list only shows little history changelog. See the full changelog of this item --> FULL CHANGELOG.
08 Jul 2021 - Version 2.x
Product Added to the system.
Note for Buyer
Please purchare this item you can see note for Buyer !
Read before purchase
  • Please check the version we provided before purchasing. Because it may not be the latest version of the author.
  • Before making a purchase, please read the Terms and Conditions & Refund Policy.
  • If you have any questions, please first read the FAQ.
  • If you haven’t found the answer to your question, please contact us, we will response asap.
  • You can download the product after purchase by a direct link on your Downloads sections.
  • Please note that any digital products presented on the website do not contain malicious code, viruses or advertising. We buy the original files from the developers.
Updates :
  • We offer frequent updates for one year from the date of purchase, but that doesn't mean we will have updates every version because not every developer release we have right away. After this period, you have to purchase the item again to receive further updates.
  • We regularly update products as soon as we are notified about an update, we go and download it from the author and update it on our site, but In case the current version of the product is not the latest, You can request an update for the product by contact form.
  • We send regular emails advising when products have been updated so please be sure to provide an active email address when you sign up.
Support :
  • Our support team is available 24/7, if you have any question or need help in installing or configuring digital products purchased on the website, please don’t hesitate to contact us.
  • Please note that we are not developers of the provided products, so our technical support capabilities are limited. We do not change product functionality and do not fix developer bugs.
  • For more information please read FAQ & About Us.
Login to report this item