主题链接计数器在50处停止

pfaffman · 2025 年3 月 30 日 14:45

~~听起来像个 bug。或许可以分享一下链接。或许可以看看代码。~~

看起来是故意限制为 50 个；我猜这是一个复杂的连接，如果执行成百上千个可能会导致性能问题。

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 51
            SQL

话题		回复	浏览量
Suggestion for fixing the inaccurate link counter value UX	11	195	2025 年4 月 30 日
Linkify more than 50 URLs Support	2	430	2023 年2 月 8 日
Limited amount of Oneboxes for a post? Support onebox	12	430	2024 年1 月 14 日
Aggregated click number on forum click counter Feature	6	2671	2015 年3 月 27 日
Links generated by "link summary" feature count towards link count Bug onebox	2	962	2015 年11 月 7 日

主题链接计数器在50处停止

相关话题