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(a)lists.roundcube.net>; Jorge Bastos
<mysql.jorge(a)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(a)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(a)lists.roundcube.net>
> Subject: Re: [RCU] Cron files
>
> On Thu, Dec 7, 2017 at 4:29 PM, Ulli Heist
> <Ulli.Rainer.Heist(a)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