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 >> seconds > to >> do a shutdown/make install/startup. I would believe you could get >> this > down >> 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 > (Rav >> antivirus) -- You get a 1min load spike of about 22-30 which goes away > within >> 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 >> are > up >> 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 > already >> written a very quick and dirty pop/imap server which just replied >> "yup, password good, no messages" to any query. >> >> Regards, >> Andrew >> >> > -- Benjamin Tomhave, Senior Systems Engineer [EMAIL PROTECTED] Sofast Communications www.sofast.net