Thank you,

That's what I had in mind. Daly would be fine for me have a few thousands but nothing the machine cannot handle, machines are meant to work :p

Thank you all for the tips,

-----Original Message----- From: Reindl Harald [mailto:h.reindl@thelounge.net] Sent: 11 de dezembro de 2017 10:21 To: Roundcube Users mailing list users@lists.roundcube.net; Jorge Bastos mysql.jorge@decimal.pt Subject: Re: [RCU] Cron files

Am 11.12.2017 um 11:04 schrieb Jorge Bastos:

Hi Thomas,

Thank you, so i'll add gc and cleandb, whould this be running daily?

surely

if it would be destructive once per week bould be the same problem as per day and if a simple cleanup job onece per day is a performance problem you have bigger ones

-----Original Message----- From: users-bounces@lists.roundcube.net [mailto:users-bounces@lists.roundcube.net] On Behalf Of Thomas Bruederli Sent: 10 de dezembro de 2017 14:56 To: Roundcube Users mailing list users@lists.roundcube.net Subject: Re: [RCU] Cron files

On Thu, Dec 7, 2017 at 4:29 PM, Ulli Heist Ulli.Rainer.Heist@t-online.de wrote:

...

Hello,

sometimes I'm doing manuel:

$SQL = "SELECT * FROM contacts WHERE del = 1 AND DATE_ADD(changed,INTERVAL 45 DAY) < NOW() ";

...

We have bin/cleandb.sh in Roundcube that does exactly this ;-)

This and the already mentioned bin/gc.sh should do it for periodic clean-ups