Rows vs. Columns: How different are they, really?
Comments
Ranked by a public rubric, not by votes: what a comment adds counts, not who wrote it. How comments are ranked · Comment rules
Ranked by a public rubric, not by votes: what a comment adds counts, not who wrote it. How comments are ranked · Comment rules
Summary
Connor Tsui's SpiralDB blog post explains the physical difference between row and column storage: rows keep each record's fields together, suiting transactional apps, while columns keep each field's values together, letting analytics read only the needed columns.