To those that responded to my questions about performance I want to say thank you.
I took the time to TRACE about 70 programs that update my database each morning. I identified 2 issues that were apparently causing things to slow down. One was the old "hanging continuation character" problem and the other was a program that was basically dealing with a lot more data than it needed to. I fixed these problems and made a few other enhancements while I was at it. Additionally, I have a small program named ENV_SET.PRG that ensures that certain environment settings are in place each time I connect to my database. Part of that program was setting some memory variables as follows: SET VAR microrim_f2maxblk = 1024 -- SET VAR microrim_f3maxblk = 1400 -- SET VAR MICRORIM_TMPMAXBLK = 756 -- SET VAR microrim_btmaxblk = 1400 I have commented these settings out in the program and have not experienced any problems since. I am wondering if running my ENV_SET.PRG program repeatedly throughout my programs was causing memory to leak. I know that when R:Base first starts it takes about 5.5 MB of memory. By the time my morning programs completed their run that number grew to around 75 MB. I haven't checked it since making the changes. At any rate, since making these changes R:Base has been running like a champ again on my morning run of 100+ programs. No errors and it gets done in about half the time it used to. Again thanks for all the help and input. Mike Ramsour Voice: 740-829-4340
