Problem with memory

Daban

My company want buy FR3 and now I testing FR3, but I have problem with memory. When I use frxReport and get all date from table (select * from table) I see message: "The following error(s) have occured: Out of memory." Aplication get all free memory - 150-200 MB It's problem i see only when i get much records (150 000 record). How I can make big raports?
Daban

AlexTZ

Set the Report.EngineOptions.UseFileCache to True.

Daban

It's problem with RAM memory, not cache. I have true in this option, and I check diverse values MemMaxSize. I think, windows (delphi) put all report pages into RAM (when raport is create apllication get more and more RAM memory - I see it in task menager). If I create medium report (200 pages) my application get next 40MB and I don't see any errors, but when i create large report (2000 pages) apllication get more and more memory, finally when apllication get all free memory i see message- error out of memory.
Daban

AlexTZ

Works well for me. I have created the 990 pages report and I can see the difference between two modes.

Daban

I can see the difference between two modes, too. But finally I see message out of memory, although this message I see when apllication use only 50MB memory (when apllication working it use between 30 and 400 MB memory).
FR3 dont work well for me and I need help. Mayby uoy need created more than 990 pages report.
I prepare Firebird database (1 table, 20 rows) and small apllication (1 button, 1 report), and special SQL Query (3200000 rows). I send e-mail to you with this application, and please chek it. In my computer i see error near 3500 report page.
Daban

Daban

Alex, did you check examplethat I send to you? It's simple example and you can see problems with memory notwithstandisg set the Report.EngineOptions.UseFileCache to True. If someone want I can send him my simple example.
Daban

Daban

I asked about problem with memory, its very important problem because generate errors window. I pepared and send example. Did you check it? No, I wait and wait for reply... It's is support to FR3? I think no, because when i have problem I can't get help from producents FR3.
Daban

AlexTZ

It's not a FR problem. In your example that you have sent to me, remove all FR components and write the following code:

procedure TForm1.ReportClick(Sender: TObject);
begin
while not IBQuery1.Eof do
IBQuery1.Next;
end;

you'll get the same error. You need to turn off query buffer or smth like this - probably the query holds all data in the ram.

Daban

Thank you for answer.
You say it's problem with IB Components, but when I use components inside fast report (left, bottom corner: add IBX Database, add IBX Query) I have that same problem. Do you use IBcomponents inside Fast report? Mayby, but I see

IBXQuery1 : TfrxIBXQuery

FR3 components has that same problem as IB components.
If you want I can send you next example when i have problem with TfrxIBXQuery.

Daban

PS. If you know, how I can build big raports, please told me.

ToMiSoft

We have same problem with large datasets (using IBX component TIBQuery). Maybe it's right time to use another components - for this we use IB Objects without problem and very large reports (about 13000 pages) works well.

Milan Tomes

EresInformatica

After a long time, i resolve the problem of "Out of memory" puting this line in Query Create:

{ TfrxIBXQuery }

constructor TfrxIBXQuery.Create(AOwner: TComponent);
begin
  FQuery := TIBQuery.Create(nil);
  FQuery.UniDirectional := True; // this line...
  Dataset := FQuery;
  SetDatabase(nil);
  inherited;
end;

Out of memory errors disapears.