Tagged articles
28 articles
Page 1 of 1
Architect's Guide
Architect's Guide
Sep 14, 2025 · Databases

Why Database Indexes Speed Up Queries: From Storage Basics to Binary Search

This article explains how databases store data on various storage devices, why indexes dramatically improve query performance through sorted structures and binary search, and outlines practical SQL optimization techniques while warning about the trade‑offs of excessive indexing.

Binary SearchClustered IndexDatabase Index
0 likes · 11 min read
Why Database Indexes Speed Up Queries: From Storage Basics to Binary Search
Liangxu Linux
Liangxu Linux
Jun 8, 2025 · Fundamentals

9 Essential C Code Snippets Every Embedded Engineer Should Know

This article presents a curated collection of nine high‑utility C code snippets for embedded development, covering a circular buffer, custom assertions, bit reversal, fixed‑point arithmetic, endianness conversion, bit masks, timer handling, binary search, and a simple bitset structure, each with concise explanations and ready‑to‑use implementations.

Binary SearchC programmingData Structures
0 likes · 6 min read
9 Essential C Code Snippets Every Embedded Engineer Should Know
Raymond Ops
Raymond Ops
Apr 24, 2025 · Fundamentals

Master Recursion: Classic Python Examples and Core Concepts

This article introduces recursion, explains its definition and key characteristics, and demonstrates classic Python examples such as factorial calculation, Fibonacci sequence generation, and binary search, helping readers grasp how recursion simplifies complex problems compared to iterative loops.

Binary SearchFibonacciPython
0 likes · 8 min read
Master Recursion: Classic Python Examples and Core Concepts
Java Tech Enthusiast
Java Tech Enthusiast
Dec 1, 2024 · Fundamentals

LeetCode 34: Binary Search Range

LeetCode 34 asks for the first and last indices of a target in a non‑decreasing integer array, returning [-1,-1] when absent, and can be solved in O(log n) time by applying two binary‑search passes—one locating the leftmost occurrence and the other the rightmost—illustrated with Java, C++, and Python implementations.

Binary SearchCJava
0 likes · 8 min read
LeetCode 34: Binary Search Range
Architect's Guide
Architect's Guide
Oct 19, 2023 · Databases

Understanding Database Indexes: Storage Principles, Types, and Optimization Techniques

This article explains how computer storage works, why database indexes dramatically speed up queries, the mechanics of binary search, the differences between clustered and non‑clustered indexes, common pitfalls of over‑indexing, and practical SQL optimization strategies to avoid full table scans and index invalidation.

Binary SearchClustered IndexSQL Optimization
0 likes · 12 min read
Understanding Database Indexes: Storage Principles, Types, and Optimization Techniques
php Courses
php Courses
Sep 4, 2023 · Fundamentals

Binary Search: Explanation and PHP Implementations

Binary search is an efficient O(log n) algorithm for locating a target value in a sorted array, and this article explains its step-by-step process, provides iterative and recursive PHP code examples, and discusses their usage and performance considerations.

Binary SearchIterativeO(log n)
0 likes · 6 min read
Binary Search: Explanation and PHP Implementations
Top Architect
Top Architect
Oct 25, 2022 · Databases

Understanding Database Indexes: Storage Principles, Binary Search, and Optimization Techniques

This article explains how databases store data on various storage media, why indexes dramatically speed up queries through sorted structures and binary search, discusses different index types such as clustered indexes, and outlines common SQL optimization practices while warning against excessive indexing and typical pitfalls.

Binary SearchClustered IndexDatabase Index
0 likes · 12 min read
Understanding Database Indexes: Storage Principles, Binary Search, and Optimization Techniques
Su San Talks Tech
Su San Talks Tech
Sep 19, 2022 · Databases

How InnoDB Locates the First Record in a B‑Tree Scan Range

This article explains why locating a record in a B‑Tree index is crucial for MySQL InnoDB operations, describes scan intervals, index page structures, and details the step‑by‑step binary and sequential search process used to find the first matching record, including performance optimizations.

