Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memory Issues
Message
From
29/08/2017 12:02:26
 
 
To
29/08/2017 11:56:48
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
01653821
Message ID:
01653827
Views:
64
>>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?
>
>Does it help if you restart the SQL service?
>
>Generally it rarely happens in production, but I cause it often when doing conversions, because I do a lot of deletes and inserts, repeatedly, often in megabytes (most of which is blank, but SQL doesn't care), and the memory SQL consumes just grows. It does a lot of magic, but its memory manipulation suffers in the process. Watch it in task manager when you restart the service... you may be surprised.

I didn't try that, but it's a good thought.
I will next time
Thank you
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Reply
Map
View

Click here to load this message in the networking platform