Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow save in VFP9 comparing with VFP8
Message
From
27/05/2005 02:26:06
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01015381
Message ID:
01018027
Views:
12
>>We're using MereMortals framework. We switched to VFP9 few days ago. We have one complicated form with lots of Business objects. When we save data in VFP8, it happens quickly. If we do the same in VFP9, it takes almost a minute to save.
>>
>>Nadya,
>>
>>I bandwagon for developer built frameworks and advocate xBase over table buffering. Thats the only way to build a fast interface.
>>
>>As you may be aware of, general purpose off the shelf frameworks are, by nature, slow (and fat). Add to this the fact that table buffering (rather than xBase [seek and replace]) services file transactions, only slows it more.
>>
>>Even the noticed "better" performance in VFP 8 would seem [very] slow when compared to the performance of a shop [built] specific framework and xBase.
>>
>>They have you on the team! They have an oppertunity to build a high performance app!:-)
>
>
>Not sure, what point you were trying to make. MereMortals is a good framework, I like it.
>
>Jim found, that the problem was with the FLUSH FORCE command. He thought, it was in MereMortals. However, it's me who added this command. And today I figured, that I should not have add this command in the Save method of business object. So I'm going to remove it.
>
>In other words, I unadvertenly introduced this problem myself. However, we now learnt to be cautious using FLUSH FORCE command.

Just out of interest, how did you eventually find that particular line of code was the problem? Did you run the Coverage Profiler?
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform