Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
#1901290: Replace the mini pager with a lite pager (which does not run a count query) adds a 'lite' pager to Views, this only has previous/next links and hence doesn't need to do a COUNT() query. This can in many cases halve the time Views spends querying the db (by halving the queries), so we should just use it by default. It's also a lot tidier.
Lots of sites now use infinite scroll or lite pagers rather than numbers/previous/next/last so this isn't going to be jarring I don't think.
Comment | File | Size | Author |
---|---|---|---|
#2 | drupal-1909474-2.patch | 2.82 KB | dawehner |
Comments
Comment #1
dawehnerSo it should not only be the default to use, but it should also be replaced in all the test views if possible.
There is not only the performance advantage but it actually works more independent of sql, so we might should reconsider the SqlPluginBase naming, but yeah that's out of scope here.
Comment #2
dawehnerLeft out the frontpage view, as I didn't wanted to break the other patch.
Comment #3
damiankloip CreditAttribution: damiankloip commentedThe patch looks fine, but as it's a simple patch that's easy to re roll, maybe we should postpone this on #1806334: Replace the node listing at /node with a view as that is rtbc now?
Comment #4
dawehnerIf you look at the patch: This one actively not uses the frontpage view, we can do this two patches independent from each other.
Comment #5
damiankloip CreditAttribution: damiankloip commentedAh ok, I see, so the /node issue is not going to use the light pager?
Comment #6
dawehnerWell, we can, but as this is a feature change visible on the actual page we might should talk about it (remember, all other default views are just examples that are disabled out of the box).
Comment #7
damiankloip CreditAttribution: damiankloip commentedYeah, this is a good point. Let's just get this in how it is.
Comment #8
webchickWell that's pretty straight-forward. :)
Committed and pushed to 8.x. Thanks!