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
>>(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.


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!


Reply via email to