Float vs Decimal in ActiveRecord

by

I remember my CompSci professor saying never to use floats for currency.

The reason for that is how the IEEE specification defines floats in binary format. Basically, it stores sign, fraction and exponent to represent a Float. It’s like a scientific notation for binary (something like +1.43*10^2). Because of that, it is impossible to store fractions and decimals in Float exactly.

That’s why there is a Decimal format. If you do this: 

irb:001:0> "%.47f" % (1.0/10)
=> "0.10000000000000000555111512312578270211815834045" # not "0.1"!

whereas if you just do

irb:002:0> (1.0/10).to_s
=> "0.1" # the interprer rounds the number for you

So if you are dealing with small fractions, like compounding interests, or maybe even geolocation, I would highly recommend Decimal format, since in decimal format 1.0/10 is exactly 0.1.

However, it should be noted that despite being less accurate, floats are processed faster. Here’s a benchmark:

require "benchmark" 
require "bigdecimal" 

d = BigDecimal.new(3) 
f = Float(3)

time_decimal = Benchmark.measure{ (1..10000000).each { |i| d * d } } 
time_float = Benchmark.measure{ (1..10000000).each { |i| f * f } }

puts time_decimal 
#=> 6.770960 seconds 
puts time_float 
#=> 0.988070 seconds

Answer

Use float when you don’t care about precision too much. For example, some scientific simulations and calculations only need up to 3 or 4 significant digits. This is useful in trading off accuracy for speed. Since they don’t need precision as much as speed, they would use float.

Use decimal if you are dealing with numbers that need to be precise and sum up to correct number (like compounding interests and money-related things). Remember: if you need precision, then you should always use decimal.

More Related Contents:

  1. When should I use double instead of decimal?
  2. Rails extending ActiveRecord::Base
  3. How to change default timezone for Active Record in Rails?
  4. Rails :include vs. :joins
  5. ActiveModel::ForbiddenAttributesError when creating new user
  6. ActiveRecord OR query
  7. Rails 4 scope to find parents with no children
  8. ActiveRecord: size vs count
  9. Rails: How can I set default values in ActiveRecord?
  10. Connecting Rails 3.1 with Multiple Databases
  11. How to express a NOT IN query with ActiveRecord/Rails?
  12. C++ decimal data types
  13. ActiveRecord OR query Hash notation
  14. How to chain scope queries with OR instead of AND?
  15. Combine two ActiveRecord::Relation objects
  16. Rails 5: ActiveRecord OR query
  17. Rails where condition using NOT NIL
  18. Clean way to find ActiveRecord objects by id in the order specified
  19. Rails – Nested includes on Active Records?
  20. ActiveRecord Find By Year, Day or Month on a Date field
  21. Rails 3 SQLite3 Boolean false
  22. find vs find_by vs where
  23. How to skip ActiveRecord callbacks? [duplicate]
  24. How do you write a migration to rename an ActiveRecord model and its table in Rails?
  25. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  26. Can I write PostgreSQL functions on Ruby on Rails?
  27. New data not persisting to Rails array column on Postgres
  28. What is the difference between pluck and collect in Rails?
  29. Changing a column type to longer strings in rails
  30. Ruby BigDecimal sanity check (floating point newb)

Leave a Comment