I was looking at the sql commands used to expire bayes data and noticed
some indexes that combined 'id' with token and atime.
(two indexes, on bayes_token)
and noticed id also on bayes_vars.
i tried to see what the 'id' value was used for, since every row in both
tables had id=1.
select count(*) from bayes_token where id !=1;
and
select count(*) from bayes_vars where id != 1;
Both come back '0'?
is this for multi-user bayes ? anyone using amavisd-new know if there
is any real reason not to eliminate the id based keys and reindex on
atime and token seperatly?
wouldn't that make sa-learn --force-expire faster? make writes (updates)
to bayes table faster with one less combination key? (two less on
bayes_token)?
--
Michael Scheidell, CTO
Main: 561-999-5000, Office: 561-939-7259
> *| *SECNAP Network Security Corporation
* Certified SNORT Integrator
* Everything Channel Hot Product of 2008
* Shaping Information Security Award 2008
* CRN Magazine Top 40 Emerging Security Vendors
_________________________________________________________________________
This email has been scanned and certified safe by SpammerTrap(r).
For Information please see http://www.spammertrap.com
_________________________________________________________________________