BestHub
Sign in
Tagged articles
18 articles
Page 1 of 1
dbaplus Community
dbaplus Community
Feb 10, 2026 · Backend Development

How to Eliminate Unstable Pagination Anchors and Data Duplication in Backend Systems

This article explains why offset‑based pagination can cause duplicate or missing records in backend list queries, illustrates real‑world cases, analyzes the root causes, and presents three practical solutions—including cursor pagination, timestamp windows, and Elasticsearch search_after—along with their trade‑offs and implementation details.

CursorElasticsearchpagination
0 likes · 12 min read
How to Eliminate Unstable Pagination Anchors and Data Duplication in Backend Systems
Su San Talks Tech
Su San Talks Tech
Dec 18, 2025 · Backend Development

Which Elasticsearch Pagination Method Is Best? from/size, search_after, Scroll API & PIT

This guide compares Elasticsearch’s four common pagination techniques—`from/size`, `search_after`, Scroll API, and Point in Time—detailing their syntax, advantages, drawbacks, and ideal use‑cases, helping developers select the most efficient method based on pagination depth, consistency requirements, and resource constraints.

BackendElasticsearchpagination
0 likes · 10 min read
Which Elasticsearch Pagination Method Is Best? from/size, search_after, Scroll API & PIT
Architect
Architect
Nov 27, 2025 · Databases

How to Overcome Deep Pagination Bottlenecks with Cursor, Subqueries, and Elasticsearch Search After

This article explains why deep pagination hurts performance in large datasets, demonstrates the inefficiency of offset‑based SQL queries, and presents practical alternatives such as cursor pagination, sub‑query optimizations, delayed joins, caching, business limits, and the Elasticsearch Search After technique for stable, scalable paging.

Database OptimizationElasticsearchcursor pagination
0 likes · 10 min read
How to Overcome Deep Pagination Bottlenecks with Cursor, Subqueries, and Elasticsearch Search After
Su San Talks Tech
Su San Talks Tech
Nov 24, 2025 · Backend Development

Choosing the Right Elasticsearch Pagination Method: from/size, search_after, Scroll API, and PIT

This article examines the four primary Elasticsearch pagination techniques—using from/size, search_after, the Scroll API, and Point in Time—detailing their syntax, advantages, disadvantages, suitable scenarios, and provides guidance on selecting the optimal method based on depth, consistency, and resource constraints.

backend-developmentpaginationpoint in time
0 likes · 10 min read
Choosing the Right Elasticsearch Pagination Method: from/size, search_after, Scroll API, and PIT
Architecture Digest
Architecture Digest
Nov 5, 2025 · Backend Development

Why Deep Pagination Breaks Elasticsearch and How to Fix It

This article explains how deep pagination in Elasticsearch triggers costly scatter‑gather queries that overload CPU, memory, and network, and it presents practical alternatives such as the scroll API and search_after to achieve efficient, real‑time pagination for large datasets.

Elasticsearchdeep paginationperformance
0 likes · 10 min read
Why Deep Pagination Breaks Elasticsearch and How to Fix It
dbaplus Community
dbaplus Community
Aug 6, 2025 · Backend Development

Why Elasticsearch Pagination Takes 10 Minutes and How to Reduce It to Seconds

This article examines a real‑world Elasticsearch pagination case where a range query across multiple indices took ten minutes, analyzes the root causes such as deep pagination, large time windows, and multi‑index scans, and presents concrete optimizations—including reducing page size, narrowing the time range, switching to search_after, and using index aliases—to bring query time down to seconds.

BackendElasticsearchsearch_after
0 likes · 10 min read
Why Elasticsearch Pagination Takes 10 Minutes and How to Reduce It to Seconds
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Mar 26, 2025 · Backend Development

Solving Marketing Activity Product Search with Elasticsearch: When to Use Join

The article examines why front‑end product search fails during large marketing events, evaluates Elasticsearch's join feature and its drawbacks, compares nested, reverse‑modeling and flattened approaches, recommends reverse modeling for massive activity‑product data, and provides concrete DSL code, pagination and caching tips.

ElasticsearchJOINdata modeling
0 likes · 10 min read
Solving Marketing Activity Product Search with Elasticsearch: When to Use Join
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Nov 25, 2024 · Backend Development

What Elasticsearch Query Limits Should You Know?

