Hello, what’s the difference in performance between Repo.one and Repo.all?
please see my following code
Repo.one
defp fetch_posts_by_alias(post_alias, "admin") do
query = from p in Post,
join: c in assoc(p, :cms_post_category),
where: p.seo_alias_link == ^post_alias,
order_by: p.inserted_at
query = admin_fields(query)
Repo.one(query)
end
Repo.all
defp fetch_posts_by_alias(post_alias, "admin") do
query = from p in Post,
join: c in assoc(p, :cms_post_category),
where: p.seo_alias_link == ^post_alias,
order_by: p.inserted_at
query = admin_fields(query)
Repo.all(query)
end
both of them load one result from database.
Thanks.