At 02:17 PM 2/2/2010, Dan Goldberg wrote:
I remember sometime back someone had a suggestion to speed up
printing on reports.
Was the suggestion to avoid lines??
Dan,
A few recommendations:
01. Use "One Pass" to zip through the whole data set.
(only if you don't care to use [Page nnn of nnn] feature)
02. If not required, avoid "Look Ahead" calculations for report
with "Cover Page".
03. If your report involves Reports and Sub-Reports, make sure
that all tables are normalized as well as properly indexed.
04. If using lookup expressions, make sure that the column(s)
used in a WHERE clause are indexed.
05. If your report is based on a specific data set from multiple
tables, etc., try to first create a TEMPorary table with
the required data and then base your report on that TEMP
table. This will tremendously change your programming
practices to take advantage of speedy temporary tables that
are session specific and not locking up the actual tables
during the data retrieval process.
It is much faster to create temporary table(s) with desired
data than the report engine to retrieve and generate data.
06. Avoid displaying the "PAUSE command with GAUGE" in your report,
if your application is running on a Terminal/Citrix server.
07. Make sure that the SCRATCH settings are properly configured
with full access/privileges, as well as plenty space to read,
write, create and delete temporary .$$$ files.
08. There is a whole separate chapter on cool techniques to create
lighter and faster PDF files (DO's and DON'T's).
Hope that helps!
There are few more advanced features that I will have to write
about later (subject to my time and availability).
Good Luck and Very Best R:egards,
Razzak.
