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:[email protected]] Sent: 11 de dezembro de 2017 10:21 To: Roundcube Users mailing list <[email protected]>; Jorge Bastos <[email protected]> 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: [email protected] > [mailto:[email protected]] On Behalf Of Thomas > Bruederli > Sent: 10 de dezembro de 2017 14:56 > To: Roundcube Users mailing list <[email protected]> > Subject: Re: [RCU] Cron files > > On Thu, Dec 7, 2017 at 4:29 PM, Ulli Heist > <[email protected]> > 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 _______________________________________________ Roundcube Users mailing list [email protected] http://lists.roundcube.net/mailman/listinfo/users
