CRv9 Performance info 4

[Jacque]

Crystal version 9
Under the Report Menu, there is an option to view Performance Information or save it to a file. These are some of the different branches listed. It also lists Subreports and gives more limited info.

Report Definition contains:
· Number of database fields
· Number of Memo/blob fields
· Number of Global variables
· Number of shared variables
· Number of subreport objects
· Number of on-demand formulas
· UFLs in use
· Page N of M Used
· File format Schema.

Saved Data contain
· Number of data sources
· Unicode saved data
· Total number of records
· Selected number of records
· Recurring database record length
· Recurring formula record length
· Constant formula record length
· Size of saved records
· Size of saved memo fields

Processing
· Grouping done on database server
· Sorting done on database server
· Record selection done on database server
· Require two passes
· Require the total page count
· Number of nodes in group tree
· Number of summary values
· Size of saved group tree
· Built the group tree in progress
· Size of saved records

Latest Report Changes
· Recurring database fields
· Print time formulas
· Database table linking

Performance timing
· Open Document
· Run the database query
· Read database records
· Format first page
· Number of pages formatted
· Average time to format a page

Each of these has a corresponding value and comments if applicable.

 

[IdoMillet]

Cool stuff. Thanks!

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[dgillz]

Way Cool. Many thanks.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[catmic]

I use the Performance Information in V9 and V10 of Crystal Reports. I'm seeing flaky results every time I run the exact same report.

The Performance Timing changes each time the report is run, sometimes dramatically. Is this due to memory caching? Operating system? Any ideas? I don't care if it is exact, just trying to find ways to speed up this report but the numbers change even before I make changes to the report itself.

Thx
CatMic