summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMark Felder <feld@feld.me>2022-11-15 12:49:44 -0500
committerMark Felder <feld@feld.me>2022-11-15 12:49:44 -0500
commitd8c112f2b072155cabb53bbf5d6a54fbfc93ccb3 (patch)
tree684c9f19105ad5d92e27ee6a06230461afea2a69
parent0e1356ef9cc8c97afcc3242cfb8182a706c85276 (diff)
Switch to inner joins which are expected to be fasterinner-joins
-rw-r--r--lib/pleroma/activity.ex2
-rw-r--r--lib/pleroma/web/mastodon_api/views/notification_view.ex2
-rw-r--r--lib/pleroma/web/mastodon_api/views/status_view.ex2
3 files changed, 3 insertions, 3 deletions
diff --git a/lib/pleroma/activity.ex b/lib/pleroma/activity.ex
index ebfd4ed45..ea663ee77 100644
--- a/lib/pleroma/activity.ex
+++ b/lib/pleroma/activity.ex
@@ -179,7 +179,7 @@ defmodule Pleroma.Activity do
def get_by_ap_id_with_object(ap_id) do
ap_id
|> Queries.by_ap_id()
- |> with_preloaded_object(:left)
+ |> with_preloaded_object(:inner)
|> Repo.one()
end
diff --git a/lib/pleroma/web/mastodon_api/views/notification_view.ex b/lib/pleroma/web/mastodon_api/views/notification_view.ex
index b5b5b2376..f03269e4c 100644
--- a/lib/pleroma/web/mastodon_api/views/notification_view.ex
+++ b/lib/pleroma/web/mastodon_api/views/notification_view.ex
@@ -36,7 +36,7 @@ defmodule Pleroma.Web.MastodonAPI.NotificationView do
end)
|> Enum.map(&object_id_for/1)
|> Activity.create_by_object_ap_id()
- |> Activity.with_preloaded_object(:left)
+ |> Activity.with_preloaded_object(:inner)
|> Pleroma.Repo.all()
relationships_opt =
diff --git a/lib/pleroma/web/mastodon_api/views/status_view.ex b/lib/pleroma/web/mastodon_api/views/status_view.ex
index b949d8f9a..9e58009d6 100644
--- a/lib/pleroma/web/mastodon_api/views/status_view.ex
+++ b/lib/pleroma/web/mastodon_api/views/status_view.ex
@@ -103,7 +103,7 @@ defmodule Pleroma.Web.MastodonAPI.StatusView do
|> Enum.filter(&(&1.data["type"] == "Announce" && &1.data["object"]))
|> Enum.map(&Object.normalize(&1, fetch: false).data["id"])
|> Activity.create_by_object_ap_id()
- |> Activity.with_preloaded_object(:left)
+ |> Activity.with_preloaded_object(:inner)
|> Activity.with_preloaded_bookmark(reading_user)
|> Activity.with_set_thread_muted_field(reading_user)
|> Repo.all()