Pagerfanta icon indicating copy to clipboard operation
Pagerfanta copied to clipboard

Add support for performant "mini" pagers

Open dawehner opened this issue 10 years ago • 0 comments

In order to avoid the potential count query for pagers the Drupal project uses a common pattern since quite a while which allows you to skip the count query in the first place.

The basic idea is to query always for one more item than you want. If there is one more item, we know that there is another page, otherwise there is none.

This can be a huge performance boost for big sites.

Do you plan to provide support for such a pager?

Tbh. I haven't used pagerfanta to be able to suggest anything but it seems to be that we could split up the adapter interface into one providing count and one without count. This then would require quite some work on the View side as well.

dawehner avatar Aug 12 '14 21:08 dawehner