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
