spacebat
Avoiding extra queries in belongs_to relationship management
I have an update action on an Ash resource that manages a belongs_to relationship:
change manage_relationship(:business, type: :append_and_remove)
I’ve noticed that when the attributes and relationship arguments passed in to the update action result in no change - no SQL update - multiple SQL select queries run anyway to check the relationships.
How might I side-step the relationship management when the foreign key is not changing, so that the relationship management queries are skipped?
Marked As Solved
zachdaniel
Hm…seems like maybe something that it should be doing by default. But in terms of how you can do it yourself, your best bet would be switching to a custom change, like:
change fn changeset, _ ->
new_business_id = changeset.arguments[:business_id]
if new_business_id && new_business_id != changeset.data.business_id do
Ash.Changeset.manage_relationship(changeset, :business, ....)
else
changeset
end
end
Popular in Questions
Other popular topics
Latest Ash Threads
Latest on Elixir Forum
Sponsor Spotlight
We build reliable cloud platforms for business-critical systems.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Practical resources that improve the lives of professional developers.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"