Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
About Currency data type?
Message
 
To
23/09/1999 11:24:50
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00266701
Message ID:
00268524
Views:
23
Hi Dragan,

That "significant improvement" doesn't exist. I converted a table with 50,000+ records, then ran the same query against it and the original. The query took the 50,000+ and SUM()med a number of fields into 3 records. I ran it a dozen times, stored the elapsed times, and threw out the high and low results. The final outcome: With converted fields, average elapsed time 1.89 seconds. Without converted fields, average elapsed time 1.22 seconds. Three (acutally less) whole hundredths of a difference.
George

Ubi caritas et amor, deus ibi est
Previous
Reply
Map
View

Click here to load this message in the networking platform