MySQL Forums
Forum List  »  Partitioning

Re: Vertical partitioning
Posted by: Mikael Ronström
Date: November 30, 2005 03:30PM

Peter Volk wrote:
> Hi All,
> are there any thoughts on doing vertical instead
> of horizontal partitioning? We've had a system
> that had extreme performance problems because the
> table was extremly wide but single queries only
> accsest a smal subset of columns of the whole
> table. when we switched to a system that did
> vertical partitioning we had an extreme increase
> of performance. Have there been eny toughts on
> doing a partitioning also vertically?

Sounds to me like a good fit for a VIEW. It has some limitations but the
problem you discuss sounds like a perfect fit. And VIEW's are in 5.0 so
you can go ahead and try it out immediately.

Rgrds Mikael

> Thanks,
> Peter

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:

Options: ReplyQuote

Written By
November 07, 2005 05:44PM
November 19, 2005 05:02AM
Re: Vertical partitioning
November 30, 2005 03:30PM
January 12, 2006 06:57AM
January 12, 2006 08:55AM
February 01, 2006 05:47AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.