Doubts about prestashop's database optimization module

 Module: Prestashop Database Optimization Pro Hello, good afternoon. I have several doubts about the module. 1. I would like to know how the scheduled deletion, in the case of abandoned carts. Are the carts deleted after being abandoned X days or are they all deleted at once X days? I am looking for a module that deletes abandoned carts every few days of inactivity, for example, after 30 days of abandonment the carts are automatically eliminated, leaving the others that do not exceed 30 days. 2. I also wanted to ask if cron tasks are individualized or do they work in a general way. 3. Finally, I would like to know how the deletion of the files works. Let me explain: I am using the free version and when I delete a table the rows are deleted. However, if I enter my database it still thinks the same. The rows are deleted but the file size is the same. On the other hand, if I do it manually "truncate" rows and the file size are deleted. Can you help me in all these questions? I would like to buy the module if it fits these characteristics. Thanks.


Hello,
below you can find answers for your questions about "database optimization pro" module:
  1. Carts are deleted after being abandoned X days. As a shop admin you can define "days" value: 

    So, in context of your question - if you will type there "30" module will remove carts that were created 30 days ago and more Carts created 1-29 days ago will not be deleted.

  2. All you have to do is to execute the url that module genreates: https://i.imgur.com/LTSyPQU.png 
    For this module it's enough to run cron task one time per day
  3. Mysql database file (ibdata) does not change its size when you remove entries from database tables.
    Ibdata file size will be the same, even if you will truncate all tables. This is not an issue, but its a way of how mysql database works. (this is also the way of how mariadb etc. works)

best regards
milos
Share on Google Plus

About VEKIA

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.
    Blogger Comment

1 comments:

  1. I uninstalled the databaze optimization from the shop. I could never get agin into the back office. PS1.7.8 version. I had to retrieve from archive and now just disabled, but cannot be uninstalled. Very bad experience with this module.

    ReplyDelete