>1st... in the setup you describe, using terminal services is a big waste of money and resources.
It was not my decision to use terminal services, but AFAIK it was made to improve security...
>To help with your problem, limit the memory the vfp app uses for each workstation.
how?
>Then make each user have a separate temporary directory. One way to do that is to map a user directory to a local drive and in the config for your app, point your temporary work area to that drive.
Yes, it was first thing which I did, I used SYS(2023)...
>
>You also need to ensure that this server has a LOT of ram... at least 4gb.
>
I saw 2gb on the server...
>
>>Hello,
>>
>>There was small office with 8 PC with Windows XP OS.
>>One PC had shared directory with VFP database, VFP program on other PC was accessing that data via network mapped disk. Everything worked fine.
>>
>>Now situation changes dramatically:
>>all PCs were replaced with workstations whose are connecting to Windows 2003 server via terminal services and running VFP program on it.
>>Seems that program should work faster than before. But after some days VFP program started to retrieve data from database (on the same disk) slower than before and it is getting slower... until we restarted server - now program works very fast.
>>I assume, that there is problems with memory managing, but I haven't any experience with it.
>>Can anybody help me?
>>
>>Thanks in advance,
Giedrius