Hi All.

I have a client who has been running a Visual Foxpro application that I wrote for him since 2005. He tells me that occasionally, parts of the program slow to a crawl. The place where he notices this the most is when he is importing files. Some of these tables can get rather large and the information in these tables is checked against records in lots of other tables as they are being processed. He also says that when this occurs, the VFP application's use of memory spikes.

The goofy thing is that the problem will mysteriously disappear and the system will be as zippy as ever for 8 months or so and then the problem occurs again for no apparent reason.

He re-booted his server and it did not make any difference.

BTW, the application is being run using Terminal Server.

Anyone ever experience anything like this?

TIA