Slow insert with Transaction?!

[Yakuza_King]

I have a same problem with a SQLite-DB.
When I rollback or commit a transaction, the system keeps busy for 3-4 minutes.
The whole application is frozen at this time.
I'm using a local database.

I think the rollback or commit statement starts a new thread for it's execution. So the function will finish it's work, but before the function returns it waits for the database-thread to finish.

[ChrisW67]

Without more information or an example displaying the issue we cannot really help. If you have inserted or updated 100 million records it is going to take some time to commit or rollback no matter what.

[saa7_go]

I have a same problem with a SQLite-DB.
When I rollback or commit a transaction, the system keeps busy for 3-4 minutes.
The whole application is frozen at this time.
I'm using a local database.

Maybe, this SQLite FAQ explains your problem.