RépondueEN
Best way to paginate large result sets with cursors in PostgreSQL
· 3 vues
Offset pagination gets slower on page 500. Keyset pagination seems complex with multiple sort keys.
Chargement…
Démonstration : données fictives.Version de démonstration. Les données sont fictives.
· 3 vues
Offset pagination gets slower on page 500. Keyset pagination seems complex with multiple sort keys.
The official docs cover this in the limits section. Also read the repository issues: several contain tested workarounds.
Measure before optimizing. A quick profile usually shows that most of the time is spent in one call. Fix that one first.
Partagez une piste claire et vérifiable.
Votre brouillon est conservé sur cet appareil.