diff options
| author | Eugen Rochko <eugen@zeonfederated.com> | 2020-12-07 12:08:30 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-12-07 12:08:30 +0100 |
| commit | 48bef17cc990afda95c4de657f7643c321e62650 (patch) | |
| tree | 01636821b1bbf46667e625bd842ee0bde65470d8 /app/controllers/admin | |
| parent | a8c471fcc043b61aa10cf8f849dfb552db7381d3 (diff) | |
Fix slow distinct queries where grouped queries are faster (#15287)
About 2x speed-up on inboxes query
Diffstat (limited to 'app/controllers/admin')
| -rw-r--r-- | app/controllers/admin/statuses_controller.rb | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/app/controllers/admin/statuses_controller.rb b/app/controllers/admin/statuses_controller.rb index 650195034..d7c192f0d 100644 --- a/app/controllers/admin/statuses_controller.rb +++ b/app/controllers/admin/statuses_controller.rb @@ -14,7 +14,7 @@ module Admin @statuses = @account.statuses.where(visibility: [:public, :unlisted]) if params[:media] - account_media_status_ids = @account.media_attachments.attached.reorder(nil).select(:status_id).distinct + account_media_status_ids = @account.media_attachments.attached.reorder(nil).select(:status_id).group(:status_id) @statuses.merge!(Status.where(id: account_media_status_ids)) end |