Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Application Slows To A Crawl
Message
 
À
30/11/2000 03:37:04
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00447225
Message ID:
00447230
Vues:
8
Change your interval. I'm sure it takes a good second or so for the COM server to do it's stuff. What seems to be happening is that you're getting a build-up of calls to the COM server. Does it really need to do this every second? Can it do a poll every minute (or even 30 seconds). Any delay in the COM/OLEDB will generate a lag. Do some time testing to see how long it takes at it's slowest and set your timer interval greater than the resultant time.

>Hi All:
>
>Have an application that polls a COM server (on the local machine) every second. The COM server then retreives RecordSets or Strings from SQL SERVER 7 (stored procedures), via OLEDB, every second.
>
>My problem: The application runs fine at first. However, when I leave it running over night, the polling is no longer every second but every 3~4 seconds (despite it's timer interval at 1 second), the mouse works but the hour glass persists, and clicking on buttons takes a long time to register: about a minute.
>
>What could be happening here?
>
>TIA
>
>Mal
Nigel B Coates
NBC Software Services
Dublin, Ireland.
eMail: Nigel.Coates@NBCSoftware.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform