בעיה עם הנתונים הטעונים מראש הגורמת לטעינה איטית ב-10 פעמים

תמיכה
1

שמנו לב שסטטוס המעקב ב-data-preloaded הוא ארוך מאוד, במיוחד עבור רמת אמון 3 או 4 או משתמשים שהיו פעילים זמן רב.

האם מחיקת מצב המעקב של הנושאים של המשתמשים מבמסד הנתונים או alternatively הסרתו או הגבלתו מהשאילתות שלמעלה יגרום לנזק? כמו שלקחת להם את הדרגות או רמות האמון שלהם וכו’.

3

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)
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)1958×566 108 KB

We encountered a similar issue where the query for the topic tracking state consumes approximately 70% of the homepage rendering time. Under high load conditions, this query can even take over 1000 ms to complete.

I think there should be an (optional) approach to make the topic tracking state an asynchronous request, thereby enabling users to view the homepage more swiftly.

לייק 1
4

בדיוק! ראיתי עד 3000ms

5

I simply remove this line:

# 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)
# 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)1929×185 43.7 KB

After examining the frontend code, I surmised that my actions might have potentially caused certain issues. However, in practice, upon removing that line and reloading the server, I observed no significant differences, and the load time of my homepage was reduced by approximately 60%.

This serves as a small piece of experiential knowledge for those facing similar performance challenges. Nonetheless, I cannot guarantee the consequences of this action, so proceed at your own risk.

6

אני רואה את אותה התנהגות