Re: Memory consumption when processing many records

Luch wrote:

>
> Something we notice... If we simply disconnect the sqlca object (the
> transaction object the PowerBuilder application uses to connect to the
> database) and then simply re-connect, say, every 100 records or so...
> the problem goes away. We simply disconnect, re-connect, and pick up
> at the point where we left off. This shows me the memory gets flushed
> every time the session is disconnected.

Dump PowerBuilder - it even tries to use it's own locking mechanism. Oracle is quite good at that, and does not require locks on reads.

What you are witnessing is a PB thing.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...