On Monday 07 June 2004 02:22 pm, Jeremy Kitchen wrote: > > As an ex-database admin, I wrote the many-domains=no option as > > an optimization to the database schema to save disk space. > > > > Consider hosting one domain with 1 million email accounts. > > The pw_domain(64 char) field is redundant (only one domain). So > > we would be wasting 64MB of space in the database. So instead > > the table is named after the domain. > > I was about to ask you this but you ran off before I could.. so I'll just > post for discussion purposes. > > Isn't this what the varchar field is for?
or rather, field TYPE. -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail