[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