VeljkoMaksimovic
Hi everyone. When running Ecto.insert_all([list_of_maps]) will ecto send one request to DB, or one insert request per map in the list? Looking at DB metrics it seems the second option is happening.
If that’s the case, is there a way to insert a list of a few thousand entities inside one query/transaction?
Thanks in advance
Where Next?
Trending in Questions
Other Trending Topics
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
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #blog-post
- #ai
- #phoenix_html
- #iex
- #elixirconf-us
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
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.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Practical resources that improve the lives of professional developers.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 4- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
kanishka
I am not an expert in Ecto, but you could possibly build up a sql string using “insert” statement with many values clauses.
joey_the_snake
It’s one query. It’s the same as
INSERT INTO table VALUES (...), (...), ..., (...)VeljkoMaksimovic
Thanks. I saw a DB metric called “operations per second”, and it went through the roof (1k+ ops/s) when I executed this
Ecto.insert_all.Now I’m pretty sure that ops/s measures read/write operations, and although Ecto, as you pointed out, generated one INSERT statement, DB had to perform one “write to disk” operation for each entry in the INSERT statement.
joey_the_snake
I think that’s probably what’s happening as well. I have similar metrics where you can see each row being read even if they are not returned by the result. It is helpful finding inefficient queries.