SQLite Forum

Slow select operation after many times of insert different Table
Login
I have not done the research into Python to gainsay your claim if that is something done by its .executemany() method. But if you refer to what SQLite does, you're mistaken.

It is true that every individual statement is wrapped into a transaction, absent an already-open transaction by the SQLite library. But the automatic transactions are over once the statement executes. Otherwise, COMMITs unpaired with BEGINs would have to appear in code. They do not, at least not without error.