>>Is it true that calculations with Currency fields are faster than with numeric fields?
>
>Hi Christian,
>
>Part of this is a SWAG. I assume that currency fields are stored as a double precision eight byte floating point. This means that it'll have to be converted for display, but not for calculations. Numeric values are stored in the table as character. There's no need to convert for display, but they do have to be converted for calculations.
Currency field is a quad integer, and gets divided by 10000 for display and conversion purposes, and due care is taken when multiplying and dividing. That makes it really fast.