Keith Thompson wrote:
What is the preferred way of storing a dollar amount in the range
0.00 - 9.99?
double
decimal(11,2)
bigint (storing value*100)
...?
I'm more interested in speed of use as an indexed column (especially
for range searches) than in disk space usage.
bigint
What is the preferred way of storing a dollar amount in the range
0.00 - 9.99?
double
decimal(11,2)
bigint (storing value*100)
...?
I'm more interested in speed of use as an indexed column (especially
for range searches) than in disk space usage.
-keith
--
MySQL General