This guide helps to solve a problem with the PrestaShop CMS and more specifically with its “Faceted Search” module, which manages filters on product category pages.

The problem

This specific PrestaShop search module creates a cache in the database to speed up the search. However, the corresponding table is never cleaned, which poses a problem for the hosting infrastructure.

First solution

The first solution is to disable the proposed caching.

To do this:

1. In the PrestaShop administration panel, go to Modules → Module Manager.
2. Select Modules and use the search field to find “facet”.
3. Click on Configure next to the module obtained in the result:
   
4. Disable the button for this:
   

Second solution

The second solution is to set up a cron job to clean the table, for example every night:

1. From the module settings, copy the existing URL on the Clear cache button:
   

Then, from the Infomaniak Manager, create a webcron (refer to this other guide on this subject) to execute the URL copied in step 1 above, for example once a day and night.