Re:Many small queries are efficient in SQLite
by ori_b on Tuesday February 16, 2021 @09:50AM
(#26154318)
> (SQLite does this for you automatically, BTW.)
Unless you're on nfs. Remote file locking is hard, and I don't think that any nfs implementation has gotten to the point where you can trust SQLite on it.
SQLite does updates in place, which I would trust far less than a rename call.
Unless you're on nfs. Remote file locking is hard, and I don't think that any nfs implementation has gotten to the point where you can trust SQLite on it.
SQLite does updates in place, which I would trust far less than a rename call.