menu
close search

Needs

  • next_week Migrate my store
  • group_add Increase traffic
  • show_chart Optimize conversions
  • shopping_cart Increase average cart
  • computer Make browsing easier
  • mood Increase customer satisfaction
  • access_time Save time

Features

  • descriptionProduct Page
  • computerDesign & Navigation
  • loyaltyPromotions & Marketing
  • searchTraffic & Marketplaces
  • paymentPayment
  • local_shippingShipping & Logistics
  • assignmentAdministration
  • peopleCustomers
  • shareFacebook & Social Networks
  • gps_fixedSpecialized Platforms
View all modules chevron_right
Key Features for your Business Sector

Key Features for your Business Sector

Great deals

Great deals

Modules developed by

Modules developed by PrestaShop

Style

  • Minimalist
  • Clean
  • Neutral
  • Original
  • Baroque

Business Sector

  • pets Animals & Pets
  • brush Art & Culture
  • directions_car Automotive & Cars
  • local_drink Drink & Tobacco
  • computer Electronics & Computers
  • shopping_basket Fashion & Shoes
  • restaurant_menu Food & Restaurant
  • local_florist Gifts, Flowers & Celebrations
  • healing Health & Beauty
  • home Home & Garden
  • store Jewelry & Accessories
  • child_friendly Kids & Toys
  • whatshot Lingerie & Adult
  • directions_bike Sports, Activities & Travel
View all templates chevron_right
Premium Templates Premium Templates
Email templates Email Templates

Help

PrestaShop Support PrestaShop Support
PrestaShop Training PrestaShop Training

Services

Hosting Hosting
Website audit and optimization Website audit and optimization

Resources

View all resources chevron_right
User Guide User Guide
e-Commerce Calendar e-Commerce Calendar
Customize your store tabs with a favicon trending_flat
PrestaShop Addons - The Official Marketplace
Home / / / / Ultimate Database Optimizer
close
Your data will be transferred to the Partner when you download this module.
close

I confirm my contact details to continue

close

Yummy, your shop will love it! Your product has been successfully downloaded Need a hand to install it in your PrestaShop store? Follow our tutorial: How to install a paid or free module Addons

Ultimate Database Optimizer

Ultimate Database Optimizer Module

Developed by Community developer
3
0
0
0
0

The average rating includes all reviews since the product launch.

(3 votes)
  • PrestaShop's
    Favorite
  • +100
    downloads!
  • PrestaShop
    1.6 - 1.7.6.1
module - Website Performance - Ultimate Database Optimizer - 1
module - Website Performance - Ultimate Database Optimizer - 2
module - Website Performance - Ultimate Database Optimizer - 3
module - Website Performance - Ultimate Database Optimizer - 4
module - Website Performance - Ultimate Database Optimizer - 5
module - Website Performance - Ultimate Database Optimizer - 6
module - Website Performance - Ultimate Database Optimizer - 7
module - Website Performance - Ultimate Database Optimizer - 8
See all screenshots (8)
Demo Front Office Demo Back Office

Overview

Module that optimizes, defragments and repairs the database. Monitor the status of the Database. Performs periodic maintenance.

What this product does for you

event_available

Productivity Improve your website security

The Ultimate Database Optimizer module for Prestashop is a powerful tool designed to optimize the Prestashop database, repair it, make backup copies, monitor its status and perform periodic maintenance to achieve maximum performance.
 
 The database of your store is a very delicate part of your business, where all the information of it is stored (catalog of products, content of the pages, clients, purchases, registers, etc...). Throughout the life of an online store, the database is in constant use: reading records, recording new records and deleting ones. These operations leave traces in the tables, fragmenting the information and appearing referential integrity errors. If no attention is paid and no measures are applied, the database will start to be unstable, slowing down all its operations and causing serious errors that will affect both the user's navigation on the web and the purchasing processes, records, etc...
 
Ultimate Database Optimizer has been developed as a total solution to all these problems. Becoming an essential module that every online store should have.
 
Another of the most innovative features is the integration of a complex algorithm to carry out tasks of constant monitoring of the database, notifying instantly of the state of the same, so that the user can know at all times when the situation is located. database and to be able to solve any problem from the same module with just one click.
A professional tool adapted for all user levels!
See more

Features

WHAT ULTIMATE DATABASE OPTIMIZER DOES...
 
 
CLEANING OF DYNAMIC TABLES
As time goes by, data are stored in the databases in the tables related to customer visits, statistics, connection data, etc ... So they keep daily records in the database . These registers are occupying space and slowing down the functioning of the database. This module allows periodic cleaning of these dynamic tables manually and/or automatically.
  It also has a warning function when the database tables contain an excessive number of records, as well as a heavy size.
 
DELETING ORDERS
By default in Prestashop, it is not possible to delete orders from the BO, so you have to resort to modules with this function added. The Ultimate Database Optimizer module has this function! It shows a table with the current orders and functions of search, filtering and ordering of the elements. It has a powerful deletion function that eliminates the orders selected in depth, eliminating all the traces left in the related tables (invoices, shopping carts, returns, etc...).
  With this deletion feature you can eliminate orders without leaving a trace in the database or creating conflicts of referential integrity.
 
SHOPPING CARTS DELETIONS
The table where the data of the shopping carts are stored, with time is usually filled with waste and records of abandoned shopping carts that do not matter with the passage of time. Therefore, in order to eliminate them, this module has a useful tool. It is possible to eliminate all the abandoned carts or limit the elimination by dates.
 
ELIMINATION OF SPECIFIC PRICES
When we configure the prices on offer for each of the products, we sometimes limit them with a date, so after that time, the specific price registration for the product is invalidated and saved in the database as waste. It is very important from time to time to clean these residues. With this module it is possible to do it, even by expiration date.
 
SECURITY BACKUPS OF THE DATABASE
The most important thing to save your store. With this module you have a section to administer the backup files of the database, make backup copies, restore them or download them in a compressed file to the computer. It has an option to automate the process of making backup copies through a CRON task and automatically every time any action is taken within the module.
You will never lose the most important data of your store. A daily backup automatically is the solution!
 
DELIVERY OF EMAILS
One of the most innovative features in this module is that you can automatically receive your email address or a group, a complete record of database activity, notification messages and warnings of the state of the database and sending the backup file of the database every time it is made.
Ultimate Database Optimizer will keep you informed instantly of everything that is happening to the database of your store.
 
ADVANCED UTILITIES
Ultimate Database Optimizer is also a very powerful tool with advanced utilities to configure the database with options that are not available in any other software.
  The following utilities are available:
  • Change of prefix of the database - Increasing the security against external attacks.
  • Changing the database engine - Choose between InnoDB and MyISAM, each with its characteristics.
  • Changing the file format of the database - Choose between Barracuda and Antelope. Increasing performance remarkably
  • Compression of database tables - Reduce the size up to 70%! and increase the performance.
All these advanced utilities are specially implemented to be able to increase the performance of the database, security and speed of operation. This translates into an online store 100% safe, without errors and fast.
A RAPID AND SAFE STORE INCREASES SEO BY IMPROVING WEB POSITIONING
 
REPAIR, OPTIMIZATION and DESFRAGMENTATION
The most common problems we face in Prestashop's MYSQL database are loss of data, waste in related tables, orphan records and fragmented data. Because of this the database becomes unstable and errors and anomalous behaviors begin to appear in the store.
The module has the ability to repair, optimize, defrag and clean the database easily, quickly and efficiently.
You will maintain your database in optimal conditions and avoid sales losses.
 
ADVANCED STATE MONITORING SYSTEM
This module is designed with a complex algorithm in charge of constantly monitoring the database in search of any anomaly. Detects the problem and reports in detail through a viewer of notifications and alerts. You will know at all times how the database is, and if there is a problem, it informs you in detail so you can solve it with the tools of the module.
  Through a status bar indicator, you can know the level of optimization that your Prestashop database has.
 
IMPROVED GRAPHIC INTERFACE
It has a fully optimized and OPTIMIZED graphic interface so you can navigate between the options of the module in the easiest and most intuitive way. It shows an information panel with all the relevant data of the database (version, engine of the tables, total number of tables, size of the database, etc...), and a status bar indicating percentage optimization .
 
OPTIMIZATION TURBO IN ONE CLICK
It has a button with the complete TURBO optimization function just by pressing it. So you do not have to worry about anything. Ultimate Database Optimizer, will do everything for you and will leave your database 100% optimized performing the necessary and necessary actions in each case.
PRESS THE BUTTON AND LET ULTIMATE DATABASE OPTIMIZE DO IT ALL FOR YOU.
 
PROGRAMMED TASKS
This is one of the most outstanding features of this module. We know that a user can not be constantly aware of the status of their database, for this reason this module implements the programmed task function so that all the actions can be carried out periodically with the desired frequency:
  • Checking and repairing database
  • Optimization and defragmentation
  • Database compression
  • Making backup copies
  • Repair of referential integrity issues
  • Change of database engine
  • Cleaning dynamic tables
  • Elimination of abandoned carts
  • Elimination of specific prices due
  • Sending emails with notifications and warnings of the state of the database
  • Sending emails with the backup copy of the database
 
LOG REGISTER
A complete record of all the activity of the module is available on the basis of data. You will have information on each of the actions taken in the database, so that you can know exactly, knowing the trail left by each action taken. 
 
