BestHub
Sign in
Tag

cold-hot data

0 views collected around this technical thread.

Code Ape Tech Column
Code Ape Tech Column
Sep 26, 2023 · Databases

Query Separation: Optimizing Large Table Reads by Decoupling Query Data

The article explains query separation as a technique to improve performance of massive business tables by storing write‑optimized data and query‑optimized data separately, discusses when to apply it, various implementation methods, storage options, and operational considerations such as MQ handling and consistency.

Database OptimizationElasticsearchMessage Queue
0 likes · 10 min read
Query Separation: Optimizing Large Table Reads by Decoupling Query Data
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jun 24, 2021 · Databases

Common Solutions for Massive Data Storage and High‑Performance Access

The article outlines a range of techniques—including caching, read‑write splitting, vertical partitioning, sharding, cold‑hot data separation, Elasticsearch, NoSQL and NewSQL—to store and retrieve billions of user‑generated records efficiently while maintaining high throughput and low latency.

ElasticsearchNoSQLRead-Write Splitting
0 likes · 17 min read
Common Solutions for Massive Data Storage and High‑Performance Access