Hi Nikolay,

It's usefull info for people who still support Fox 2.x application. You can mark your message as a solution so it would be easier found in searches.

>Recently Ed Rauh posted FAQ#15468, very useful information about memory usage in old versions of FoxPro and practical guidelines. Here are some practical additions to this article. They are from my experience; you can comment them here. It is possible to find better solutions.
>
>I found that when using Foxpro 2.6 in a Win 32 OS, it is strongly recommended to use MEMLIM command in CONFIG.FP or CONFIG.FPW starting files. The syntax is:
>
>MEMLIMIT = % of available memory, Minimum memory (K), Maximum memory (K)
>
>Why?
>
>FoxPro 2.6 for DOS (extended – 32 bit)
>This version attempts to use all available DPMI memory. For example if you have 512 Mb installed on the computer, without MEMLIMIT, then SYS(1001) – all memory available to the FoxPro memory manager – returns around 350 Mb (depends on other programs running). If this is the only application you are using – OK, but if not… All other FoxPro (DOS/Win) sessions, and other applications also, are going to run very slowly. In some windows versions you can limit maximum amount of DPMI memory (shortcut properties), but on some this not helps. It is useful to add a statement in your CONFIG.FP file, like this:
>
>MEMLIMIT=0,0,20000
>
>After restarting Foxpro, SYS(1001) return about 20 Mb. In FoxPro 2.6 for DOS (extended) you can use for parameter more then 16384, because this is a 32 bit application.
>
>FoxPro 2.6 for Win (16 bit)
>Opposite to DOS version, windows version attempts to use small amount of memory. For example without MEMLIMIT, SYS(1001) returns around 1.3 Mb(!!!). This isn’t dependent on the amount of memory installed in the computer. It is not dynamically increased also. In this environment if you try to execute complex commands, for example to index a table with 1000000 records, you will obtain a “out of memory” error. In same time you have 512 Mb… It is useful to add a statement in your CONFIG.FPW file, like this:
>
>MEMLIMIT=0,16000,0
>
>After restarting Foxpro, SYS(1001) return about 16 Mb. The application works faster and you can run complex commands without memory errors. In FoxPro 2.6 for Win you cannot use more then 16384 for MEMLIMIT parameters, because this version is a 16-bit application. I have made a lot of experimentation, and my recommendation is 16000. If you set for minimum memory, for example 20000, then in complex commands the application hangs.
>
>Best regards,
>Nikolay Petkov

--sb--