Print To File ????

rbuser

Delphi 7 and Report Builder 7X

We have built a report using a very large and complex SQL. In all of our
testing on small amounts of data this report works great. The report builds
a text file using the print to file functionality.

We have had are DBA optimize the SQL and the database and can get the SQL
Statement to work on 3 million records in less than 2 minutes.

However, when we use the SQL in our report and build our file using the
Print to Text File functionality, it seems like the process never ends. We
are talking hours.

In the report Designer, when testing it, the process bar shows the pages
being created wickedly splitty, until after about 400 -500 pages, then it
starts to slow down tremendously...and as it climbs to 800 pages, it just
crawls like a snail.

The utlimate file being created is around 4 gigs.

Is there anything to do to optimize this thing on the report designer side?

Any suggestions and feedback would be greatly appreciated

Shane

rbuser

BTW, we do own liceses to ReportBuilder 11x, and Delphi 2010, but our
company has yet to set a timetable to start recompiling everything in the
new versions. So, that is not an option!

Thanks

Shane

nardmoseley

Make sure you have Report.OutlineSettings.Enabled set to False. For a report
that large, the overhead required to generate the outline can slow
performance.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Great, thank you, i will give that a try!

Shane

rbuser

That helped trememndously! Thanks again!

Shane