Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Incredible performance degration behaviour
Message
From
13/01/2005 18:57:50
 
 
To
13/01/2005 14:50:03
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
00976753
Message ID:
00977000
Views:
34
Hi, Walter,

You're right, VFP9 is even slower. I've run this 30 times in a loop and calculated the penalty for each line. The "100.000 replacements" line in 100 tables area has the most important penalty: 55% increase.


>Fabio,
>
>I've tested this in VFP6 to VFP9 and the general conclusion is that from VFP6 on, each version seemed to get slower. I even ran a test on FPW 2.6. It was certainly slower in two tables but a hell lot faster with 100 tables.
>
>Also, from my tests, it seems that using an ID in stead of the alias is about twice as fast in VFP8 and even quicker in VFP7.
>
>Walter,
Grigore Dolghin
Class Software.
Previous
Reply
Map
View

Click here to load this message in the networking platform