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

pfaffman · 2025年三月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 fixed	11	392	2025年四月30日
Linkify more than 50 URLs Support	1	490	2023年二月8日
Limited amount of Oneboxes for a post? Support onebox	12	587	2024年一月14日
Links generated by "link summary" feature count towards link count Bug onebox	2	1010	2015年十一月7日
Topic-map-summary only shows the likes of the first post Bug	4	1234	2016年四月6日

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

相關主題