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.
Looking at blocks like the "Featured on this site" block on the front page and the main content view on the group homepage. If we need prev/next style pagers, it'd be nice if we could use views_litepager and avoid the COUNT queries.
IMO it's also a UX improvement as that space looks pretty cluttered as it is.
Comments
Comment #1
msonnabaum CreditAttribution: msonnabaum commentedTo add a bit more data, I initially saw an issue on the /user page, in the "Following" block. It performs this query, which won't scale well as the user table grows:
Let's just avoid the subquery altogether and not have a typical pager there.
Comment #2
ezra-g CreditAttribution: ezra-g commentedThanks! Adding the 'performance' tag.
Comment #3
ezra-g CreditAttribution: ezra-g commentedI switched the Commons Follow User* views to be limited to 16 and user the "view more" pager, eliminating the count query.
http://drupalcode.org/project/commons_follow.git/commit/517ddc5
Comment #4
ezra-g CreditAttribution: ezra-g commentedRe-titling so we can be sure to target the views that are most likely to be subject to paging.
Comment #5
ezra-g CreditAttribution: ezra-g commentedI added Views Litepager to the make file as first step here:
http://drupalcode.org/project/commons.git/commit/82a1d47
Comment #6
ezra-g CreditAttribution: ezra-g commentedBumping priority to "major" so we can address this before 3.0.
Comment #7
ezra-g CreditAttribution: ezra-g commentedhttp://drupalcode.org/project/commons_documents.git/commitdiff/fbcf61e?h...
http://drupalcode.org/project/commons_posts.git/commitdiff/b46c4ae?hp=0a...
http://drupalcode.org/project/commons_wikis.git/commitdiff/5c3ff9a?hp=23...
http://drupalcode.org/project/commons_polls.git/commitdiff/1bb451a?hp=c6...
http://drupalcode.org/project/commons_q_a.git/commitdiff/3e73d17?hp=2a5f...