sf-apex-cursor

What problem does it solve?

Enables efficient pagination and processing of very large SOQL result sets without relying on OFFSET, avoiding heap bloat and OFFSET-driven performance degradation for large datasets.

Core Features & Use Cases

• Server-side pagination at scale: use Database.Cursor to iterate up to 50,000,000 rows while keeping heap usage per-page only.
• Async Queueable chaining: serialize cursor IDs and chain Queueable jobs to continue processing across transactions.
• LWC and Flow integration: use PaginationCursor for @AuraEnabled endpoints to support infinite scroll and paged UI components.
• Use Case: Replace OFFSET-based UI pagination or heavy Batch Apex jobs with cursor-based iteration to maintain performance beyond 2,000 rows.

Quick Start

Open a Database.Cursor for your SOQL, fetch pages of up to 2000 rows, and pass the cursor ID into chained Queueable jobs to process the full result set.