Guides ยท Technology
API Pagination Performance Tuning
Speed up paginated APIs
Improving paginated APIs uses keyset/cursor pagination for large tables, covering indexes on sort/filter fields, bounded page sizes, and avoiding SELECT * to keep responses fast and stable.
- pagination performance
- keyset
- indexes
- page size
- stability
Choose Cursor
Prefer keyset/cursor for large/real-time data; keep stable order.
Index
Index sort/filter columns; avoid OFFSET scans; limit columns.
Bound Size
Enforce reasonable page sizes; document limits.
Keep Exploring
Guides
API Basics
APIs let software request data or actions from other systems through defined endpoints and responses.
Comparison
RAM vs Storage
RAM handles what your device is actively working on, while storage keeps apps, files, and system data available over time.
How it works
Global Positioning System
GPS uses timing signals from satellites to calculate a receiver's position on Earth.
What it is
Blockchain
A blockchain is a distributed ledger secured by cryptography and consensus nodes.