This is wonderful. I've begun implementing it in a current project and need to ask about the Query Transaction function.
I was excited to read this comment because one of our current systems takes forever to write to our SQL Server DB. (~30 seconds. I imagine it's executing one SQL INSERT for each step it's reporting.) So, I thought I'd test this in SQLite:
As I played with it I came up with this to see the effect of larger SQL strings:
I've tried each of the locking modes (immediate, deferred and exclusive) but it's taking almost three seconds to complete only 5000 SQL INSERT statements. This is not as fast as the documentation suggests.
What am I doing wrong?