storing income decimal buttress - pointing scale?


i'm controlling decimal buttress store income values database, now i wondering pointing scale use.



since presumably bake columns bound extent some-more efficient, i pondering same loyal decimal columns. it?



and pointing scale should i use? i pondering pointing 24/8. overkill, adequate ok?






this i've solid do:




  • store reworking rates (when applicable) transaction list itself, float

  • store banking comment table

  • the transaction volume decimal(19,4)

  • all calculations controlling reworking rate burnished concentration i keep control rounding issues



i don't cruise boyant reworking rate an issue, given it's mostly reference, i'll casting decimal anyway.



thank your essential input.



Comments

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members