We are using Crystal Report for Best to generate invoices out of Mas500 v6.3. The report is taking a long time to generate, so I began running SQL traces to see where the bottleneck might be. The query that does the bulk of the work has a duration of ~26 seconds when I trace the process when run through mas500. If I run the same exact query manually through SQL Query Analyzer, the duration is less than .5 seconds. Could anyone enlighten me on what might be happening in the background to cause the query to take considerably more time when run through CR as opposed to manually? How should I begin to look into this further? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Crystal Report Taking A Long Time To Generate Report
- Thread starter quikeyman
- Start date
First go to database->show SQL query and make sure that all criteria in the record selection formula (report->selection formula->record) are passing to the query.
You can also check Report->Performance Information for insights.
The following thread might also be helpful: thread149-1276307.
-LB
You can also check Report->Performance Information for insights.
The following thread might also be helpful: thread149-1276307.
-LB
- Thread starter
- #3
It does not seem as though anything from the record selection formula is being passed to the query. The query itself returns a result set, roughly 3800 rows, which I find odd because I would think that means CR is then searching for the appropriate row based on a parameter originating from mas500. Is it common for a CR query to return a result set? Should I possibly look into why the result set is as large as it is given the information is being pulled from two work tables?
This version of CR does not seem to have an option related to performance under the Report menu. I will take a look at the link to included to see if I can located something that might pertain to this scenario.
This version of CR does not seem to have an option related to performance under the Report menu. I will take a look at the link to included to see if I can located something that might pertain to this scenario.
- Thread starter
- #5
I now have the issue resolved. The source was two work tables that had quite a few rows built up after 7 years of use. Upon clearing out the work tables, the print invoice process is now quite swift. So in the end, this was a mas500 maintenance issue, and had nothing to do with CR.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question