V1.7 Ultimate Database Optimizer - Optimizes and repairs v 3.1.0

Phenotype

Member
XNullUser
Joined
Oct 19, 2021
Messages
438
Reaction score
3
Points
18
NullCash
30
Very nive very nice, thanks for sharing! Has anyone tried working this with 8.0 version of prestashop?
 

Voodens

Active member
XNullUser
Joined
Jun 1, 2021
Messages
580
Reaction score
98
Points
28
NullCash
34
Thank you very much for upload! :D Downloaded it!
 

moleco

Well-known member
Diamond
Elite
Joined
Jan 8, 2019
Messages
328
Reaction score
380
Points
63
NullCash
96
Thank you very much! It can be useful module!
 

kiwi

New member
XNullUser
Joined
Jun 22, 2022
Messages
24
Reaction score
8
Points
3
NullCash
11
Thank you very much for sharing this awesome module :)
 

Rhyn67

Member
XNullUser
Joined
Jul 3, 2022
Messages
69
Reaction score
0
Points
6
NullCash
6
thanks for sharing, really good module to use !!!!
 

ced#

Member
XNullUser
Joined
Jun 1, 2023
Messages
45
Reaction score
3
Points
8
Location
France
NullCash
63
Tank you thi is the best module to optimize prestshop database. Over the top
 

Seyfigsm

Member
XNullUser
Joined
Jun 13, 2022
Messages
35
Reaction score
0
Points
6
NullCash
19
Tank you thi is the best module to optimize prestshop database. Over the top
 

dynia

Member
XNullUser
Joined
Jun 11, 2021
Messages
70
Reaction score
0
Points
6
NullCash
9
I hope it will speed up the page, but let's test it and then see !
 

FloverLion

Active member
Elite
XNullUser
Joined
Sep 30, 2022
Messages
632
Reaction score
215
Points
43
NullCash
323
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
directions_car Speed up your website
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
can you share new one v3.1.3 version plz
SOME COMMON PROBLEMS AND ERRORS THAT THIS MODULE REPAIRS
  • Fixes the error of showing price 0 in the list of products when the product has combinations.
  • Fixes the error that some orders disappear in the "Orders" table of the back-office orders section.
  • Fixes the error of the action "Order again" that shows the empty cart to proceed with the purchase.
  • Fixes speed problems in the Back-office and Front-Office related to the status of the Database.
  • Fixes problems of duplicate and erroneous values in the Back-office configuration

3.1.3 plz.​

 

Expertone

Member
XNullUser
Joined
Nov 15, 2022
Messages
192
Reaction score
6
Points
18
Location
italy
NullCash
284
recent version is out, can you update? thanks:

Version 3.1.3 - 4/14/2023​

Minor
PrestaShop compatibility: 1.6.0.4 - 8.0.4
  • [FIX] Minor BUGS.
  • [FIX] Bug in search filter from log table.
  • [IMP] Performance executing some optimization and repair tools.
  • [IMP] Check table errors process avoiding check tables with more than 1.000.000 records to avoid get stuck the process.
  • [IMP] Deep scan process.
  • [IMP] One Clic Optimization tool.
  • [NEW] Option to remove orders from deleted customers.
 
Top