closed-social
/
mastodon
3
0
Fork 2
Code Issues 5 Pull Requests 0 Projects 0 Releases 3 Wiki Activity
Labels Milestones
New Issue

#10 时间轴展示对自己的转嘟(转评功能)需要性能优化

Open
opened 2 years ago by OmmyZhang · 0 comments
OmmyZhang commented 2 years ago
Owner

当初做这个功能的时候随手写了个join语句，随着目前嘟文数增多出现严重的性能问题，加载时间轴明显比加载主页慢。

https://git.closed.social/closed-social/mastodon/src/branch/closed-social-v3/app/models/status.rb#L92

  • 优化方案1：改表，增加reblog_of_account_id字段
  • 优化方案2：查表的时候直接不过滤转嘟，通过sql外的逻辑去掉非转嘟自己的。由于转嘟占的总量不大，这个方案可能也是可接受的。注意高赞精选会密集转嘟，可能导致加载的一页嘟文全部被过滤掉。
当初做这个功能的时候随手写了个join语句，随着目前嘟文数增多出现严重的性能问题，加载时间轴明显比加载主页慢。 https://git.closed.social/closed-social/mastodon/src/branch/closed-social-v3/app/models/status.rb#L92 + 优化方案1：改表，增加`reblog_of_account_id`字段 + 优化方案2：查表的时候直接不过滤转嘟，通过sql外的逻辑去掉非转嘟自己的。由于转嘟占的总量不大，这个方案可能也是可接受的。注意高赞精选会密集转嘟，可能导致加载的一页嘟文全部被过滤掉。
OmmyZhang added the
enhancement
label 2 years ago
TA referenced this issue from a commit 2 years ago
临时措施 ref: #10
OmmyZhang referenced this issue from a commit 2 years ago
临时措施
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Apply labels
Clear labels
bug
Something is not working duplicate
This issue or pull request already exists enhancement
New feature help wanted
Need some help invalid
Something is wrong question
More information is needed wontfix
This won't be fixed
No Label
bug
duplicate
enhancement
help wanted
invalid
question
wontfix
Milestone
Set milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Assign users
Clear assignees
No Assignees
1 Participants
Notifications
Due Date

No due date set.

Dependencies

This issue currently doesn't have any dependencies.

Write Preview
Loading…
Cancel
Save
There is no content yet.
Delete Branch '%!s(MISSING)'

Deleting a branch is permanent. It CANNOT be undone. Continue?

No
Yes