On Sat, 2017-12-30 at 05:40 +0000, Simon Slavin wrote: > Accumulate your change commands in memory as text. Eventually > execute them all inside BEGIN … COMMIT.
I like it; why didn't I think of it? Don't you love those moments? The application would need severe retooling for reads unless I also have duplicate memory versions of the table state, but it is a solution. With this scheme you could also load the entire db into memory without the expense of having to dump the entire db to disk at "checkpoints". _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
