SQLite Forum

Feature request: add an optional transaction size in mode insert
Login
Thanks for this hint, that I didn't know.  However, my use case is more about transferring data between databases.

Anyway, I may want it in smaller chunks. If I have a table with millions of entries, I may prefer to do break it.

My suggestion is a very simple addition that facilitates this use case always, without having to use external scripting tools, that not everybody is able to use or not all environments have.  I can, but I'm thinking from usability point of view at large.