undefined | Better HN

0 pointsfrollogaston1mo ago0 comments

If you find yourself doing a lot of explicit transactions, it can be a sign that your schema isn't as normalized as it should be.

0 comments

3 comments · 1 top-level

CodesInChaos1mo ago· 2 in thread

How does better normalization reduce the need for explicit transactions?

frollogastonOP1mo 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.

frollogastonOP1mo 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