MySQL Forums
Forum List  »  Partitioning

Re: Vertical partitioning
Posted by: Oleksandr Byelkin
Date: January 12, 2006 08:55AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
9056
November 07, 2005 05:44PM
3758
November 19, 2005 05:02AM
3768
November 30, 2005 03:30PM
3638
January 12, 2006 06:57AM
Re: Vertical partitioning
3497
January 12, 2006 08:55AM
3268
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.