Tagged articles

pagination

325 articles · Page 4 of 4

May 14, 2019 · Backend Development

Why Traditional PageSize/PageIndex Pagination Breaks with Dynamic Data—and How to Fix It

This article examines the pitfalls of using static pageSize and pageIndex parameters for pagination on rapidly changing data sets, illustrates how data shifts can cause duplicate or missing records, and proposes client‑side de‑duplication, server‑side last‑ID pagination, and business‑level tolerance strategies.

API designDynamic Databackend

0 likes · 6 min read

Why Traditional PageSize/PageIndex Pagination Breaks with Dynamic Data—and How to Fix It

Java Captain

Apr 6, 2019 · Backend Development

MyBatis Q&A: #{} vs ${}, Pagination Techniques, Caching, Lazy Loading, Executors, and Custom Plugin Development

This article explains MyBatis fundamentals including the difference between #{} and ${} placeholders, various pagination approaches, logical versus physical pagination, first‑ and second‑level caching, lazy‑loading mechanisms, executor types, pagination plugin principles, and how to create a custom MyBatis plugin with code examples.

Backend DevelopmentCachingMyBatis

0 likes · 8 min read

MyBatis Q&A: #{} vs ${}, Pagination Techniques, Caching, Lazy Loading, Executors, and Custom Plugin Development

Liangxu Linux

Feb 20, 2019 · Databases

19 Essential MySQL Optimization Techniques Every Developer Should Know

This guide presents 19 practical MySQL optimization tips—including using EXPLAIN, avoiding SELECT *, limiting IN lists, preferring UNION ALL, improving pagination, leveraging full‑text indexes, and proper join strategies—to help developers write faster, more efficient queries.

EXPLAINFull-Text SearchJOIN

0 likes · 12 min read

19 Essential MySQL Optimization Techniques Every Developer Should Know

Test Development Learning Exchange

Dec 22, 2018 · Backend Development

Building a Django REST API with PyMySQL and Pagination

This tutorial explains how to collect data with a Python web crawler, store it in MySQL using PyMySQL, set up a Django project with Django REST framework, define models, serializers, and views, and implement pagination for a robust backend API.

Backend DevelopmentDjangoPython

0 likes · 11 min read

Building a Django REST API with PyMySQL and Pagination

Qunar Tech Salon

Dec 4, 2018 · Mobile Development

Zero‑Adapter Multi‑Item RecyclerView Library for Android

This article introduces an open‑source Android library that eliminates the need for custom RecyclerView adapters by using a ViewHolderManager system to handle multiple item types, headers, footers, click listeners, load‑more pagination, and animations, with complete code examples and usage guidelines.

AdapterAndroidMulti‑Item

0 likes · 12 min read

Zero‑Adapter Multi‑Item RecyclerView Library for Android

Youzan Coder

Nov 16, 2018 · Databases

Optimizing Large-Scale Pagination Queries in MySQL

When paginating millions of rows in MySQL, avoid large OFFSET scans by using delayed joins or bookmark techniques that first fetch primary‑key values via covering indexes, then retrieve the needed rows, dramatically reducing I/O and query latency.

Query Optimizationbookmark paginationdatabase

0 likes · 10 min read

Optimizing Large-Scale Pagination Queries in MySQL

360 Quality & Efficiency

Sep 29, 2018 · Databases

Diagnosing and Optimizing MySQL Query Performance Issues

This article explains how large data volumes and differing environments can degrade MySQL query performance, demonstrates using EXPLAIN to analyze index usage and row scans, and offers practical steps such as adding filters, pagination, and code adjustments to improve speed.

IndexingQuery Optimizationenvironment

0 likes · 6 min read

Diagnosing and Optimizing MySQL Query Performance Issues

Java Captain

Jun 21, 2018 · Backend Development

Step-by-Step Guide to Building a Spring Boot MyBatis Demo Project

This article provides a detailed tutorial for creating a Spring Boot project with MyBatis, including environment setup, Maven dependencies, configuration files, database creation, MyBatis generator usage, and sample controller, service, and mapper code, enabling pagination with PageHelper and testing via HTTP requests.

Backend DevelopmentJavaMyBatis

0 likes · 14 min read

Step-by-Step Guide to Building a Spring Boot MyBatis Demo Project

21CTO

Apr 27, 2018 · Backend Development

How Stack Overflow Achieves Lightning‑Fast Pagination

This article explains the sophisticated pagination system used by Stack Overflow, covering offset‑based queries, a custom Tag Engine, database joins, in‑memory sorting, and caching techniques that together deliver rapid page navigation even over billions of records.

backenddatabasepagination

0 likes · 6 min read

How Stack Overflow Achieves Lightning‑Fast Pagination

ITPUB

Mar 23, 2018 · Databases

Why Classic MySQL Pagination “Optimization” Often Fails and When It Actually Helps

This article investigates the classic MySQL pagination “optimization” technique, reproduces tests on a low‑end server, compares plain LIMIT queries with the sub‑query rewrite on both clustered and non‑clustered indexes, and explains why the method sometimes improves performance and sometimes adds overhead.

SQLindexmysql

0 likes · 15 min read

Why Classic MySQL Pagination “Optimization” Often Fails and When It Actually Helps

Java Captain

Mar 20, 2018 · Backend Development

Implementing Pagination in a Java Web Application with Spring MVC and MyBatis

This article demonstrates how to implement page-based data retrieval in a Java web application using Spring MVC, MyBatis, and a custom Page utility class, covering the creation of the pagination class, mapper XML, DAO interfaces, service logic, controller handling, and JSP pagination controls.

JavaMyBatisWeb Development

0 likes · 10 min read

Implementing Pagination in a Java Web Application with Spring MVC and MyBatis

Tencent TDS Service

Feb 1, 2018 · Backend Development

How a TV App’s Waterfall Layout Boosted User Engagement and Efficiency

This article details the redesign of a TV app from a horizontal layout to a waterfall flow, explaining the project timeline, advantages, new seven‑layer architecture, CMS‑driven configuration, compatibility handling, pagination strategies, caching, and fault‑tolerance measures that together improved user conversion and system robustness.

CMSTV appbackend-architecture

0 likes · 36 min read

How a TV App’s Waterfall Layout Boosted User Engagement and Efficiency

Hujiang Technology

Jan 23, 2018 · Mobile Development

Understanding Android Paging Library: DataSource, PagedList, and PagedListAdapter

This article explains the Android Paging Library’s architecture—including DataSource variants, PagedList configuration, and PagedListAdapter integration—showing how to efficiently load large data sets from single or multiple sources while handling threading, prefetching, and UI updates.

AndroidDataSourceMobile Development

0 likes · 7 min read

Understanding Android Paging Library: DataSource, PagedList, and PagedListAdapter

Beike Product & Technology

Nov 27, 2017 · Frontend Development

Implementing Scroll-Based Lazy Loading, Event Throttling, and Request Locking for Frontend Pagination

This article explains how to replace traditional pagination with scroll‑triggered lazy loading, using a 200 px threshold, 60 ms event throttling, a loading‑state lock, UI feedback, error handling, and cross‑platform scroll compatibility to improve user experience on web and mobile pages.

JavaScriptevent-throttlinglazy-loading

0 likes · 6 min read

Implementing Scroll-Based Lazy Loading, Event Throttling, and Request Locking for Frontend Pagination

Aotu Lab

Jun 30, 2017 · Frontend Development

Understanding Pagination: Traditional vs. Infinite Scrolling and How to Implement Them

This article explains the differences between traditional page‑number pagination and infinite‑scroll (streaming) pagination, compares their characteristics, and provides detailed front‑end and back‑end implementation methods along with common pitfalls and optimization techniques such as caching, cursor‑based paging, and client‑side deduplication.

Cache OptimizationCursor Paginationback-end development

0 likes · 12 min read

Understanding Pagination: Traditional vs. Infinite Scrolling and How to Implement Them

dbaplus Community

Jun 22, 2017 · Databases

Turning a 5‑Second Oracle Pagination Query into Sub‑Second Speed

This article walks through a real‑world Oracle pagination query that took over five seconds for just fifteen rows, analyzes why ORDER BY caused the slowdown, and demonstrates a step‑by‑step rewrite using a WITH clause and index‑driven access that reduces execution time to under one second.

OracleSQLindex

0 likes · 10 min read

Turning a 5‑Second Oracle Pagination Query into Sub‑Second Speed

Suning Design

May 27, 2017 · Frontend Development

When to Use Pagination, Load More, or Infinite Scroll? A Data‑Driven Design Guide

This article examines the usability trade‑offs of pagination, "load more" buttons, and infinite scroll, referencing Baymard research to help designers choose the most effective data‑loading interaction for their product's context and improve overall user experience.

