Re: Vertical partitioning
You can split your table on two ones and join them with a view by a primary key, I heard that people use two tables in INNODB, for example, for separating BLOBS which is not frequently accessed. As far as view is really simple it will cost just as usual join operation for select. the only problem is insert/update where you will not be able to insert and update rows of both tables simultaniously via the view and you can't delete from such view.
Mr. Oleksandr Byelkin
MySQL AB, Full-Time Developer
Lugansk, Ukraine
Subject
Views
Written By
Posted
9547
November 07, 2005 05:44PM
4026
November 19, 2005 05:02AM
4097
November 30, 2005 03:30PM
3914
January 12, 2006 06:57AM
Re: Vertical partitioning
3791
January 12, 2006 08:55AM
3445
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.