pleroma

commit: cf139b06a3761983f877ac0dd5839689485cae94
parent: 3601c0015cd9537c75c476943d148a1063c237b8
Author: rinpatch <rinpatch@sdf.org>
Date:   Tue, 26 May 2020 16:33:13 +0000

Merge branch 'fav-speedup' into 'develop'

Fix favorites query performance

See merge request pleroma/pleroma!2591
Diffstat:
M
lib/pleroma/activity/queries.ex
5
+----

1 file changed, 1 insertion(+), 4 deletions(-)
diff --git a/lib/pleroma/activity/queries.ex b/lib/pleroma/activity/queries.ex
@@ -24,10 +24,7 @@ defmodule Pleroma.Activity.Queries do
 
   @spec by_actor(query, String.t()) :: query
   def by_actor(query \\ Activity, actor) do
-    from(
-      activity in query,
-      where: fragment("(?)->>'actor' = ?", activity.data, ^actor)
-    )
+    from(a in query, where: a.actor == ^actor)
   end
 
   @spec by_author(query, User.t()) :: query