Re: memory consumption by the shadow process

I had a similar problem with Pro*C program's shadow process eating  memory. Was on a V6 on HPUX db. Turned out it was a bug in that db release. Worked around was to reopen cursors instead of re declaring them.

ie. typically declare,open,fetch,close but it is possible to

               declare,open,fetch,close then open again without redeclaring as long as the actual SQL statement didn't change.

It turned out to run much faster also.

-- 


--------------------------------------

Ed McRae       Ottawa, Ontario, Canada


--------------------------------------