top | item 32308665

(no title)

elsurudo | 3 years ago

Makes sense, but I can't help but feel it's a solution at the wrong abstraction level. It's a shame the DB can't figure this out for you.

discuss

yccs27|3 years 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|3 years ago

wouldn't that break the atomic and isolated rule of ACID?

cryptonector|3 years ago

The DB could figure it out IF it had monoid counter type to use as the column's type.