cursor pagination

IT Services Circle

Aug 13, 2024 · Backend Development

Implementing Pull‑Down Pagination for Instant Messaging History

This article explains the challenges of loading historical chat messages in an instant‑messaging app and demonstrates why traditional offset pagination fails, then introduces cursor‑based pagination with SQL examples and best‑practice guidelines for reliable incremental loading.

DatabaseInstant MessagingSQL

0 likes · 7 min read

Implementing Pull‑Down Pagination for Instant Messaging History

JD Retail Technology

Feb 29, 2024 · Databases

Optimizing Large‑Scale Batch Processing for an Advertising Platform: From Query Tuning to Load‑Balanced Execution

This article presents a real‑world case study of optimizing massive batch‑processing tasks in an ad‑platform by applying query‑level improvements, cursor‑based pagination, shard‑aware batch updates, JVM‑tuned garbage collection, and distributed load‑balancing, ultimately reducing CPU usage from 80% to under 2% and cutting query‑per‑minute volume from millions to a few thousand.

Database OptimizationJavaPerformance Tuning

0 likes · 22 min read

Optimizing Large‑Scale Batch Processing for an Advertising Platform: From Query Tuning to Load‑Balanced Execution