working of insert_many vs multiple single inserts

[vikigenius]

I want to know about the optimization of insert_many. How is it implemented? Does it work as a single insert with multiple values like SQLITE allows

INSERT INTO 'tablename' ('column1', 'column2') VALUES
  ('data1', 'data2'),
  ('data1', 'data2'),
  ('data1', 'data2'),
  ('data1', 'data2');

or does it work as multiple insert statements, which is presumably slower?

[billy1624]

Hey @vikigenius, just like what you have said. insert_many will construct SQL statement like that. And it will be sent to the database once only.

sea-orm/src/entity/base_entity.rs

Lines 384 to 406 in 6120d82

	/// let apple = cake::ActiveModel {
	/// name: Set("Apple Pie".to_owned()),
	/// ..Default::default()
	/// };
	/// let orange = cake::ActiveModel {
	/// name: Set("Orange Scone".to_owned()),
	/// ..Default::default()
	/// };
	///
	/// let insert_result = cake::Entity::insert_many(vec![apple, orange])
	/// .exec(&db)
	/// .await?;
	///
	/// assert_eq!(insert_result.last_insert_id, 28);
	///
	/// assert_eq!(
	/// db.into_transaction_log(),
	/// vec![Transaction::from_sql_and_values(
	/// DbBackend::Postgres,
	/// r#"INSERT INTO "cake" ("name") VALUES ($1), ($2) RETURNING "id""#,
	/// vec!["Apple Pie".into(), "Orange Scone".into()]
	/// )]
	/// );