We noticed the the tracking state in the data-preloaded is extremely long particularly for trust level 3 or 4 or users who have been active for a long time. Is deleting users’ topic tracking states from the db or alternatively removing or limiting it from the above queries going to do any damage? l…

<a class="lightbox" href="https://global.discourse-cdn.com/meta/original/4X/8/6/4/864cf5d32baef7cca73a4215198a9a12972df5ba.png" data-download-href="/uploads/short-url/ja4RN8NoVxmk8qb9qPzRuk6BpzA.png?dl=1" title="This image displays a performance analysis report detailing the load times for various Ruby on Rails application classes in a Linux command-line interface. (Captioned by AI)" rel="noopener nofollow ugc">[This image displays a performance analysis report detailing the load times for various Ruby on Rails application classes in a Linux command-line interface. (Captioned by AI)] We encountered a similar issue where the query for the topic tracking state consumes approximately 70% of the homepage ren…

exactly! I’ve seen up to 3000ms

I simply remove this line: <a class="lightbox" href="https://global.discourse-cdn.com/meta/original/4X/0/f/7/0f729850b72ed74470c4b7a155fd626a22baae09.png" data-download-href="/uploads/short-url/2cEGcvkaeeOC4Vgz5SmRkUgF5YR.png?dl=1" title="# report = TopicTrackingState.report(@guardian: user) # serializer = TopicTrackingStateSerializer.new(report, scope: @guardian, root: false) serializer = TopicTrackingStateSerializer.new(}${{ scope: '@guardian', root: false }}) hash = serializer.as_json (Captioned by AI)" rel="noopener nofollow ugc">[# report = TopicTrackingState.report(@guardian: user) # serializer = TopicTrackingStateSerializer.new(report, scope: @guardian, root: false) serializer = TopicTrackingStateSerializer.new(}${{ scope: '@guardian', root: false }}) hash = serializer.as_json (Captioned by AI…

مشكلة مع البيانات المحملة مسبقًا تتسبب في تحميل أبطأ بمقدار عشرة أضعاف

دعم المنتج

sok777 (sok) 19 مايو 2025، 8:35ص 4

بالضبط! لقد رأيت حتى 3000 مللي ثانية

الموضوع		الردود	مرات العرض
What be happen to post or topic when we delete it? Product Support	2	1400	2 سبتمبر 2020
App/models/topic_tracking_state - `report` - long response times? Development slow-sql	6	1948	26 فبراير 2016
Performance improvements on long topics? Product Support	29	5856	12 يوليو 2018
Improving Instance Performance (Megatopics, Database Size and Extreme Load) Self-hosting	60	6663	13 أكتوبر 2020
Bulk delete of old and spread topics Product Support	4	598	15 يوليو 2020

مشكلة مع البيانات المحملة مسبقًا تتسبب في تحميل أبطأ بمقدار عشرة أضعاف

الموضوعات ذات الصلة