Performance degrades when grouping spreads over several hundred pages?

rbuser

Hi,

We have some detailed reports which contain 2 groups: group 1 and group 2.
The report is fast until group2 breaks, after that each page gets generated
slower and slower then the previous page until group1 breaks. After that the
report becomes speedy again until (the second) group 2 breaks and slows
down again until group1 breaks (the second) again. In this exemple total
report contains 1100 pages, group1 contains max. 500 pages until it breaks,
group 2 contains max. 250 pages until it breaks. Outline settings are set to
false for each report/subreport/group. Why the heayy impact on performance
when using grouping and how could I speed things up? We are using RB7.

Greetings,
Filip Moons

nardmoseley

- as a test try writing some Delphi code that traverses the dataset(s) and
record the time required to traverse all records.

- if you are using Delphi dataset linking, try using ReportBuilder
DataPipeline linking instead (See the article on linking queries in the Data
Access thread of the tech tips newsgroup)

- as test comment out event-handler code associated with the report

- as test set all groups to keep together value of false