トピックリンクカウンターが50で止まる

pfaffman · 2025 年 3 月 30 日午後 2:45

~~Sounds like a bug. Maybe share the link. Maybe look in the code.~~

Looks like it’s limited to 50 on purpose; I guess that it’s a complicated join and having it do hundreds or thousands would be a performance issue.

github.com/discourse/discourse

app/models/topic_link.rb

main


      
          def self.topic_map(guardian, topic_id)
            # Sam: complicated reports are really hard in AR
            builder = DB.build(<<~SQL)
              SELECT ftl.url,
                     COALESCE(ft.title, ftl.title) AS title,
                     ftl.link_topic_id,
                     ftl.reflection,
                     ftl.internal,
                     ftl.domain,
                     MIN(ftl.user_id) AS user_id,
                     SUM(clicks) AS clicks
              FROM topic_links AS ftl
              LEFT JOIN topics AS ft ON ftl.link_topic_id = ft.id
              LEFT JOIN categories AS c ON c.id = ft.category_id
              /*where*/
              GROUP BY ftl.url, ft.title, ftl.title, ftl.link_topic_id, ftl.reflection, ftl.internal, ftl.domain
              ORDER BY clicks DESC, count(*) DESC
              LIMIT 50
            SQL

トピック		返信	表示
Suggestion for fixing the inaccurate link counter value UX member-experience	11	185	2025 年 4 月 30 日
Linkify more than 50 URLs Support	2	428	2023 年 2 月 8 日
Limited amount of Oneboxes for a post? Support onebox	12	428	2024 年 1 月 14 日
Aggregated click number on forum click counter Feature	6	2668	2015 年 3 月 27 日
Links generated by "link summary" feature count towards link count Bug onebox	2	959	2015 年 11 月 7 日

トピックリンクカウンターが50で止まる

関連トピック