Hi Bernard,

I can't see why your app behaves like that. It is rather odd. Most of our apps run on TSE/Win2K with Citrix installed on top and we got this problem only when our data reached 9 million records (1.75GB). We used a combination of REINDEX/SYS(3050)/SYS(1104) to help optimize the app.

I assume the DROPDOWN data is a SELECT-SQL; try using just Values and see how it performs. Also, if you're not using it already, set TEMP to a subfolder under the EXE using a CONFIG.FPW file.

Were the figures reported on a TSE client running the app or at the server itself being monitored by IT. Had you have the chance to compare the figures between the two. Is Citrix installed on TSE?

HTH.

>Hi Ramil
>
>Yes I looked at SYS(3050)
>
>Actually the way I measured the memory was to add a text box to my main form to show the result of SYS(3050,1) and a command button. Clicking the command button allowed me to enter a value into an INPUTVBOX() and then I ran SYS(3050,1,VALUE FROM INPTUBOX()).
>
>This displayed approximately correct figures as mentioned in the help file. But these figures were nowhere near that reported by NT Taskmanager.
>
>For instance when I reduced the foreground memory to 1000k, SYS(3050,1) returned 786 but Taskman showed 4000k!
>
>When I minimizes the app it dropped to 1765k. On restoring it went to 2050.
>When I just clicked on a DROPDOWN LISTBOX, taskman reported a jump to 6000k.VFP reported no change!
>
>This is totally inconsistent with the results reported by SYS(3050) which still reported 768k.
>
>We have a large amount of Physical ram but also a number of users (30+)so that is the concern.
>
>
>
>>We are using NT TSE as well. The SYS(3050) really helped us dramatically improve the SQL calls. However, based on VFP help file, SYS(3050) is usefull if there is a large amount of physical RAM (1 GB+). This will actually limit VFP's usage of memory to the setting set by SYS(3050,1,nnnnn). Try setting it to 10MB/8MB.
>>
>>Using SYS(1104), not sure if this is VFP 7+ only, at certain key parts of the app like before or after running a long process.
>>
>>Lastly, if possible, put the EXE and Data on the same drive.
>>
>>HTH.