Changes between Version 77 and Version 78 of DatabaseBasedAnalysis


Ignore:
Timestamp:
08/06/18 16:52:01 (6 years ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DatabaseBasedAnalysis

    v77 v78  
    774774== Optimization and precision maths ==
    775775
    776 A very interesting read is https://dev.mysql.com/doc/refman/5.7/en/precision-math.html (and its sub-sections: Click on ''Next'').
     776A very interesting read is https://dev.mysql.com/doc/refman/5.7/en/precision-math.html (and its sub-sections! Click on ''NEXT'').
    777777
    778778In short: A value like 1.234 is an ''exact'' value and exact math calculation are performed. If a value is given as an approximate ''floating-point'' value (which all '''DOUBLE''' columns are), for example 1.234e0, the calculation is ''not exact''. ''Not exact'' means that it using (faster) ''floating-point'' arithmetic rather than (slower) ''exact'' arithmetic.