Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance of VFP against itself
Message
From
09/05/2002 04:20:21
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
09/05/2002 03:56:57
Rasheed Al Rasheed
Riyadh Armed Forces Hospital
Riyadh, Saudi Arabia
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00654340
Message ID:
00654342
Views:
18
>In a stable application users normally care most about performance than new features. I have an application with one of the active tables increases by 2000 - 3000 records daily. Currently it is running in VFP5 and I was planing to convert to VFP7. Performance is the deciding factor. I was amazed that the performance 'mainly' queries took in average as follows:
> VFP5 (Sec) VFP7
> 2.13 4.7
> 16.20 24.23
> 4.70 7.83
>The test was done in the same environment for both versions.
>I used diffrerent setup of hardware configuration of PIII and P4 and the results was always VFP7 is slower then VFP5 by about 80%.
>This is a copmelling reason not to upgrade. Where I am going wrong?.
>
>Thanks all.

Rasheed,
Your scores seem to be high for any version. What are the table sizes, field counts, reccounts, CPU and RAM, SQL ?
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform