This guide helps to solve a problem on the CMS Prestashop and more specifically with its module “Faceted search” which allows the management of filters in product category pages.

The problem

The 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.

The solutions

The first solution is to disable the proposed caching. If you have a cache module, such as for example Ultimate Cache, there will be no negative impact. To do this, from the module settings, deactivate the button on this subject:

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

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 in question, for example 1 time per day and per night.