Re: webmail user mailbox schema design?
Date: Fri, 1 May 2009 12:49:29 -0700 (PDT)
On May 1, 1:15 pm, Bob Badour <bbad..._at_pei.sympatico.ca> wrote:
> Tegiri Nenashi wrote:
> > On May 1, 9:37 am, ddf <orat..._at_msn.com> wrote:
> >>Partitioning the MESSAGES table on user_id could provide speed and
> >>manageability by segregating each users messages to a single
> >>partition; partition pruning would eliminate visits to unrelated
> >>partitions effectively reducing the data set to a fraction of the
> >>total number of messages stored.
> > I struggle to understand a single advantage of partitioning. Well, you
> > listed one advantage -- easy deletion. However, since when deletion
> > became a determining factor in database design?
> What's even more striking and even harder to understand is someone
> suggesting highly detailed, very explicit physical implementation
> details on the basis of the sketchiest of problem statements.
> I am sure you would agree: Anyone doing so has no idea what they are
> talking about.
I fail to see the 'highly detailed' nature of my response. Please post the text from that offering where my thought became an explicit method. Include the DDL I supplied as well.
David Fitzjarrell Received on Fri May 01 2009 - 21:49:29 CEST