VeljkoMaksimovic
Question about Ecto insert_all
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
Most Liked
joey_the_snake
It’s one query. It’s the same as INSERT INTO table VALUES (...), (...), ..., (...)
kanishka
I am not an expert in Ecto, but you could possibly build up a sql string using “insert” statement with many values clauses.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
The deployment platform built for Elixir: PaaS ease, VPS control.
Categories:
Sub Categories:
Forums
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.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"