4 ms·

Yeah, it seems like it would be possible for the DB engine to aggregate all these increments into one update. If you have two increments by one each in the queu

by yccs27 4y ago

Yeah, it seems like it would be possible for the DB engine to aggregate all these increments into one update. If you have two increments by one each in the queue, why not make it a single increment by two? I'm not sure though how much computing power it would need to figure that out...

LesZedCB 4y ago
wouldn't that break the atomic and isolated rule of ACID?
- samatman 4y ago
  Not necessarily. If both updates are in a single transaction then it's valid for the query planner to batch them, although that seems unlikely in the use case this table layout is designed for.
  - deleted 4y ago
    [deleted]
- MauranKilom 4y ago
  Not any more than the slotted counter pattern...
  - LesZedCB 4y ago
    how does the shape of data impact the storage applications safety contract?