>Thanks you guys!
>
>I am running a program that takes about 5.5 hours... and any little thing I can do to speed it up is worthwhile.
>
>I really really really wish that ODBC writes and commits happened faster.
Hi Todd,
Just a thought that might help here. If you're using a number of function calls to PRGs, you might consider consolidating them into a single procedure file. By using SET PROCEDURE you can force the procedures and functions to load before entering the main body of calculations. This should (I think) keep them in the program buffer, so you won't have any additional file I/O load time, in the instance of a procedure or function being dumped from the buffer. In this case, using a procedure file would have some benefits over creating a custom non-visual class in that the calls won't have to be resolved within the class.
George
Ubi caritas et amor, deus ibi est