Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Visual FoxPro App runs slower and slower as the day wear
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00154495
Message ID:
00154751
Vues:
17
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform