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:
http://mikaelronstrom.blogspot.com