Mysql – Which data type to use to store fractions?


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?

Best Solution

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.