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
Post a Comment