Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Visual FoxPro App runs slower and slower as the day wear
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00154495
Message ID:
00154751
Views:
16
>I have written an app for a customer that runs fast at the beginning of the day ... reports, screen updates, all run fine. As the day progresses, the application runs slower and slower and printing often slows to a crawl displaying the hour glass on the screen.
>
>If the user exits the application and shuts down the computer and starts it up again, the application is back up to speed.
>
>Anyone have any suggestions?

I 've seen this, too. A couple things from experience:

1) Repeated report running has caused trouble in FP in the past, maybe check out KB articles on this...

2) I've had trouble with an app slowing to a crawl after several hours in both vfp5 & 6, and posted thread about it a while back. One idea from that that helps is to periodically do a CLOSE TABLES ALL, if that's possible.

The other thing which has totally resolved my problem is to remove all SCAN, FOR, and WHILE loops which are run many times. By converting them all to SQL (even awkward, non-optimized) there is no longer any slowdown at all, even after running over 24 hours. (Don't ask me why, I can't guess :)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Reply
Map
View

Click here to load this message in the networking platform