Thanks a bunch,

that's exactly what I was looking for.


Have a nice day,


Yanick

>MEMLIMIT is ignored in VFP. You can use SYS(3050) instead.
>
>>Hi,
>>
>>We are faced with the following problem,
>>
>>We have a Server [with a Gb of RAM] our users run VFP thru Terminal service on that server and are issuing various queries, etc... The server have other applications that also gets ran thru TS by other users... but when the SELECTs or REPLACE are ran [we're dealing with 1 million+ records] all other apps gets VERY slow... any other instance of VFP ran on the server gets slow as well.
>>
>>We looked at the ressources the VFP7 process is using and found out that it nearly takes up the Gigabyte available. Leaving next to nothing for the other processes.
>>
>>I've tried putting MEMLIMIT=0,0,30000 in the CONFIG.FPW located in VFP folder on the server but with the same result...
>>
>>Anyone have an idea on how we could restrict the amount of memory VFP will use?
>>
>>Thanks in advance,
>>
>>Yanick