I have some values like 3/5, 90/100 etc.
I have to store these values in separate columns in my database.
I am confused as to which datatype to use for this purpose; which is faster for insert
and select
operations?
Two integers; Numerator and denominator. Insertion/storing will be pretty much the same speed for any data type which provides a reasonable representation of a fraction.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With