Problems with Memory Usage
Posted: Thu 03 Feb 2011 09:19
Hi,
we´re using UniDac 3.0.0.11.
When we connect via ODBC, i´ve got a big Problem with the TUniQuery.
We´ve created a Service which connect all 5 minutes via ODBC.
Here is the Problem:
Before we open the query, my memory-usage is for Example 5.001kB.
Then I open the query and the memory-usage is for Exampe 5.011 kB.
Then I close the query and the memory-usage is 5.011 kB.
Then I free the query and the memory-usage is 5.011 kB.
So the memory-usage grows up, because, we do this every 5 minutes on 365 days a year.
The owner of the TUniQuery is application..
Here a code example:
we´re using UniDac 3.0.0.11.
When we connect via ODBC, i´ve got a big Problem with the TUniQuery.
We´ve created a Service which connect all 5 minutes via ODBC.
Here is the Problem:
Before we open the query, my memory-usage is for Example 5.001kB.
Then I open the query and the memory-usage is for Exampe 5.011 kB.
Then I close the query and the memory-usage is 5.011 kB.
Then I free the query and the memory-usage is 5.011 kB.
So the memory-usage grows up, because, we do this every 5 minutes on 365 days a year.
The owner of the TUniQuery is application..
Here a code example:
Code: Select all
procedure DoIt;
var qry : TUniQuery;
begin
qry := TUniQuery.Create(application);
try
qry.Connection := dtmDB.uniDB;
qry.SQL.Text := 'select * from table';
//Memory 5.001kb
qry.Open;
//Memory 5.011kb
while not qry.eof do
begin
//Do something...
qry.next;
end;
finally
//Memory 5.011kb
qry.Close;
//Memory 5.011kb
FreeAndNil(qry);
//Memory 5.011kb and not 5.001kb
end;
end;