Jo, > And I'm wondering what value the mailaddr > table brings. I don't see any.
It is generally cleaner to keep potentially recurring data in one copy and just link to it from wherever it is needed, than have duplicates. Provided this doesn't cost too much overhead. > >> The size of repeated data isn't large enough to cause a > >> problem, That is probably true for many sites. > >> and dropping the join improves performance on both mysql and > >> postgres even with the larger tables. Probably it does, but by how much? > >> I used 100k and 1mil table sizes for my example with 100 entries > >> per address, and it still came out faster. > > How many entries are there normally in SQL based w/b lists? > My personal machine has 1k recipients, and this table is only ~280 > entries. > > > Does a lookup take more than a few milliseconds? > > On my machine, or in the tests? The larger tests obviously take > longer. Without the join, however, it was always < 1sec no matter > how big the table was. I mean the 'spam-wb-list:' entry in the TIMING report (at log level 2). At our host it takes about 4..7 ms (but the number of SQL records is small; the timing entry includes a static wblist lookup). Speeding it by an additional millisecond or two makes no difference. > Most whitelist entries I have seen appear to be financial-services > mailing lists. (thus no two-way traffic) No, I don't know why those > are getting high scores. Need to chat with the users. These need to be whitelisted with SpamAssasin rules to be reliable. For ebay, paypal, bankofamerica, etc use whitelist_from_dkim, for others either whitelist_from_spf or whitelist_from_rcvd, or a dedicated rule. Whitelisting solely based on envelope or author (From) mail address commonly leads to false negatives, the popular financial and similar sending domains are frequently abused for fraud. > No, I don't know why those are getting high scores. > Need to chat with the users. It pays off to investigate such false positives. If a company policy and legislation allows it, the use of quarantining can be a big help there. Message above kill level may still be passed on to recipient if desired, but a copy is saved in quarantine for investigation. Mark ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ 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/
