Peter Palmreuther wrote: > Hello Billy, > > On Saturday, July 2, 2005 at 6:32:47 PM Billy wrote: > > >>>N.B.: Number of authentication should not play a role in accessing >>>your cdb-file, if you're configured vpopmail to only use MySQL the cdb >>>will be as static as your kernel: unless *you* change it, it won't >>>change. > > >>(I'm going by memory, so this is a paraphrase.) > > >>If you aren't familiar with the Matt Simerson mysql patch, it was born >>because there can be major lookup problems with the cdb file, especially >>using POP before SMTP. > > > Have tested it a long time ago and know why it was developed, albeit I > don't actively use it. > > >>Mysql has no problem with the above scenario, as it is designed for >>heavy accesses and changes to its tables. > > > Absolutely right. > > But: what's the matter with 'POP-before-SMTP done through MySQL' and > additionally using a .cdb-file for static entries? > Does the patch nevertheless a MySQL-lookup, even if something is found > in .cdb-file? In this case a .cdb-file in fact wouldn't make much > sense, except the fact the answer from MySQL could kept short (no > result) and some parsing time could be spared.
Well, I had to look up the stuff myself. I'm not completely positive, but it looks like you can still use -x and the (Matt Simerson hack) -S, too. See http://www.tnpi.biz/internet/mail/toaster/patches/tcpserver-mysql.shtml I use a lot of Matt's stuff, but as you can see, this hack is for the big leagues. (I just looked at my service "run" files, which are automatically generated. No -S, just -x /usr/local/vpopmail/etc/tcp.smtp.cdb -- I don't do pop-before-smtp) But using both, you do two reads per SMTP access. Only consider that if the cdb file is static, that small of a file will be resident in your memory cache almost assuradly. I think you are splitting hairs, until you get a 10,000+ user system and benchmark it. You will need to see the source hack to see what is done, when, and how, or benchmark it. Or ask Matt! Billy