Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Currency data type, BUG or FEATURE?
Message
De
15/03/2006 09:25:03
 
 
À
13/03/2006 13:45:19
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01102959
Message ID:
01104493
Vues:
19
>>>It would be interesting to try with a classic N(n,d) format as well - these would be automatically converted into doubles as soon as they're used in any calculation. My take these would be slower, as they are stored as an ASCII representation, not binary, but the slowness would be only in the field reading or writing, not the actual in-memory operation.
>>>
>>>Also, another interesting thing to test would be just memory operation, i.e. no cursors, no fields, just variables.
>>>
>>>Sounds like I'm giving you homework, uh? :) The reason is that I don't have the time, really - got to try some other things tonight before hitting the road tomorrow.
>>
>>Dragan, N(n,d) is as slow as F(n,d), so it is at the 6th place.
>
>OK, that's good to know.
>
>>I cannot run my test with variables, as it is very difficult to match the number of operations, as my test invloved a mix o several SUM and CALCULATE commands over a 50.000 record table. Besides, you have to test with the m. and without, both affecting the results.
>
>Actually, I think only a m. type of test would be required, because we want other overhead excluded, to measure only the speed of different numeric types under the same conditions. And if the test wouldn't include any tables, there should be no difference with m. and without it.
>
>Still don't have the time... (actually expecting Fabio to do this :).

Dragan, it is quite difficult to test variables versus fields performance, as loops and assignments are different in most cases. You could build tests which do not use SUM, CALCULATE, REPLACE and all those commands with scopes, but in the real life you use them. The kind of operation and uses for variables and fields are not the same, unless you want to compare ADO recordSets (which I guess are similar to arrays) and VFP tables, but I don't have the time now to build a simple test for them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform