All geek questions in one place

What are the benefits of vertically splitting VS into horizontal splitting?

I just can’t understand when and in what situation we will choose vertical split instead of horizontal split.

What are the benefits of VS vertical splitting to horizontal splitting?

Are there examples of websites / companies / those using vertical partitioning and what is / will be the main reason for this decision?

+6
source share
2 answers

The main reason for having a vertical section is when there are columns in the table that are updated more often than the rest. You separate them in another table / section, and when you perform updates, you do not update the rest of the table. An example is a message counter. If it is in the same table as other user data, each counter update (and there are many) blocks the entire record, but you need to read it often. In the vertical split, the updated table will be user_counters, and user performance will not be affected by the number of updates.

+9
source

I completely agree with what Darhazer said. “An example of vertical splitting can be a table that contains several very wide text or BLOB columns that are not considered, often split into two tables, in which the columns with the highest degree of binding in one table and rarely referenced text or BLOB data in another . How said in this link: http://dev.mysql.com/tech-resources/articles/partitioning.html

0
source

Source: https://habr.com/ru/post/892603/

More articles:


All Articles