Programmer DD

Feb 13, 2019 · Databases

Why Cross‑Shard Queries Slow Down: Sharding‑Sphere Performance Test Insights

This article presents a practical performance test of Sharding‑Sphere using MySQL, showing how cross‑shard queries incur significant latency due to parallel routing and result merging, and discusses the underlying thread‑pool execution model and its impact on OLTP versus OLAP workloads.