SQLite Forum

Slow select operation after many times of insert different Table
Login
See [Transaction](https://sqlite.org/lang_transaction.html), and links therein. Example:<code>
BEGIN TRANSACTION
INSERT INTO MyTable ...
-- many more inserts
COMMIT TRANSACTION
</code>

Try it -- you'll like it!