Did you try to limit the size of VFP buffers?

SYS(3050, 1, 128*1024*1024)
SYS(3050, 2, 128*1024*1024)

>Hi all,
>
>Got a bit of an issue running some of our applications on Terminal Server.
>The kit is a multi processor Xeon with 8Gb ram, and can have 25+ users connected running a VFP app sharing data currently on the same machine.
>
>All reg hacks have been made etc, and the IT people who are supposed to know about these things have checked the TS configuration.
>
>However, when some of the apps run large queries/views the amount of Ram used by the application shoots up from approx 30Mb to 150Mb. Fair enough, perhaps the cacheing/buffering kicks in. Unfortunately this does not appear to get released wvwn when the cursor is recreated with a much smaller dataset.
>
>Once this happens to a large number of users, performance degrades exponentially, as if the OS was swapping out to the hard drive.
>Given the amount of Ram, I dont see why this is happening, and I have no idea how to recover that Ram from within VFP. Before anyone says anything, Yes we do use Sys(1104) extensively.
>
>Someone has also informed we that VFP cannot address the memory beyond 4Gb under these circumstances, though I can find nothing on the web to support this claim.
>
>Regards
>
>Malc