BestHub
Sign in
Code Mala Tang
Code Mala Tang
Feb 22, 2026 · Backend Development

Why FastAPI Slows Down with Millions of Rows—and How to Keep It Fast

FastAPI feels lightning‑fast on small datasets, but returning millions of rows can exhaust memory, block the event loop, and cripple the database; this article explains why that happens and provides concrete design rules—selective fields, pagination, cursor‑based queries, streaming, and chunked processing—to keep APIs stable at scale.

FastAPIPaginationStreaming
0 likes · 9 min read
Why FastAPI Slows Down with Millions of Rows—and How to Keep It Fast
macrozheng
macrozheng
Dec 8, 2025 · Databases

Why LIMIT Pagination Slows Down on Large Tables and How to Optimize It

This tutorial demonstrates how MySQL LIMIT pagination performs on tables with millions of rows, measures query times for various offsets and batch sizes, and presents practical optimization techniques such as sub‑queries, ID‑range filtering, and column selection to improve speed.

LIMITMySQLOptimization
0 likes · 9 min read
Why LIMIT Pagination Slows Down on Large Tables and How to Optimize It
Python Programming Learning Circle
Python Programming Learning Circle
Jul 12, 2025 · Fundamentals

Boost Your Data Exploration with pandas‑profiling: Quick Setup and Customization

This article explains why data cleaning and exploratory analysis consume most of a data scientist's time, introduces the pandas‑profiling library as a richer alternative to pandas.describe(), shows how to install and generate reports, customize them via code or YAML, and discusses performance considerations for larger datasets.

Data AnalysisEDAYAML
0 likes · 8 min read
Boost Your Data Exploration with pandas‑profiling: Quick Setup and Customization
MaGe Linux Operations
MaGe Linux Operations
May 15, 2023 · Databases

Why MySQL LIMIT Slows Down on Millions of Rows—and How to Fix It

Through hands‑on experiments with a 10‑million‑row MySQL 5.7 table, this article shows how standard LIMIT pagination becomes slower as offset and data volume grow, then presents practical optimizations—sub‑queries, ID‑based ranges, and column selection—to dramatically improve query performance.

MySQLlarge datasets
0 likes · 11 min read
Why MySQL LIMIT Slows Down on Millions of Rows—and How to Fix It
Selected Java Interview Questions
Selected Java Interview Questions
Jan 21, 2022 · Databases

Performance Testing and Optimization of MySQL Pagination on Large Datasets

This article demonstrates how to generate, insert, and query ten‑million‑row MySQL tables, measures pagination query times under different offsets and limits, and presents practical optimization techniques such as sub‑queries, id‑range filtering, and column selection to improve performance on massive data sets.

MySQLOptimizationPagination
0 likes · 10 min read
Performance Testing and Optimization of MySQL Pagination on Large Datasets
Top Architect
Top Architect
Jun 30, 2021 · Databases

Analyzing and Optimizing MySQL Pagination Performance with Large Offsets

This article investigates why MySQL queries with large LIMIT offsets become extremely slow, demonstrates the issue with simulated millions‑of‑row datasets, and presents three optimization strategies—including index‑covering subqueries, remembering the last primary‑key position, and applying offset throttling—to achieve consistent, fast pagination performance.

MySQLOptimizationPagination
0 likes · 12 min read
Analyzing and Optimizing MySQL Pagination Performance with Large Offsets
ITPUB
ITPUB
Sep 7, 2016 · Databases

Optimizing and Migrating a 20 Million‑Row MySQL Table

This guide explains how to clean redundant fields, restructure a massive MySQL table, batch‑fetch data with LIMIT, rewrite slow queries, and compare three insertion methods—including prepared statements and bulk inserts—to cut migration time from hours to under 20 minutes.

Batch ProcessingMySQLSQL Optimization
0 likes · 7 min read
Optimizing and Migrating a 20 Million‑Row MySQL Table