Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Application Slows To A Crawl
Message
 
To
30/11/2000 03:37:04
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00447225
Message ID:
00447230
Views:
16
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform