Intermittent screen freezes in VFP application run over a network

[ScottBrush]

I'm supporting a VFP application that is being run over a network. My users have been experiencing intermittent screen freezes lasting 1 -2 minutes. No errors are being reported by VFP or the app. Does anyone have any idea as to what could be causing this problem?

 

[audiopro]

Is other network traffic affected or just VFP?

Keith

http://www.studiosoft.co.uk

 

[Dan Freeman]

Nobody will have any idea without more information.

Does it always freeze at the same place in the application? What is the user doing when the freeze happening?

 

[mmerlinn]

Could be any number of reasons for freezing.

The most common reason I have found is insufficient memory to do the job needing to be done, so the program 'hangs' while it does garbage collection to free up space. This seems to usually be caused by tables/cursors/arrays too large for the available memory, although there could be other causes outside of FoxPro clogging memory and/or processor time.

If FoxPro is the culprit, you might look for excessively large tables being processed in memory. If found, then a rewrite of the table processing code might be in order where you only work on a small portion of a table each time instead of the whole table.

mmerlinn

http://mmerlinn.com

Poor people do not hire employees. If you soak the rich, who are you going to work for?

"We've found by experience that people who are careless and sloppy writers are usually also careless and sloppy at thinking and coding. Answering questions for careless and sloppy thinkers is not rewarding." - Eric Raymond