signal-backup-decode icon indicating copy to clipboard operation
signal-backup-decode copied to clipboard

Run import process inside a SQL transaction

Open ittner opened this issue 3 years ago • 1 comments

Start a SQL transaction before importing the back and commit it at the end of the process. This has no much effect when using in-memory databases, but makes everything really faster when not, as we don't need to persist every individual statement independently.

ittner avatar Apr 23 '21 02:04 ittner

This looks great. I wanted to do that initially but couldn't figure it out properly. I will test this in the next days and hope we can merge that. If this works reliably we can get rid of the in memory db option alltogether 🥳

pajowu avatar Apr 30 '21 11:04 pajowu