-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 How'd you do this? I though the sql database was only for user prefs? I'm interested in using an sql database to track my spam effectiveness as well.
- --j2AXaZ4YhVcLc+PQ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Since I'm having another night of not being able to sleep, I naturally started pondering how effective the spam blocking I've been doing has been. Over the past week or so (actually since 2002-10-21 00:00:00), here's what I've found: # total verified spams mysql> select COUNT(*) from reported where date >=3D '2002-10-21'; | 431 | # total verified spams with RAZOR2_CHECK rule hit mysql> select COUNT(*) from reported where date >=3D '2002-10-21' and mysql> rules= like '%RAZOR2_CHECK%'; | 303 | # total verified spams with SA score >=3D 5 mysql> select COUNT(*) from reported where date >=3D '2002-10-21' and mysql> value= >=3D 5; | 423 | So overall: mysql> select 303/431,423/431; +---------+---------+ | 303/431 | 423/431 | +---------+---------+ | 0.70 | 0.98 | +---------+---------+ :) and because I can hear you asking, no, the 8 spams that weren't caught by SA were also not caught by Razor, but 6 spams were caught because of Razor: mysql> select COUNT(*) from reported where date >=3D '2002-10-21' and value < 5 and rules like '%RAZOR2_CHECK%'; | 0 | mysql> select COUNT(*) from reported where date >=3D '2002-10-21' and value < 8.91 and rules like "%RAZOR2_CHECK%"; | 6 | ........................................... Randomly Generated Quote: One great thing about cats - they don't bark. Mike Loiterman PGP Key 0xD1B9D18E http://www.ascendency.net -----BEGIN PGP SIGNATURE----- Version: PGP 7.0.4 Comment: Message digitally signed by Mike Loiterman iQA/AwUBPb7wR2jZbUnRudGOEQIizACfRHEwu/UT3lNh5u59E8jq0x//wxYAoMjt oEeihwG0qiAQPuc1JSnIgqKD =mo62 -----END PGP SIGNATURE----- ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk