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 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 commentedThanks! Adding the 'performance' tag.
Comment #3
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 commentedRe-titling so we can be sure to target the views that are most likely to be subject to paging.
Comment #5
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 commentedBumping priority to "major" so we can address this before 3.0.
Comment #7
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...