Ria,
On Win2k, you'll want to use SYS(3050,1,VAL(SYS(3050,1,0))/3) to make sure your app is only using 1/3 of available memory. otherwise it will hog memory to the point of lockups.
If you have a processor intensive loop, put a Sleep(0) in it so other processes have a chance to run too.
>Hi,
>How do we improve FoxPro performance- like making sure that FoxPro has enough memory to execute.
>When dealing with large volumes of data, what are the optimum settings?
>
>I have a program that delas with large volumes of data, it deletes the index tags, modifies certain fields in each record and recreates the index tags. It runs into this error - "SPMON" error.
>
>Please give me all the help you can.
>
>Ria