SQLite Forum

Slow insert with prepare/step
Ah OK... thanks. I actually looked for dedicated begin/end transaction functions, couldn't find any and assumed it's a single transaction from prepare to finalize.

So I just need to do separate execs for BEGIN and COMMIT before and after, is it the right way to do it?