why is row mode update suitable for realtime and c...
# questions-and-troubleshooting
r
why is row mode update suitable for realtime and column mode suitable for batch updates?
k
The “row mode” approach prioritizes low-latency, high-QPS individual writes by minimizing the amount of data that needs to be rewritten per transaction; the “column mode” approach prioritizes high write throughput and maintaining optimal read performance for analytical queries, accepting high write amplification as a trade-off that is managed by batching and background compaction.