UXdesignfrontend

0 likes · 7 min read

When to Use Pagination, Load More, or Infinite Scroll? A Data‑Driven Design Guide

ITPUB

Mar 7, 2017 · Databases

Why MySQL LIMIT Pagination Slows Down and How to Speed It Up with Covering Indexes

This article examines the performance problems of MySQL LIMIT pagination on a table with over 800,000 rows, demonstrates timing tests for various offsets, and presents covering‑index techniques that dramatically reduce query time, including practical SQL examples.

Covering IndexLIMITmysql

0 likes · 6 min read

Why MySQL LIMIT Pagination Slows Down and How to Speed It Up with Covering Indexes

ITPUB

Aug 31, 2016 · Databases

Taming Black‑Swan Database Failures: Pagination, Join, and Count(*) Optimizations

The article examines how unpredictable "black‑swan" incidents caused by slow, high‑frequency queries can destabilize database systems and presents concrete MySQL optimization techniques for large pagination, join operations, and concurrent count(*) queries that reduced slow‑query volume by about ninety percent.

Count OptimizationSlow Queryjoin optimization

0 likes · 9 min read

Taming Black‑Swan Database Failures: Pagination, Join, and Count(*) Optimizations

Qunar Tech Salon

Jul 8, 2016 · Databases

Optimizing MySQL Pagination for Large Datasets

The article explains why traditional LIMIT OFFSET pagination becomes inefficient on large MySQL tables, analyzes the performance impact of counting rows and using SQL_CALC_FOUND_ROWS, and presents several optimized techniques—including index‑based counting, keyset pagination, page‑number caching, and temporary‑table approaches—to achieve fast and scalable pagination.

SQLdatabase optimizationmysql

0 likes · 8 min read

Optimizing MySQL Pagination for Large Datasets

Java High-Performance Architecture

Jan 16, 2016 · Databases

How to Efficiently Paginate Across Sharded Databases Without Heavy Overhead

This article explains a practical method for performing pagination on a sharded table by querying each database up to the target offset, merging and sorting the results, and extracting the required page while discussing performance drawbacks and an optimization when data distribution is uniform.

SQLShardingdistributed databases

0 likes · 5 min read

How to Efficiently Paginate Across Sharded Databases Without Heavy Overhead

ITPUB

Nov 23, 2015 · Databases

Why MySQL LIMIT with ORDER BY on Non‑Unique Columns Is Unstable and How to Fix It

In MySQL 5.6, using LIMIT together with ORDER BY on a non‑unique column can produce nondeterministic result sets, a known bug that persists regardless of indexing, and the article shows how adding a secondary unique sort key resolves the uncertainty for reliable pagination.

Database BugIndexingLIMIT

0 likes · 6 min read

Why MySQL LIMIT with ORDER BY on Non‑Unique Columns Is Unstable and How to Fix It

21CTO

Oct 23, 2015 · Databases

How to Efficiently Paginate 100M User IDs in MySQL

This article examines three SQL pagination strategies for a 100‑million‑row favorites table, compares their correctness and performance using EXPLAIN analysis, and demonstrates why a GROUP BY approach with proper indexing yields the most reliable and fast results.

Large DataSQLindex

0 likes · 5 min read

How to Efficiently Paginate 100M User IDs in MySQL

21CTO

Aug 10, 2015 · Backend Development

Designing Practical RESTful APIs: Best Practices for Real‑World Apps

This article presents practical guidelines for designing, versioning, securing, and documenting RESTful APIs, covering resource modeling, URL conventions, filtering, sorting, pagination, authentication, rate limiting, error handling, and response formats to help developers build flexible and user‑friendly public APIs.

API designHTTPRESTful API

0 likes · 22 min read

Designing Practical RESTful APIs: Best Practices for Real‑World Apps

Java High-Performance Architecture

Jul 2, 2015 · Databases

Boost MySQL Pagination: Fast Alternatives to LIMIT OFFSET

Using LIMIT OFFSET for pagination becomes inefficient beyond thousands of rows, but by leveraging indexed ID ranges, delayed joins, or index‑only scans you can retrieve pages in milliseconds, dramatically improving performance for large datasets.

OptimizationSQLindex

0 likes · 2 min read

Boost MySQL Pagination: Fast Alternatives to LIMIT OFFSET