Report now running very slow
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22582
Printed Date: 23 Apr 2024 at 11:38am
Topic: Report now running very slow
Posted By: Andrewarbogast
Subject: Report now running very slow
Date Posted: 24 Apr 2018 at 5:41am
Hello group,
I have a report that I haven't run in a while but when I was using it, the report ran pretty quickly. I tried to run the report today and it's very slow. Crystal stops responding for about 5 minutes before the report completes. I'm listing the Runtime stats of the report.
**************
~aaF64.rpt.rpt
**************
Report Definition
-----------------
Number of Database Fields: 18
Number of Summary Fields: 1
Number of Constant Formulas: 1
Number of On-Demand Formulas: 11 Only 4 in use
Number of Global Variables: 1
UFLs in use: None
Number of Subreport Objects: 5
Page N of M Used: Yes
File Format Schema: 11.0.0
Saved Data
----------
Number of Data Sources: 1
Unicode Saved Data: Yes
Total Number of Records: 48652
Selected Number of Records: 48652
Recurring Database Record Length: 739 bytes
Recurring Formula Record Length: 0 bytes
Constant Formula Record Length: 21 bytes
Size of Saved Records: 34 MB
Size of Saved Memo Fields: 0 bytes
Processing
----------
Grouping Done on Database Server: No
Sorting Done on Database Server: Yes
Record Selection Done on Database Server: Yes
Require Two Passes: No
Require the Total Page Count: Yes
Number of Nodes in Group Tree: 104
Number of Summary Values: 1
Size of Saved Group Tree: 1 KB
Built the Group Tree in Progress: No
Latest Report Changes
---------------------
Performance Timing
------------------
Open Document: 0 ms
Run the Database Query: 235843 ms
Read Database Records: 5 ms
Format First Page: 269454 ms
Number of pages formatted: 2
Average time to format a page: 134727 ms
Number of page starts generated: 2
Average time to generate a page start: 2270 ms
******************
MED/SOM Prescriber
******************
Report Definition
-----------------
Number of Database Fields: 6
Number of Summary Fields: 1
Number of On-Demand Formulas: 1
UFLs in use: None
Page N of M Used: No
File Format Schema: 11.0.0
Performance Timing
------------------
Run the Database Query: 7 ms For all instances
Read Database Records: 2 ms For all instances
Format First Page: 114 ms For all instances
Number of pages formatted: 76 For all instances
Average time to format a page: 1 ms For all instances
Number of page starts generated: 15
Average time to generate a page start: 0 ms For all instances
Number of subreport instances formatted: 90
Time to format all subreport instances: 3035 ms
*************
MED/SOM Nurse
*************
Report Definition
-----------------
Number of Database Fields: 6
Number of Summary Fields: 1
Number of On-Demand Formulas: 1
UFLs in use: None
Page N of M Used: No
File Format Schema: 11.0.0
Performance Timing
------------------
Run the Database Query: 5 ms For all instances
Read Database Records: 0 ms For all instances
Format First Page: 87 ms For all instances
Number of pages formatted: 76 For all instances
Average time to format a page: 1 ms For all instances
Number of page starts generated: 15
Average time to generate a page start: 0 ms For all instances
Number of subreport instances formatted: 90
Time to format all subreport instances: 1674 ms
*****************
CPST Face to Face
*****************
Report Definition
-----------------
Number of Database Fields: 5
Number of On-Demand Formulas: 1
UFLs in use: None
Page N of M Used: No
File Format Schema: 11.0.0
Performance Timing
------------------
Run the Database Query: 7 ms For all instances
Read Database Records: 9 ms For all instances
Format First Page: 97 ms For all instances
Number of pages formatted: 76 For all instances
Average time to format a page: 1 ms For all instances
Number of page starts generated: 15
Average time to generate a page start: 0 ms For all instances
Number of subreport instances formatted: 90
Time to format all subreport instances: 3064 ms
**********************
Release of Information
**********************
Report Definition
-----------------
Number of Database Fields: 4
Number of Summary Fields: 1
Number of On-Demand Formulas: 1
UFLs in use: None
Page N of M Used: No
File Format Schema: 11.0.0
Performance Timing
------------------
Run the Database Query: 6 ms For all instances
Read Database Records: 6 ms For all instances
Format First Page: 123 ms For all instances
Number of pages formatted: 76 For all instances
Average time to format a page: 1 ms For all instances
Number of page starts generated: 15
Average time to generate a page start: 0 ms For all instances
Number of subreport instances formatted: 90
Time to format all subreport instances: 2391 ms
*
*
Report Definition
-----------------
Number of Database Fields: 17
Number of Print Time Formulas: 11
Number of On-Demand Formulas: 7 Only 5 in use
Number of Global Variables: 8
UFLs in use: None
Page N of M Used: Yes
File Format Schema: 11.0.0
Performance Timing
------------------
Number of subreport instances formatted: 90
Time to format all subreport instances: 0 ms
|
Replies:
Posted By: DBlank
Date Posted: 24 Apr 2018 at 9:14am
try it without page n of m
|
|