6 ms·
Does recovery take a long time? Do you have any numbers? I'd have expected recovery to take time proportional to the size of recent/uncommitted transactions, w
by CodesInChaos 6y ago
Does recovery take a long time? Do you have any numbers?
I'd have expected recovery to take time proportional to the size of recent/uncommitted transactions, which should be quick, even for large databases.
- mulander 6y agoI don't have experience with large SQLite databases. I had PostgreSQL take over 40 minutes for recovery on a 2 TB database set to checkpoint every 30 minutes. How long it takes will depend on the WAL size, the frequency of checkpoints and the operations that were performed before a crash/snapshot.