On Tuesday 02 June 2009, Michael Scheidell wrote: > > I have been using the AWL ( --add-addr-to-blacklist ) for some time, to > > bump new spam senders above the "Bayes-99" score. > > > > My problem is that this feature seems, extreemly slow. > > > > I'm now trying to use the "( --add-to-blacklist )" option and am finding > > that this is, equally, slow. > > > > I'm running it as: > > spamassassin -d --progress --add-to-blacklist --mbox <mboxfile> > > > > The <mboxfile> contains the messages whose senders I wish to blacklist, > > via AWL. > > > > The process seems to take anywhere from 5 to 15 minutes, per address. > > Most likely, you are still using the flat file (db2 , 3 or 4). If you > convert to MYSQL based file, and add in some of the optional fields and > trim it weekly, it should be faster
Yes, I am still using the Flat file (default) DB. I have been toying with setting it up in MySQL, but have not bitten that bullet yet. What "optional" fields are you refering to? I have seen this, on the spamassassin WIKI: CREATE TABLE awl ( username varchar(100) NOT NULL default '', email varchar(200) NOT NULL default '', ip varchar(10) NOT NULL default '', count int(11) default '0', totscore float default '0', PRIMARY KEY (username,email,ip) ) TYPE=MyISAM; Is there a better reference? -- Larry G. Starr - lar...@fullcompass.com or sta...@globaldialog.com Software Engineer: Full Compass Systems LTD. Phone: 608-831-7330 x 1347 FAX: 608-831-6330 =================================================================== There are only three sports: bullfighting, mountaineering and motor racing, all the rest are merely games! - Ernest Hemmingway
