Opened 9 years ago

Last modified 8 years ago

#26451 closed New feature

extend Paginator to support infinite pagination and postgres estimated count — at Version 3

Reported by: Denis Cornehl Owned by: Denis Cornehl
Component: Core (Other) Version: 1.9
Severity: Normal Keywords:
Cc: Johannes Maron Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description (last modified by Denis Cornehl)

We often have problems with bigger tables and slow count(*) performance.

depending on the use-case there are two ways to improve the situation

  • just work without count, if you never show the page-count. Then the paginator can just return empty results if the end is near.
  • use rough estimations for the page-count, perhaps with some security margin. For example PostgreSQL supports this by using EXPLAIN, based on the table statistics.

I want to

  • extend the paginator to support both (infinite and estimate)
  • provide an option for ModelAdmin that let's you use the estimation-paginator.
  • or perhaps even support the infinite-paginator, this would also include interface changes to the pagination.

Change History (3)

comment:1 by Denis Cornehl, 9 years ago

Description: modified (diff)

comment:2 by Denis Cornehl, 9 years ago

Triage Stage: UnreviewedAccepted

setting triage to accepted after discussion with Russell Keith-Magee

comment:3 by Denis Cornehl, 9 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.
Back to Top