This article explains the five major Elasticsearch query limits—including result size, max clause count, field data, join operations, and query throughput—detailing their default values, why they exist, and practical solutions such as using search_after, scroll API, and resource monitoring to keep clusters stable and performant.

Elasticsearchfielddatamax clause count
0 likes · 11 min read
What Elasticsearch Query Limits Should You Know?
Code Ape Tech Column
Code Ape Tech Column
Aug 11, 2023 · Big Data

Elasticsearch Pagination: From/Size, Deep Paging Issues, and Alternative Methods (Scroll, Search After, PIT)

This article explains how Elasticsearch pagination works with from/size, why deep paging can cause performance problems, and compares alternative techniques such as Scroll, Scroll‑Scan, Sliced Scroll, Search After, and point‑in‑time (PIT) searches for handling large result sets efficiently.

Deep PagingElasticsearchpagination
0 likes · 17 min read
Elasticsearch Pagination: From/Size, Deep Paging Issues, and Alternative Methods (Scroll, Search After, PIT)
Top Architect
Top Architect
Dec 4, 2022 · Databases

Deep Dive into Elasticsearch Pagination: from/size, Scroll, and Search After

This article explains how Elasticsearch handles deep pagination, compares the traditional from/size method with Scroll and Search After techniques, details their internal query and fetch phases, provides practical code examples, and offers guidance on choosing the right approach for large‑scale search workloads.

Big Datapaginationscroll
0 likes · 15 min read
Deep Dive into Elasticsearch Pagination: from/size, Scroll, and Search After
MaGe Linux Operations
MaGe Linux Operations
Nov 20, 2022 · Backend Development

Master Elasticsearch Pagination: From/Size, Scroll & Search After

This article examines Elasticsearch's three pagination strategies—basic from/size, scroll-based deep paging, and the newer search after method—detailing their execution phases, performance implications, code examples, and practical recommendations for choosing the appropriate approach based on data volume and real‑time requirements.

Backendfrom+sizepagination
0 likes · 17 min read
Master Elasticsearch Pagination: From/Size, Scroll & Search After
Programmer DD
Programmer DD
Nov 17, 2022 · Backend Development

Mastering Elasticsearch Pagination: From/Size, Scroll, and Search After Explained

This article examines Elasticsearch's deep pagination challenges and presents three practical solutions—basic from/size, scroll API, and search after—detailing their execution phases, performance trade‑offs, code examples, and guidance on when to choose each method for efficient data retrieval.

backend-developmentpaginationscroll API
0 likes · 14 min read
Mastering Elasticsearch Pagination: From/Size, Scroll, and Search After Explained
Su San Talks Tech
Su San Talks Tech
Nov 3, 2022 · Backend Development

Mastering Elasticsearch Pagination: From From/Size to Scroll and Search After

Elasticsearch offers several pagination strategies—simple from/size, scroll, scroll‑scan, sliced scroll, and the newer search_after with point‑in‑time—each with distinct performance trade‑offs and use‑case suitability, and this guide explains their mechanics, limitations, and best‑practice recommendations for handling deep pagination.

ElasticsearchSearchperformance
0 likes · 18 min read
Mastering Elasticsearch Pagination: From From/Size to Scroll and Search After
Sohu Tech Products
Sohu Tech Products
May 11, 2022 · Backend Development

Elasticsearch Pagination: From/Size, Deep Paging Issues, Scroll, Search After, PIT and Best Practices

This article explains Elasticsearch pagination mechanisms—including from/size, deep paging drawbacks, scroll, scroll‑scan, sliced scroll, search_after and point‑in‑time—detailing their inner workings, performance trade‑offs, configuration limits, and practical recommendations for handling large result sets.

BackendDeep PagingElasticsearch
0 likes · 17 min read
Elasticsearch Pagination: From/Size, Deep Paging Issues, Scroll, Search After, PIT and Best Practices
MaGe Linux Operations
MaGe Linux Operations
Mar 20, 2021 · Backend Development

Mastering Elasticsearch Distributed Search: Performance Tips & Pagination Strategies

This article examines Elasticsearch’s distributed search architecture, explains the two‑phase query and fetch process, identifies performance and relevance scoring challenges, and presents optimization techniques such as Search After with point‑in‑time, Scroll API usage, and DFS query‑then‑fetch for accurate scoring.

Distributed SearchElasticsearchpagination
0 likes · 9 min read
Mastering Elasticsearch Distributed Search: Performance Tips & Pagination Strategies