>>>>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.
>
>Hi Dragan,
>
>Thanks for the heads up. I've been wondering how much of an increase in performance in queries could be gained by converting numeric values (where appropriate) to integer and currency types. Haven't done any testing yet, but I will. It would seem to me that using these data types could yield significant improvement, but that's a SWAG also.:-)
How would one convert numeric to integer or currency within a query? Any difference between doing this with native data vice ODBC data?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement