Eric Shubert ha scritto:
Thibault Richard wrote:

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.



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


in...@zioni Interazioni di Antonio Nati ------------------------------------------------------------


Reply via email to