undefined | Better HN

story

0 pointsCodesInChaos10d ago0 comments

How does better normalization reduce the need for explicit transactions?

0 comments

The need to change two separate tables atomically means that you probably have info duplicated. Also it can be non-ideal in a web backend cause it means keeping DB connections open longer.

frollogaston9d ago

Sorry ignore the second sentence, I meant keeps the connection checked out of the pool longer, but also it has nothing to do with normalization.

j / k navigate · click thread line to collapse

0 comments

frollogaston10d ago

The need to change two separate tables atomically means that you probably have info duplicated. Also it can be non-ideal in a web backend cause it means keeping DB connections open longer.

frollogaston9d ago

Sorry ignore the second sentence, I meant keeps the connection checked out of the pool longer, but also it has nothing to do with normalization.

j / k navigate · click thread line to collapse