#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.

CommentFileSizeAuthor
#2 drupal-1909474-2.patch2.82 KBdawehner
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

dawehner’s picture

So 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.

dawehner’s picture

Status: Active » Needs review
FileSize
2.82 KB

Left out the frontpage view, as I didn't wanted to break the other patch.

damiankloip’s picture

The 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?

dawehner’s picture

If you look at the patch: This one actively not uses the frontpage view, we can do this two patches independent from each other.

damiankloip’s picture

Ah ok, I see, so the /node issue is not going to use the light pager?

dawehner’s picture

Well, 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).

damiankloip’s picture

Status: Needs review » Reviewed & tested by the community

Yeah, this is a good point. Let's just get this in how it is.

webchick’s picture

Status: Reviewed & tested by the community » Fixed

Well that's pretty straight-forward. :)

Committed and pushed to 8.x. Thanks!

Automatically closed -- issue fixed for 2 weeks with no activity.