#26451: extend Paginator to support infinite pagination and postgres estimated
count
------------------------------+--------------------
Reporter: syphar | Owner: syphar
Type: New feature | Status: new
Component: Core (Other) | Version: 1.9
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
------------------------------+--------------------
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.
--
Ticket URL: <https://code.djangoproject.com/ticket/26451>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/049.bdec0800fc9ce3b507b72cfe6257f895%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