COMPATIBLE WITH PRESTASHOP 1.6 AND 1.7
See more

Frequently bought together

Add "Ultimate Database Optimizer" to your cart along with:

  • Improving your site’s speed will get you a better score on major speed testing services such as Google PageSpeed, GTmetrix, YSlow, Pingdom, Webpagetest and will also improve your overall site’s usability.

    $4999

  • The most powerful Prestashop mega menu module 2019, awesome design, super easy-to-use, display perfectly on mobile devices, visual drag/drop backend, support both vertical & horizontal menu. Mega Menu PRO is the best Prestashop menu module ever!

    $5999
Total price: $6999 shopping_cart Add all three to cart

What your customers will like

Customers will enjoy an optimized store, fast and without failures in its database.

Recommendation

This module is designed to work correctly on 99% of the servers in the market. However, to avoid errors in operation or conflicts, it is recommended to have the following server requirements and parameter settings:
 
Recommended requirements
  • PHP version 5.4 or higher
  • MySQL 5 or higher
  • VPS Server or Dedicated (Shared hosting is also compatible)
  • Server with 1G RAM or higher
  • Access admin granted to the database
 
Recommended parameters
  • memory_limit = 512M or higher
  • max_input_vars = 10000 or higher
  • max_execution_time = 300 or higher

Support and updates

You automatically get 3 months of support for this product.

For 90 days after your purchase, you can enjoy technical and feature support, as well as access to updates available for this product.

Make sure this product runs well on your store for 12 months with Option Zen!

With Option Zen, you get access to ALL updates for the product for one year following purchase. Support from the product developer is available by email to answer all your technical and feature-related questions.

What is Option Zen?

Option Zen includes two services:

  • Unlimited after-sales support during the period covered by the option
  • Access to all updates for the product during the period

Option Zen is available at a discount when purchasing this product, but, if you miss out, you can also buy it via your customer account later. It is valid up to one year following the date of purchase of your product. The earlier you buy it, the longer you can enjoy it!

What does it include?

The following are included in Option Zen:

  • questions about using the module/theme;
  • solving technical problems related to the module/theme;
  • access to all module/theme updates.

The following services are not included in Option Zen:

  • customization and special development;
  • installing and updating the module/theme;
  • solving problems concerning third-party services, hosting, the server, or the PrestaShop software.
See more

Testimonials

I can recommend this module for these reasons: 1. After installing and applying the module functions, the store began to work much faster. 2. Author answer my requests very quickly. 3. There was problems after module installations but author fix problems very quickly. 4. Author explain all very clearly and in detail.

Viaceslav G. - 08/10/2018

excellent module

Corinne D. - 01/19/2018

Great Module! Measurable results, kind staff and fast reply.

Filippo C. - 07/09/2019

The reviews were selected by the developer of this product according to the satisfaction expressed by the customers.

Installation

Installation identical to any Prestashop module.

What's New in Version 1.0.8(07/16/2019)

  • [FIX] Issue with fragmented data in innoDB tables.
  • [ADD] Disallow to repair and optimize tables in myISAM format.

About the developer

Community developer

Question?
Need help?

This developer answers your questions in:
es en
  Contact the developer

Other items from the same developer

Anti-spam Protector

Anti-spam Protector

Protects against SPAM messages from the contact form (mail.ru, 163.com, 126.com, spam4.me ...) and registration. Includes Google reCpatcha and blacklist database of more than 52,000 domains and IP. Increase your web security.

$4999

SuperTinyMCE PRO - Professional text TinyMCE editor

SuperTinyMCE PRO - Professional text TinyMCE editor

Professional editor module with TinyMCE and many features, additional plugins and Bootstrap editor to build your catalogue of products and your CMS pages.

$5999

(38)
Combinations Table PRO

Combinations Table PRO

Displays a RESPONSIVE product combinations table on the product page and on the product listing page.

PrestaShop's
Favorite

$6999

(9)
See all products from this developer trending_flat

$7999

Benefits:

  • 3 months of free support (Learn more)
  • Developed by a Top Developer
  • Documentation included

  • Compatibility v1.6 - v1.7.6.1

  • Version 1.0.8 (07/16/2019)

  • Available in EN, ES

Questions? Contact the developer
This developer answers your questions in:

es en

The 3 reasons to buy on PrestaShop Addons Marketplace

  • Official

    Official

    10,000 modules, graphic themes and services

  • 100% trusted

    100% trusted

    Your purchases and personal data are 100% secure

    100% trusted
  • 1-click installation

    1-click installation

    The modules you bought appear directly in your back-office

Explore

Learn

Discover us

Contact us

© 2007-2019 PrestaShop SA.
Legal notices Terms and conditions Personal Data Protection Policy
Official