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.
We have too many forum topic nodes (~160k) so the front page is slow.
Why not add option to remove this column?
This is not fixing #1632260: Performance issues with advanced_forum_statistics_replies but allow for just skip the whole query
Comment | File | Size | Author |
---|---|---|---|
#1 | advanced_forum-1956240-1-hide-latest-activity.patch | 3.96 KB | clemens.tolboom |
Comments
Comment #1
clemens.tolboomThe patch needs work as I haven't figured out how to hide the 'Last post' column yet.
[edit]
On our site having ~160K topics this improves performance from 32628.94 ms to 507.11 ms for the
/forum
page. Just visit the settings page on
/admin/config/content/advanced-forum
to disable statistics 'Latest post' column
Comment #2
helmo CreditAttribution: helmo commentedI see two options to hide the column.
* add a condition to styles/naked/advanced-forum.naked.forum-list.tpl.php
* add some custom css to 'display: none' to class="forum-last-post" and class="forum-last-reply"
Comment #3
Dries ArnoldsGood work. Hope this gets committed. I'll test it shortly.
@helmo, option 1 is the most elegant solution. Hiding with CSS is something that should only be used as a last resort.
Comment #4
podaroknow its fixed
#2222861: Subquery optimization for last commented node
#2219377: Calculating post counts 20+ seconds on large sites
so closing