Eric Shubert ha scritto:
Thibault Richard wrote:
Hello,
I'm using vpopmail since a few years with the compilation option
"--disable-many-domains" (for historical reason because I followed
Qmailrocks guide for my first installation).
If I've well understand, one one the difference between those
compilation option is the MySQL table structure (if the option
--enable-auth-module=mysql is used).
Could someone confirm that ? If I'm wrong, could someone tell me what
are the option to use "one table per domain" or "one table for every
domain"
I'm pretty sure this is correct.
--disable-many-domains = one table for each domain
--enable-many-domains = one table for all domains
One table for all domains seems to be a better database design. OTOH,
can someone explain the reasons why one table for each domain
(--disable-many-domains) might be a better choice?
If you have one or a few huge domains with hundreds of thousands of
accounts (or you are gmail/hotmail/yahoo), you save space, as you don't
have the domain field repeated for each record.
If you have a normal installation, if has no sense.
Ciao,
Tonino
Is there a MySQL script to convert the table structure between the
two options ?
Not that I'm aware of, but I expect it would be fairly simple. I know
of someone else who might be interested in this as well.
Thank you
Thibault
--
------------------------------------------------------------
in...@zioni Interazioni di Antonio Nati
http://www.interazioni.it to...@interazioni.it
------------------------------------------------------------
!DSPAM:4be97ed332711506113019!