Re: [Dspam-devel] Better purge.sql for MySQL

2009-12-19 Thread Stevan Bajić
On Sat, 19 Dec 2009 17:10:56 +0100 (CET) "Nicolas Grekas" wrote: > > Here I have to intercept. That 0.35 to 0.65 is not that easy to compute > > Ok, I read libdspam.c:_ds_calc_stat, not that easy :) > So we have to remove the related query and sql variable > Did that already and added this to t

Re: [Dspam-devel] Better purge.sql for MySQL

2009-12-19 Thread Stevan Bajić
On Sat, 19 Dec 2009 09:50:12 -0600 Kenneth Marshall wrote: > On Sat, Dec 19, 2009 at 03:28:01PM +0100, Stevan Baji?? wrote: > > On Sat, 19 Dec 2009 14:30:28 +0100 (CET) > > "Nicolas Grekas" wrote: > > > > > > I would do that differently. I would query the default (uid 0) > > > > > > You are ri

Re: [Dspam-devel] Better purge.sql for MySQL

2009-12-19 Thread Nicolas Grekas
> Here I have to intercept. That 0.35 to 0.65 is not that easy to compute Ok, I read libdspam.c:_ds_calc_stat, not that easy :) So we have to remove the related query and sql variable > Looking good IMHO. Need to quickly test it and then push it to GIT :) cool :) for postgre, sorry, I'm not your

Re: [Dspam-devel] Better purge.sql for MySQL

2009-12-19 Thread Kenneth Marshall
On Sat, Dec 19, 2009 at 03:28:01PM +0100, Stevan Baji?? wrote: > On Sat, 19 Dec 2009 14:30:28 +0100 (CET) > "Nicolas Grekas" wrote: > > > > I would do that differently. I would query the default (uid 0) > > > > You are right ! I've learnd that uid 0 is the default very recently > > and forgot to

Re: [Dspam-devel] Better purge.sql for MySQL

2009-12-19 Thread Stevan Bajić
On Sat, 19 Dec 2009 14:30:28 +0100 (CET) "Nicolas Grekas" wrote: > -- > -- Delete unused tokens, except for TOE, TUM and NOTRAIN modes > -- > START TRANSACTION; > DELETE LOW_PRIORITY QUICK > FROM t USING dspam_token_data t > LEFT JOIN dspam_preferences p ON p.preference = 'trainingMode' AND

Re: [Dspam-devel] Better purge.sql for MySQL

2009-12-19 Thread Stevan Bajić
On Sat, 19 Dec 2009 14:30:28 +0100 (CET) "Nicolas Grekas" wrote: > > I would do that differently. I would query the default (uid 0) > > You are right ! I've learnd that uid 0 is the default very recently > and forgot to take it into account > :) > > According to dspam.conf:[...] > > so, I've

Re: [Dspam-devel] Better purge.sql for MySQL

2009-12-19 Thread Nicolas Grekas
> I would do that differently. I would query the default (uid 0) You are right ! I've learnd that uid 0 is the default very recently and forgot to take it into account > According to dspam.conf:[...] so, I've taken your updated script, and crafted it to follow as close as possible what dspam_cle

Re: [Dspam-devel] Better purge.sql for MySQL

2009-12-17 Thread Stevan Bajić
On Thu, 17 Dec 2009 16:57:45 +0100 (CET) "Nicolas Grekas" wrote: > Hello, > Hallo Nicolas, > first of all, thank you for having permitted dspam to survive after some month > of inactivity ! > :) > I've just checked the latest source for purge-4.1.sql script, > and I think I have a better on