Hi alvaro, we are using an sqlite db to hold white/blacklists, we didn't measure performance impacts, but both of our lists has over thousand rules and works fine. We took some CustomFunctions from Mailwatch and tuned to work with sqlite instead of mysql.<br>
<br>Regards,<br><br>Eduardo.<br><br><div class="gmail_quote">2012/10/30 Alvaro Marin <span dir="ltr"><<a href="mailto:alvaro@hostalia.com" target="_blank">alvaro@hostalia.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hello,<br>
<br>
we've some rule files (whitelist, blacklist, checks...) and some days<br>
ago, I added new rules so some of those files have more than 25000 lines<br>
now.<br>
<br>
We have seen an important performance impact in MailScanner...Is there<br>
any "magic" solution to this?<br>
I've been reading about Ruleset-from-Function.pm, is anyone using it?<br>
<br>
Thanks!<br>
<br>
Regards,<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
Alvaro Marín Illera<br>
Hostalia Internet<br>
<a href="http://www.hostalia.com" target="_blank">www.hostalia.com</a><br>
<br>
--<br>
MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a><br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><br>
<br>
Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><br>
<br>
Support MailScanner development - buy the book off the website!<br>
</font></span></blockquote></div><br>