On 10/30/18, Mark Wagner <[email protected]> wrote: > Going back to the comments from Dr. Hipp regarding WAL vs DELETE mode on > F2FS devices, I just wanted to confirm my understanding. > > Given a device with F2FS and with sqlite compiled with > SQLITE_ENABLE_BATCH_ATOMIC_WRITE, writes with DELETE mode will be > considerably faster than with WAL mode. > > But a relatively long lived transaction that contains a significant amount > of computation with lots of reads and writes would still block reads on > other threads. So WAL could still be the better choice in some > circumstances -- even with F2FS since reads can be happening in parallel. > Am I missing something?
It sounds to me like you understand it. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
