How to Optimize Database Using Page Cache PRO Module

Benefits of database optimization

Database optimization helps improve page loading times by cleaning up unnecessary data stored in your PrestaShop database. This feature focuses on removing data that is only used for statistical purposes and can be cleared if such statistics are not critical for your operations. By clearing this data, you free up space and enhance the efficiency of your store.

Configuration instructions

Step 1: From the module configuration page, navigate to the “Data optimization” page.

Step 2: The module provides a list of data types that can be deleted to free up space. The data types in the list include:

• Connections log: Records of every connection to your website (each visitor is a connection).
• Page views: Measures the total number of views a particular page has received.
• Useless discount codes: Expired discount codes.
• Abandoned carts: Online carts that customers added items to but exited without completing the purchase.
• Guest data: Information of unregistered users (excluding those with orders).

Step 3:

• You can click the "Download" button to download the desired data or the "Clear" button to delete the entire type of data from the database.
• Click "Clean all" to remove all listed types of data from the database.

By configuring the database optimization features in the Page Cache PRO module, you can significantly improve your PrestaShop store’s performance. Regularly clearing unnecessary data helps maintain a streamlined and efficient database, leading to faster page loading times and a better user experience.