Re: SOCKETMAP performace (was Re: [Mimedefang] sendmail 8.13.0)

2004-07-29 Thread Mark
David F. Skoll wrote: I expect that if you use a SQL backend, then keeping a persistent connection inside MIMEDefang would be a big win compared to opening a SQL database connection each time sendmail forks. Thanks for the work, David. :) Question, though, how will you keep a persistent,

Re: SOCKETMAP performace (was Re: [Mimedefang] sendmail 8.13.0)

2004-07-29 Thread David F. Skoll
On Thu, 29 Jul 2004, Mark wrote: Question, though, how will you keep a persistent, say, MySQL connection in Perl, for the backend socketmap functionality? Keep a global variable called $DBH. Write code like this: # Put this at the top of your filter undef $DBH; sub get_dbh { # Re-use if

RE: SOCKETMAP performace (was Re: [Mimedefang] sendmail 8.13.0)

2004-07-29 Thread Matthew.van.Eerde
From: Mark [mailto:[EMAIL PROTECTED] David F. Skoll wrote: Question, though, how will you keep a persistent, say, MySQL connection in Perl, for the backend socketmap functionality? Keep a global variable called $DBH. Write code like this: # Put this at the top of your filter

Re: SOCKETMAP performace (was Re: [Mimedefang] sendmail 8.13.0)

2004-06-22 Thread Lucas Albers
Martin Blapp said: We don't use LDAP but have mysql as backend. First we had mysql support directly in sendmail to check the recipient adresses. After we moved everything to mimedefangs check_recipient(), the mysqld cpu usage dropped from 5%-10% down Could you post information on your