Monitor, optimize, repair, defragment and clean database tables. Increase the performance and speed of the web and fix DB errors. It keeps the database 100% optimized and without errors. Contains more advanced features.
What this module does for you
The Ultimate Database Optimizer for Prestashop module is a powerful tool designed to optimize, repair, clean, defragment the Database tables. It also contains advanced tools to perform actions such as compressing tables, changing file formats, changing tables, etc …
Your store’s database is a very delicate part of your business, where all its information is stored (product catalog, page content, customers, purchases, registrations, etc …). Throughout the life of an online store, the database is in constant use: reading records, recording new records and deleting records. These operations leave traces in the tables, fragmenting the information, deteriorating its structure and appearing referential integrity errors. If attention is not paid and measures are not applied, the database will begin to be unstable, slowing down all its operations and causing serious errors that will affect both the user’s browsing on the web and the purchase processes, registrations, etc. .
This translates into economic losses, loss of the number of sales and problems with customers due to not being able to navigate or use the store correctly. This also causes a decrease in SEO and therefore loss in daily visits.
Ultimate Database Optimizer has been developed as a total solution to all these problems. Becoming an essential module that every online store should have in order to have the Database at full performance, 100% optimized and without any error or critical failure.
WHAT CAN THE ULTIMATE DATABASE OPTIMIZER MODULE DO?
The module performs the following actions on your Database:
- OPERATION THROUGH AN ADVANCED GRAPHIC INTERFACE
- ANALYZE THE DATABASE COMPLETELY
- OPTIMIZE THE DATABASE
- COMPLETE OPTIMIZATION WITH JUST ONE CLICK
- REPAIR THE DATABASE TABLES
- REPAIR ORDERS WITH MISSING ADDRESSES
- DELETE DUPLICATE VALUES IN CONFIGURATION
- DEFRAGMENT THE TABLES
- CHANGE THE DATABASE PREFIX
- CHANGE THE BOARD MOTOR
- CHANGE THE FILE FORMAT OF THE TABLES
- COMPRESS AND UNCOMPRESS THE TABLES
- MONITOR THE STATUS OF THE DATABASE
- DISPLAY NOTIFICATIONS ON SUGGESTIONS, WARNINGS AND RISKS IN THE DATABASE STATUS
- SHOW ADVANCED INFORMATION OF THE DATABASE AND ITS COMPLETE STRUCTURE
- CLEAR THE RECORDS FROM THE DYNAMIC TABLES
- REMOVE ABANDONED SHOPPING CARTS
- REMOVE SPECIFIC EXPIRED PRICES
- ELIMINATE EXPIRED DISCOUNTS
- DELETE THE CATALOG
- DELETE DATA OF ORDERS, CUSTOMERS, ADDRESSES, ETC…
- MAKING A BACKUP COPY OF THE DATABASE
- RESTORATION OF BACKUP COPIES OF THE DATABASE
- RECORD ALL ACTIONS CARRIED OUT FROM THE MODULE
- PERIODIC MAINTENANCE OF THE DATABASE THROUGH SCHEDULED TASKS
- BACKUP COPIES OF THE DATABASE THROUGH SCHEDULED TASKS
- DISPLAY THE STATUS OF THE DATABASE THROUGH AUTOMATIC EMAIL SENDING
Another of the newest features is the integration of a complex algorithm to carry out constant monitoring tasks of the database, instantly warning of the status of the database, so that the user can know at all times what situation the database is in. database and be able to solve any problem from the same module.
This module is designed both for advanced users who have knowledge of the structure of the Database, and for clients who do not have much knowledge. You will have at your disposal a button called “Optimization in one click” to be able to perform a complete optimization of the Database with just pressing that button. The system will carry out the necessary actions automatically, leaving the Database 100% optimized.
With this module you will be able to keep the Database of your store fully optimized, repaired and at full capacity, considerably increasing the performance and speed of the web, speeding up to the maximum all the processes and queries that are carried out during the purchase operations and registration of customers in the store. You will increase SEO and avoid critical errors in the store.
Changelog
What’s New in Version 3.1.0(06/14/2022)
- [FIX] Minor bugs with parameters value in Control panel.
Support and updates
At the time of purchase, your Business Care subscription for your first year is automatically included, then tacitly renewed at the end of the period.
You can cancel your subscription at any time, before the end of the current period.
Services included in your subscription:
- Security updates
- Compatibility updates
- Developments and upcoming features
- Unlimited support
Want more details? Check out the most frequently asked questions about Business Care.