Ok, I started it, I wish to kill it. All points well made, though a bit
ruder than necessary. I'll compile against a hostname that is configured
into /etc/hosts and life will be grand. Thank you. BTW, I'm disappointed
nobody compared file read for looking up a sql server vs. file read for
looking up hostname. Can't imagine that would be much different, and thus
doesn't really gain you much in performance. Just a thought. Again,
thank you for the responses.
> Hi Andrew !!
> I guess You did not read the whole story :-)
> It's not about shutting down deliveries.
> It's not even about compiling vpopmail...
> It's a comparison of having a vpopmail SQL configfile
> vs. compiled in SQL config (vmysql.h)
> Please read the story, I'm tired... bye...
>> ---- Original Message -----
>> Date: 15-Feb-2003 05:00:47 +0100
>> From: Andrew Kohlsmith <[EMAIL PROTECTED]>
>> To: <[EMAIL PROTECTED]>
>> Subject: Re: [vchkpw] switching database servers
>> > 5 min * 60 sec/min = 300 sec
>> > 300 sec / .02 sec/delivery = 15000 deliveries
>> Why on earth would you shut down delivery for the compile?
>> time to make install: 30 seconds
>> 30 sec / .02 sec/delivery = 1500 deliveries
>> that's one order of magnitude, assuming that you need the full 30
>> do a shutdown/make install/startup. I would believe you could get
>> by another order of magnitude with a simple script -- making your
>> total deliveries on the order of 150-250.
>> Speaking from experience on a mid-volume mail server (about a thousand
>> deliveries per hour) -- qmail compensates perfectly. In my case I'm
>> also running every message though spamc and procmail *and* an
>> antivirus scan
>> antivirus) -- You get a 1min load spike of about 22-30 which goes away
>> a minute and you're back down to normal levels.
>> > What about all POP/IMAP connections ?
>> > Many users gets maybe less than 10 emails a day but they
>> > do POP their mailbox every 5 (or less) minutes !!!
>> You schedule it during a normal maintenance window. Not many people
>> and about at 4am. And also speaking from experience, people will get
>> an error, go "hmm" and try again. By that time you're back up and
>> nothing happens.
>> And if you really needed to look like you were always up, you'd have
>> written a very quick and dirty pop/imap server which just replied
>> "yup, password good, no messages" to any query.
Benjamin Tomhave, Senior Systems Engineer
Sofast Communications www.sofast.net