BestHub
Sign in
Tagged articles
8 articles
Page 1 of 1
Big Data Technology & Architecture
Big Data Technology & Architecture
Jul 3, 2024 · Databases

Optimizing High-Concurrency Point Queries in Doris with Row Store, Short Query Path, and PreparedStatement

This guide explains how to enable row store, configure short query path, and use PreparedStatement in Doris to reduce I/O and CPU overhead for high‑concurrency primary‑key point queries, including DDL examples, JDBC usage, row cache settings, performance tips, and verification methods.

PreparedStatementRow StoreSQL
0 likes · 9 min read
Optimizing High-Concurrency Point Queries in Doris with Row Store, Short Query Path, and PreparedStatement
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 22, 2023 · Databases

Apache Doris 2.0 New Features: High‑Concurrency Data Serving Optimizations

Apache Doris 2.0 introduces a suite of high‑concurrency data‑serving enhancements—including row‑store format, partition‑bucket pruning, advanced indexing, materialized views, runtime filters, TOPN optimization, short‑circuit point‑query paths, prepared statements, and row cache—enabling single‑node tens of thousands QPS and dramatically reducing query latency.

Apache DorisBenchmarkData Serving
0 likes · 23 min read
Apache Doris 2.0 New Features: High‑Concurrency Data Serving Optimizations
StarRocks
StarRocks
Nov 8, 2022 · Databases

How StarRocks’ Real‑Time Storage Engine Evolves to Meet Modern Analytics Demands

This article outlines the evolution of StarRocks’ storage engine—from its real‑time update capabilities and primary‑key model challenges to recent optimizations like persistent indexes, partial column updates, conditional updates, high‑frequency import improvements, DML support, and future plans for separating primary and sort keys, introducing row‑store, and enhancing materialized view support.

DMLReal-time analyticsRow Store
0 likes · 18 min read
How StarRocks’ Real‑Time Storage Engine Evolves to Meet Modern Analytics Demands
Top Architect
Top Architect
Aug 3, 2022 · Databases

Row Store vs Column Store in openGauss: Comparison, Advantages, Disadvantages and Experimental Evaluation

This article explains the fundamental differences between row‑based and column‑based storage in relational databases, compares their performance for writes, reads, compression and use cases, presents an openGauss experiment with sample tables and SQL commands, and offers practical guidance on when to choose each storage model.

Column StoreDatabase StorageRow Store
0 likes · 10 min read
Row Store vs Column Store in openGauss: Comparison, Advantages, Disadvantages and Experimental Evaluation
IT Architects Alliance
IT Architects Alliance
Jul 28, 2022 · Databases

Row vs. Column Store: When to Use Each and Why?

This article compares row‑based and column‑based storage models, analyzes their write and read performance, presents a practical openGauss experiment showing size and insert‑time differences, and offers concrete guidance on selecting the appropriate storage type for various workloads.

Column StoreDatabase StorageRow Store
0 likes · 10 min read
Row vs. Column Store: When to Use Each and Why?
Top Architect
Top Architect
Jul 26, 2022 · Databases

Row Store vs Column Store: Comparison, Advantages, and Experimental Evaluation in openGauss

This article explains the differences between row-based and column-based storage in databases, compares their advantages and disadvantages, presents experimental results using openGauss including space usage and insert performance, and offers practical guidance on selecting the appropriate storage model for various workloads.

Column StoreDatabase StorageRow Store
0 likes · 10 min read
Row Store vs Column Store: Comparison, Advantages, and Experimental Evaluation in openGauss
Architecture Digest
Architecture Digest
Jul 19, 2022 · Databases

Row Store vs Column Store in openGauss: Comparison, Advantages, Disadvantages, and Experimental Evaluation

This article explains the fundamental differences between row‑based and column‑based storage in databases, compares their read/write performance, presents experimental results on openGauss showing space and speed trade‑offs, and offers practical guidance on when to choose each storage model.

Column StoreDatabase StorageRow Store
0 likes · 11 min read
Row Store vs Column Store in openGauss: Comparison, Advantages, Disadvantages, and Experimental Evaluation