My understanding is that a update is the same as an insert. So I would think delete+insert is a bad idea. Also insert+delete would put 2 entries in the commit log. On Sep 10, 2014 9:49 AM, "Michal Budzyn" <michalbud...@gmail.com> wrote:
> Is there any serious difference in the used disk and memory storage > between upsert and delete + insert ? > > e.g. 2 vs 2A + 2B. > > PK ((key), version, c1) > > 1. INSERT INTO A (key , version , c1, val) values (1, 1, 4711, “X1”) > ... > 2. INSERT INTO A (key , version , c1, val) values (1, 1, 4711, “X2”) > Vs. > 2A. DELETE FROM A WHERE key=1 AND version = 1 AND c1=4711 > 2B. INSERT INTO A (key , version , c1, values) values (1, 1, 4711, “X2”) > >