All Articles

140402 articles · Page 7021 of 7021

Feb 28, 2014 · Operations

Which Nginx Load‑Balancing Strategy Wins? Deep Code Dive & Real‑World Tests

This article examines Nginx's built‑in and third‑party load‑balancing algorithms—including weighted round robin, IP hash, fair, generic hash, and consistent hash—by dissecting their source code and presenting comparative performance tests across multiple scenarios to reveal their strengths and trade‑offs.

IP HashWeighted Round Robinbackend

0 likes · 14 min read

Which Nginx Load‑Balancing Strategy Wins? Deep Code Dive & Real‑World Tests

ITPUB

Feb 25, 2014 · Databases

Why Database Query Optimization Matters and Key Strategies to Cut Scan Times

The article explains how costly full‑table scans in large databases, such as a bank's million‑record account table, can be reduced to minutes through effective query‑optimization techniques, and outlines the main strategies, automation possibilities, and future trends in SQL performance.

Full Table ScanQuery Tuningdatabase optimization

0 likes · 3 min read

Why Database Query Optimization Matters and Key Strategies to Cut Scan Times