[vchkpw] Re: disable-many-domains - enable-many-domains
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. I'm currently busy with something else but I'll post it as soon as it 'll be done. In the meantime, if someone has done it, he could post it there ;-) Many thanks for your answers Thibault !DSPAM:4bf3f79632711288013922!
[vchkpw] Re: disable-many-domains - enable-many-domains
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? 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 -- -Eric 'shubes' !DSPAM:4be97d5b32714726992539!
Re: [vchkpw] Re: disable-many-domains - enable-many-domains
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...@zioniInterazioni di Antonio Nati http://www.interazioni.it to...@interazioni.it !DSPAM:4be97ed332711506113019!