B-TreeBinary SearchIndex Scan
0 likes · 28 min read
How InnoDB Locates the First Record in a B‑Tree Scan Range
NiuNiu MaTe
NiuNiu MaTe
Dec 2, 2021 · Fundamentals

Master the Classic 2‑Egg 100‑Floor Problem: Optimal Strategies Explained

This article explains the classic two‑egg, 100‑floor interview puzzle, analyzes why it became a staple, and walks through four solution approaches—from a naïve linear method to binary search and a balanced partition strategy—culminating in a mathematically derived optimal method that never exceeds fourteen drops.

Binary Searchalgorithmegg-drop
0 likes · 8 min read
Master the Classic 2‑Egg 100‑Floor Problem: Optimal Strategies Explained
21CTO
21CTO
Oct 17, 2021 · Fundamentals

Mastering Interview Math: Implement a Custom Square Root Function Without Libraries

This article explores how to solve a common interview coding challenge—implementing a square‑root function without using library calls—by discussing problem analysis, linear and binary‑search approaches, optimization techniques, testing strategies, and the broader skills interviewers aim to assess.

Binary Searchalgorithmcoding-challenge
0 likes · 15 min read
Mastering Interview Math: Implement a Custom Square Root Function Without Libraries
ITPUB
ITPUB
Jan 19, 2021 · Databases

Why Indexes Speed Up Database Queries: From Binary Trees to B+ Trees

This article explains how database indexes improve query performance by exploring binary trees, binary search, balanced trees, B‑trees, and B+‑trees, illustrating their structures, advantages, disadvantages, and the impact of disk I/O on overall efficiency.

B+TreeB-treeBinary Search
0 likes · 17 min read
Why Indexes Speed Up Database Queries: From Binary Trees to B+ Trees
JavaEdge
JavaEdge
Nov 30, 2020 · Backend Development

How Kafka’s Index Uses Binary Search and Cache‑Friendly Optimizations

This article explains Kafka's index architecture, the AbstractIndex class hierarchy, how entry sizes are chosen, the use of memory‑mapped files, the binary‑search algorithm for locating index entries, and a cache‑friendly improvement that reduces page faults and I/O latency.

Backend DevelopmentBinary SearchKafka
0 likes · 13 min read
How Kafka’s Index Uses Binary Search and Cache‑Friendly Optimizations
Python Programming Learning Circle
Python Programming Learning Circle
Feb 20, 2020 · Fundamentals

Binary Search Algorithm Explanation

This article explains the binary search algorithm for locating a target element in a sorted array, describing its midpoint‑starting process, halving of the search range, termination conditions, and includes a simple example with its output.

Binary SearchSearchalgorithm
0 likes · 3 min read
Binary Search Algorithm Explanation
Java Captain
Java Captain
Apr 21, 2019 · Fundamentals

Binary Search and Its Variants in Java

This article explains the classic binary search algorithm, presents a Java implementation, and details multiple binary‑search variants—including finding first/last equal elements, elements less than or greater than a key—while providing clear code examples and guidance on boundary handling.

Binary Searchalgorithmcoding interview
0 likes · 9 min read
Binary Search and Its Variants in Java
Programmer DD
Programmer DD
Jan 9, 2019 · Fundamentals

How to Find the Peak in a Bitonic Array Using Binary Search

This article presents a JavaScript solution for locating the maximum element in a bitonic (first increasing then decreasing) array, explaining that the problem is a variant of binary search and providing a complete implementation using a binary‑search‑based algorithm.

Binary SearchJavaScriptalgorithm
0 likes · 3 min read
How to Find the Peak in a Bitonic Array Using Binary Search
Programmer DD
Programmer DD
Dec 17, 2018 · Fundamentals

How to Compute √2 Efficiently: Binary Search, Newton’s Method, and C Tricks

Learn multiple techniques to calculate the square root of 2—including binary search, Newton’s iteration, and a clever C library implementation—through clear explanations, step‑by‑step illustrations, and full JavaScript and C code examples that reveal the underlying mathematics and performance considerations.

Binary SearchCNewton's method
0 likes · 4 min read
How to Compute √2 Efficiently: Binary Search, Newton’s Method, and C Tricks