Extremely slow report when generated with more than 500 thousand records

Comments

• LurkingKiwi Wellington, New Zealand

  May 2019 edited 10:51PM

  I know I had issues with seemingly exponential runtime a few years ago, and it seemed to be related to traversing linked lists in FR.
  Doing it a different way was suggested by FR, but I'll have to search for the notes. I don't think it's the same as your problem, though.
  1) I don't know enough about object lists to know how they are indexed, but creating an array of pointers to the objects may speed up data retrieval
  2) Doing 10 reports of 5000 lines and concatenating the results in one preview may help, I'm sure that has been mentioned on the forum
• gpi

  May 2019 edited 10:51PM

  This code

  else if (CampoValido(sVarName)) then
  Value := '0';
  

  returns string, for "VALOR_TOTAL", "VALOR_PRESTACAO" and others which are using in aggregates.
  FastReport uses variant types for aggregates , that means SUM function works even for string values and it concatenates string values 500 thousand times.
  Use

  else if (CampoValido(sVarName)) then
  Value := 0;
  

  to return number values for fields used in agregate functions for all these aggregates :
  [SUM(<VALOR_TOTAL>, MasterData, 1)]
  [SUM(<VALOR_PRESTACAO>, MasterData, 1)]