Memory Use of TORAQUERY
Posted: 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
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