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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Performance of Crystal 10
- Thread starter morfasie
- Start date
Why is this post called "Performance of Crystal 10"?
Did it work better under a previous version?
In general, subreports will kill performance and should be avoided if possible. A subreport will execute based on where it is placed, so if you have a subreport in the details section and you have 20,000 recordds in your report, the subreport has to execute 20,000 times.
Why don't you share some details of your report and lets see if we can better execute or even eliminate the subreports.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
Did it work better under a previous version?
In general, subreports will kill performance and should be avoided if possible. A subreport will execute based on where it is placed, so if you have a subreport in the details section and you have 20,000 recordds in your report, the subreport has to execute 20,000 times.
Why don't you share some details of your report and lets see if we can better execute or even eliminate the subreports.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
What is the significance of the exporting step? In other words, why did you mention you are first exporting?
Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
- Thread starter
- #4
Hi wel the thing is it is for a borderouax, so I get the main member details in the main report, then use sub reports to get the dependants and extended people. THen I have sub reports to get the money values per payment method.
But my average format time for a page is 308ms. Way to high. And I really don't know how to increase the performance.
But my average format time for a page is 308ms. Way to high. And I really don't know how to increase the performance.
What is the underlying DB you are reporting against (Oracle, MS-SQL, Sybase, etc...)?
How many members are you reporting against? It sounds like you have 2 sub-reports for each line of Member detail - so that would run pretty slow if you have a lot of members.
One possible solution - you could create a Stored Procedure on the database to tie the Member, Dependent, and payment info together - and develop your report against the Stored Procedure and avaoid having these sub-reports.
How many members are you reporting against? It sounds like you have 2 sub-reports for each line of Member detail - so that would run pretty slow if you have a lot of members.
One possible solution - you could create a Stored Procedure on the database to tie the Member, Dependent, and payment info together - and develop your report against the Stored Procedure and avaoid having these sub-reports.
- Thread starter
- #6
Hi unfortunetly it is a Mysql db version prior to version 5 that can handle stored procedures.
There are in a group lets say 400 main members, and each one has to be checked against about 80000 dependants, and 8000 extended family.
My version of MySQL doesn't support stored procedures yet. Is there maybe another way?
There are in a group lets say 400 main members, and each one has to be checked against about 80000 dependants, and 8000 extended family.
My version of MySQL doesn't support stored procedures yet. Is there maybe another way?
- Thread starter
- #8
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Question