Tagged articles
15 articles
Page 1 of 1
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 20, 2024 · Databases

Understanding MySQL Index Merge Optimization and Its Performance Implications

This article explains the MySQL Index Merge access method, details the underlying merge‑sort algorithm, enumerates the three index‑merge strategies, analyzes source‑code snippets, presents a real‑world case where index merge hurts performance, and offers practical optimization recommendations.

Database PerformanceSQL Optimizationindex merge
0 likes · 16 min read
Understanding MySQL Index Merge Optimization and Its Performance Implications
dbaplus Community
dbaplus Community
Mar 11, 2023 · Databases

Optimizing Distributed Database Sorting with Proxy Buffers and Priority Queues

This article examines the architecture of distributed databases, identifies the challenges of global sorting across shards, and presents both in‑memory and disk‑based proxy sorting solutions, detailing buffer configuration, merge‑sort and priority‑queue techniques, performance trade‑offs, and practical constraints for large‑scale queries.

Proxydistributed databasesexternal merge
0 likes · 10 min read
Optimizing Distributed Database Sorting with Proxy Buffers and Priority Queues
JavaEdge
JavaEdge
Jan 22, 2023 · Fundamentals

Designing a High‑Performance Sorting Function: Algorithms and Optimizations

This article examines how high‑performance sorting functions such as C's qsort() and Java's Collections.sort() are implemented, compares suitable algorithms, analyzes merge sort versus quicksort, and presents practical optimizations like median‑of‑three pivots, random pivots, recursion depth limits, and hybrid insertion sort.

CQuickSortSorting
0 likes · 7 min read
Designing a High‑Performance Sorting Function: Algorithms and Optimizations
Python Programming Learning Circle
Python Programming Learning Circle
Feb 19, 2022 · Fundamentals

A Guide to Sorting Algorithms in Python

This article introduces four fundamental sorting algorithms—bubble sort, insertion sort, merge sort, and quick sort—explaining their concepts, step‑by‑step operations, and providing complete Python implementations to help readers understand and apply these techniques effectively.

PythonQuick SortSorting Algorithms
0 likes · 8 min read
A Guide to Sorting Algorithms in Python
Selected Java Interview Questions
Selected Java Interview Questions
Sep 13, 2021 · Fundamentals

Understanding Merge Sort and Merging Two Sorted Arrays in C#

This article explains the merge sort algorithm’s divide‑and‑conquer principle, analyzes its O(n log n) time complexity, and provides two complete C# code examples—one for a generic merge sort and another for merging two already sorted arrays—along with visual illustrations of the merging process.

Calgorithmdivide and conquer
0 likes · 6 min read
Understanding Merge Sort and Merging Two Sorted Arrays in C#
Python Programming Learning Circle
Python Programming Learning Circle
May 9, 2020 · Fundamentals

Fish Division Puzzle and Classic Sorting Algorithms (Merge, Selection, Bubble) with Python Implementations

This article presents a combinatorial fish‑division puzzle solved by exhaustive search with Python code, followed by clear explanations and Python implementations of three fundamental sorting algorithms—merge sort, selection sort, and bubble sort—illustrating their core ideas and step‑by‑step processes.

PythonSortingalgorithm
0 likes · 5 min read
Fish Division Puzzle and Classic Sorting Algorithms (Merge, Selection, Bubble) with Python Implementations
Programmer DD
Programmer DD
Mar 10, 2020 · Big Data

How to Sort a 4.6 GB File with 500 Million Numbers Efficiently

This article explores practical techniques for sorting a massive 4.6 GB file containing 500 million random integers, comparing internal quick‑sort and merge‑sort implementations, a bitmap‑based approach, and a full external‑sorting pipeline, while analyzing performance bottlenecks and memory constraints.

bitmap sortexternal sortingmerge sort
0 likes · 11 min read
How to Sort a 4.6 GB File with 500 Million Numbers Efficiently
Top Architect
Top Architect
Feb 25, 2020 · Big Data

External Sorting of a 4.6 GB File Containing 500 Million Integers: Strategies, Implementations, and Performance

The article presents a practical case of sorting a 4.6 GB file with 500 million random integers, evaluates in‑memory quicksort and merge‑sort implementations, discusses bitmap sorting, and finally details a multi‑phase external‑sort algorithm with measured runtimes and resource considerations.

Sorting Algorithmbitmap sortexternal sort
0 likes · 11 min read
External Sorting of a 4.6 GB File Containing 500 Million Integers: Strategies, Implementations, and Performance
Java Captain
Java Captain
Aug 29, 2019 · Fundamentals

Common Sorting Algorithms: Concepts, Implementations, and Complexity Analysis

This article provides a comprehensive overview of eight classic sorting algorithms—including bubble sort, quick sort, insertion sort, shell sort, selection sort, heap sort, merge sort, and radix sort—detailing their core ideas, Java implementations, performance characteristics, space usage, and stability considerations.

Quick SortSortingbubble sort
0 likes · 30 min read
Common Sorting Algorithms: Concepts, Implementations, and Complexity Analysis
Java Backend Technology
Java Backend Technology
Dec 12, 2017 · Fundamentals

Master 8 Essential Sorting Algorithms: From Insertion to Radix

This article introduces eight fundamental internal sorting algorithms—Insertion, Shell, Selection, Heap, Bubble, Quick, Merge, and Radix—explaining their mechanisms, visual illustrations, and analyzing their time and space complexities to help readers choose the appropriate method for different data sets.

Quick Sortalgorithm complexityinsertion sort
0 likes · 9 min read
Master 8 Essential Sorting Algorithms: From Insertion to Radix
Qunar Tech Salon
Qunar Tech Salon
Apr 29, 2016 · Fundamentals

Common Sorting Algorithms: Quick Sort, Merge Sort, Heap Sort, Selection Sort, Bubble Sort, Insertion Sort, and Shell Sort

This article introduces seven classic sorting algorithms—Quick Sort, Merge Sort, Heap Sort, Selection Sort, Bubble Sort, Insertion Sort, and Shell Sort—explaining their principles, step-by-step procedures, and visual performance illustrations to help readers understand their operation and efficiency.

AlgorithmsQuick SortSorting
0 likes · 8 min read
Common Sorting Algorithms: Quick Sort, Merge Sort, Heap Sort, Selection Sort, Bubble Sort, Insertion Sort, and Shell Sort