Svyatoslav Trukhanov wrote:
>
> I have large mail system, use qmail+vpopmail+MySQL
>
> All is Ok, but
> when new mail for user arrived vdelivermail connect to MySQL and get home
> dir
> for this user. I think this is bottleneck on my system. (MySQL located not
> on the same machine, when mailboxes).
>
> I think maybe this features will be usefull:
>
> 1. User homedir calculated from its name (example user [EMAIL PROTECTED] -
> homedir ~vpopmail/domains/aaa.com/s/l/a/slavik). If there is now dir with
> this name than vdelivermail connect to MySQL and check user and create dir
> or bounce mail.
This does not produce a balenced directory tree.
>
> 2. Quita saved not in MySQL but in homedir for same reasons.
interesting.
>
> What you say about this things?
I think it's better to build a good design, than to code around
possible bottlenecks.
If the problem is slow access to mysql, then the solution is to
speed up mysql connections. The easiest way is with a mysql
caching deamon.
Ken Jones
