Problem with memory

Comments

• AlexTZ

  June 2005 edited 4:21AM

  Set the Report.EngineOptions.UseFileCache to True.
• Daban

  July 2005 edited 4:21AM

  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

  July 2005 edited 4:21AM

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

  July 2005 edited 4:21AM

  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

  July 2005 edited 4:21AM

  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

  July 2005 edited 4:21AM

  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

  July 2005 edited 4:21AM

  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

  July 2005 edited 4:21AM

  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

  July 2005 edited 4:21AM

  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

  February 2006 edited 4:21AM

  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.