>Hi,
>
>I'm wanting to limit the total memory used by a VFP app to a certain amount, let's say 64Mb.
That might be quite detrimental to perf.
At LEAST do it in a way depending on the actual
installed RAM and the curent memory situation.

>Now the question: there is a way to effectively limit the total amount of memory used?
As I could understand SYS(3050) won't do it.

SYS 3050 works splendid for selects and so on.

If you are NT-based, you can trim back the memory
(minimize the apps window) or call

DECLARE INTEGER GetCurrentProcess IN kernel32 
Declare INTEGER SetProcessWorkingSetSize IN kernel32  ;
   INTEGER hProcess, INTEGER lpMinimumWorkingSetSize, INTEGER lpMaximumWorkingSetSize 
= SetProcessWorkingSetSize(GetCurrentProcess(), 128*1024*1024, 128*1024*1024)

But Windows will do it's own thing further on...

AFAIK in Server 2003 there is a lockable SetProcessWorkingSetSize[Ex??],
read a bit in MSDN...

HTH

thomas