Memory Use of TORAQUERY

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Olm
Posts: 1
Joined: Sun 31 Jul 2005 07:53

Memory Use of TORAQUERY

Post by Olm » Thu 18 Aug 2005 15:32

Hi, i am working with latest ODAC-Version, Net Option and C++ Builder 6 EE.

I create in several separate Thread's TOraQuery Objects like this:

MyDataObject->TQ->OptionsDS->AutoClose = false;
MyDataObject->TQ->OptionsDS->CacheLobs = false;
MyDataObject->TQ->OptionsDS->KeepPrepared = false;
MyDataObject->TQ->OptionsDS->LongStrings = true;
// MyDataObject->TQ->OptionsDS->LongStrings = false;
MyDataObject->TQ->Options->FlatBuffers = true;
MyDataObject->TQ->Options->RemoveOnRefresh = false;
MyDataObject->TQ->FetchRows = 25;

The OraQuery->Session is an TOraSession Object (with Thread safe Parameters) which is create in this Thread and i never delete the TORAQuery Objects;

After a while an a few "select * from ..." later, my memory use of the Process grows up....

When i set MyDataObject->TQ->FetchRows = 1 my process memory never grows. Is there any Data-Cache option in the OraQuery Object ???

Olm

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Fri 19 Aug 2005 07:18

Send us please small demo project to demonstrate the problem and include script to create server objects to ODAC support address.

Post Reply