Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memory Issues
Message
From
29/08/2017 12:22:58
 
 
To
29/08/2017 11:17:46
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
01653821
Message ID:
01653829
Views:
73
>I don't do much VFP work anymore, but for the past few days I've been working on a VFP/SQL Server application that involves a lot of Excel automation.
>Several times I got messages saying the computer is running low on memory (I have 16GB and tons of disk space with Win 10) and several times I had to reboot because everything was running slowly.
>I don't have these issues when doing .NET or PHP work.
>It might have nothing to do with VFP, but are they any known issues?

Start Task Manager and watch how many instances of Excel you start. My rule of thumb is that for every Createobject('Excel.application') there should be a matching Release command. The same goes for variables which hold a reference to Excel or parts of it. Keep in mind that these Release commands must be in the opposite order as the instantiation /happens.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform