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
_________________________________________________________________________
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
