>>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.