[Workaround.org] ISPmail for Squeeze?!

Christoph Haas email at christoph-haas.de
Tue Jan 25 22:27:16 CET 2011


Am Dienstag, den 25.01.2011, 14:33 +0000 schrieb Emmanuel Revah:
>  CREATE VIEW view_aliases AS
>  SELECT virtual_aliases.id, domain_id, source, name, CONCAT(source, '@', 
>  name) AS email, destination
>  FROM virtual_aliases
>  LEFT JOIN virtual_domains ON (virtual_aliases.domain_id = 
>  virtual_domains.id);

The problems with the old database schema were:

1. CONCAT(…)
   This lead to a view with string operations which scaled very badly
   on large installations.

2. JOIN…
   Same problem. The JOIN makes it less efficient (although more
   normalized) and this adds to the scalability issue.

You will not notice that at home or on a small server with 10 domains
and 500 accounts. But I have received feedback that it was a major
performance penalty from larger installations.

Cheers
 Christoph




More information about the Workaround-chitchat mailing list