How QQ Built Multi‑Region Resilience with Set‑Based Deployment and Smart Scheduling

This article explains how QQ’s operations team designed a multi‑region, set‑based deployment architecture, tackled data synchronization, employed sharding strategies, and implemented flexible scheduling policies to ensure high availability and rapid disaster recovery for hundreds of millions of users.

DeploymentOperationsSet-Based

0 likes · 16 min read

How QQ Built Multi‑Region Resilience with Set‑Based Deployment and Smart Scheduling

ITPUB

Aug 29, 2017 · Databases

Why Set-Based SQL Beats Procedural Queries: Real Performance Comparisons

The article explains how set‑based SQL queries outperform procedural, row‑by‑row approaches by showing concrete examples, AUTOTRACE statistics, and PL/SQL function alternatives, highlighting massive differences in consistent gets, recursive calls, and overall resource consumption for large production data sets.

PL/SQLProceduralSet-Based

0 likes · 7 min read

Why Set-Based SQL Beats Procedural Queries: Real Performance Comparisons