>Bruce,
>
>The problem is the accumulation of memory usage as the queries are requeried over and over again. By periodically doing a close all and then reopening the tables and views you will eliminate the problem.
Hi Jim - that's the first thing I'll try today, but a question for you - how does the SQL INTO cursor build up memory usage if I do USE IN right after each query. I think you're right, the build up seems exactly like what the problem is, so that it eventually spills over to disk I/O, but I thought the USE IN should clear everything out?
I actually get away with perhaps 500 queries before the problem shows up, meaning each query adds maybe 10 or 15K to memory build up (very roughly). Is this normal? (I've never really thought about it till now)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.