Subject | TIB_StoredProc, am I using it correctly? |
---|---|
Author | B.D.S. Bell |
Post date | 2001-07-24T18:33:21Z |
Hi all,
This all seems very basic stuff, but I'm having a
significant problem with aa mem leak that's driving me
nuts. Any help will be much appreciated.
I have been using TIB_StoredProc for some time in an
application and it works fine, but recently on a smaller PC
Win98, only 64mb, there appears to be a memory leak. I've
checked all my objects Create /Destroy and all looks ok.
I'm using the NT Performance monitor, set to monitor Process
MyProcess Private Bytes, which with each invocation of the
object containing the TIB_StoredProc uses more mem and
appears not to return any on destroy.
In object create I've called SQLRead :=
TIB_StoredProc.Create( Messagecn );
and in the destructor SQLRead.Free;
where Messagecn is the connection created once at startup of
the application.
I prepare the SQL each time before execution (ExecProc) .
I start /stop the transaction with ,
with MessageTrn do
if not InTransaction then StartTransaction;
MessageTrn.Commit;
Is there anything else I need to do before SQLRead.Free?
Delphi 5 Enterprise
NT 4 SP 6
IBO V3.6 Ba
Thanks,
Bryan
[Non-text portions of this message have been removed]
This all seems very basic stuff, but I'm having a
significant problem with aa mem leak that's driving me
nuts. Any help will be much appreciated.
I have been using TIB_StoredProc for some time in an
application and it works fine, but recently on a smaller PC
Win98, only 64mb, there appears to be a memory leak. I've
checked all my objects Create /Destroy and all looks ok.
I'm using the NT Performance monitor, set to monitor Process
MyProcess Private Bytes, which with each invocation of the
object containing the TIB_StoredProc uses more mem and
appears not to return any on destroy.
In object create I've called SQLRead :=
TIB_StoredProc.Create( Messagecn );
and in the destructor SQLRead.Free;
where Messagecn is the connection created once at startup of
the application.
I prepare the SQL each time before execution (ExecProc) .
I start /stop the transaction with ,
with MessageTrn do
if not InTransaction then StartTransaction;
MessageTrn.Commit;
Is there anything else I need to do before SQLRead.Free?
Delphi 5 Enterprise
NT 4 SP 6
IBO V3.6 Ba
Thanks,
Bryan
[Non-text portions of this message have been removed]