Hans Kristian Rosbach wrote:
Hi, while makeing my webmail application I
noticed a potential slowness.
In the database, the aliases->deliver_to
is stored as varchar(250) but only contains
integers (user ids) to whom it should be
delivered to. This can be very non-optimal
when the aliases table becomes BIG.
I assume the reason for this is that it is
possible to use this field for forwarding
the mail to an external address? Is this
implemented code-wise at all?
Yes, this is implemented and works like you suggested above. It can also
be used for
"chaining aliases" and mail groups:
alias deliver_to
[EMAIL PROTECTED] [EMAIL PROTECTED]
[EMAIL PROTECTED] [EMAIL PROTECTED]
[EMAIL PROTECTED] [EMAIL PROTECTED]
[EMAIL PROTECTED] 1
[EMAIL PROTECTED] 2
[EMAIL PROTECTED] [EMAIL PROTECTED]
this way, a message to [EMAIL PROTECTED] will eventually be delivered to
users 1 & 2, and be forwarded to [EMAIL PROTECTED] if that domain is
not handled by this dbmail-instance.
If not then I suggest that we change this
parameter to an integer type. Then we can
implement forwarding with a separate field
in 2.1 using a deliver_to id of -1 or
something to tell code to look for at the
forward_to field.
If it is already implemented then I suggest
we separate them in 2.1.
It might be a good idea to do this. It would also be cleaner than the
current way of doing things.
Anyway.. it's not something for the short term. Please file it as a
feature/bug in the bug tracker.
Ilja
--
Ilja Booij
IC&S B.V.
Stadhouderslaan 57
3583 JD Utrecht
www.ic-s.nl
T algemeen: 030 6355730
T direct: 030 6355739
F: 030 6355731
E: [EMAIL PROTECTED]
