The following issue has been CLOSED ====================================================================== http://www.dbmail.org/mantis/view.php?id=5 ====================================================================== Reported By: Dead2 Assigned To: ====================================================================== Project: DBMail Issue ID: 5 Category: Database layer Reproducibility: always Severity: tweak Priority: normal Status: closed Resolution: open Fixed in Version: ====================================================================== Date Submitted: 09-Jul-04 11:55 CEST Last Modified: 08-Feb-06 07:56 CET ====================================================================== Summary: Forwarding should be improved Description: In the database, the aliases->deliver_to is stored as varchar(250) to store who the mail should be delivered to. This can be very non-optimal when the aliases table becomes BIG.
Today it can contain both user_id's and email addresses for forwarding. I suggest that we change this parameter to an integer type. Then implement forwarding with a separate field using a deliver_to id of -1 to tell code to look for at the forward_to field. This would increase efficency when searching for aliases with a specific id (ex: webmail) since it can be indexed as integer. It will also improve logic since forward_to is a separate field. ====================================================================== ---------------------------------------------------------------------- aaron - 08-Feb-06 07:56 ---------------------------------------------------------------------- http://www.dbmail.org/dokuwiki/doku.php?id=split_deliver_field Issue History Date Modified Username Field Change ====================================================================== 09-Jul-04 11:55 Dead2 New Issue 09-Jul-04 14:12 ilja Status new => acknowledged 17-May-05 18:08 michaelg Issue Monitored: michaelg 08-Feb-06 07:56 aaron Status acknowledged => closed 08-Feb-06 07:56 aaron Note Added: 0000993 ======================================================================
