On 10/30/18, Mark Wagner <m...@google.com> 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
