Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Currency data type, BUG or FEATURE?
Message
From
13/03/2006 13:45:19
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
To
11/03/2006 08:00:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01102959
Message ID:
01103880
Views:
22
>>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 :).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform