SQLite Forum

Feature request: add an optional transaction size in mode insert
Login
<code>INSERT INTO table2 SELECT * FROM table1 WHERE TRUE</code>

Does all the inserting in one big transaction.

<https://sqlite.org/lang_insert.html>