When database has a lot of users and posts mail page of the forum and all count calculates become very slow 20+ seconds for queries
Caching is the solution
Patch attached

CommentFileSizeAuthor
adv_hiload.diff970 bytespodarok
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

podarok’s picture

podarok
🇺🇦 he/him/his
Primary language Ukrainian
Location Ukraine
CreditAttribution: podarok commented

Related
#2222861: Subquery optimization for last commented node

  • Commit 0740ed6 on 7.x-2.x by podarok: 
    Issue #2219377 by podarok: Calculating post counts 20+ seconds on large...
podarok’s picture

podarok
🇺🇦 he/him/his
Primary language Ukrainian
Location Ukraine
CreditAttribution: podarok commented
Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

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