Improve social friend's activity query
Activity
Show:
EdG March 14, 2013 at 4:27 PM
FormerComponentSocial03142013EG
Michael Saechang June 28, 2012 at 3:02 PM
Committed on:
Portal 6.1.x CE GIT ID: 2ec26e2a47576555e218f5f7d452f332d806485b.
Portal 6.2.x GIT ID: b3cd18324b0663a0fc8422bb6ec24daac713afdb.
Fixed
Details
Assignee
Michael SaechangMichael Saechang(Deactivated)Reporter
Amos FongAmos FongBranch Version/s
6.1.xBackported to Branch
CommittedGit Pull Request
Components
Affects versions
Priority
Medium
Details
Details
Assignee
Michael SaechangReporter
Amos FongBranch Version/s
6.1.x
Backported to Branch
Committed
Git Pull Request
Components
Affects versions
Priority
MediumZendesk Support
Linked Tickets
Zendesk Support
Linked Tickets
Zendesk Support
Linked Tickets
Created June 7, 2012 at 11:56 PM
Updated June 24, 2023 at 4:01 PM
Resolved June 8, 2012 at 12:44 AM
Improve social friend's activity query (mainly used in friend's activities portlet).
Removing distinct because it makes the query slower and is not needed because there is a unique index on SocialRelation(userId1, userId2, type_) anyway.