How do i improve the performance of report

syedjavid · October 22nd, 2003, 01:55 AM

I have statistical report developed in crystal report 9 which has all count and totals formulas which queries more than 15 millions of record and is taking more than 5 minutes to query and display the records.
How do i improve the performance of this report?
Any body has the solution

thanks

syedjavid

sal · October 24th, 2003, 10:09 AM

How are you storing your data? SQL Server?

What are you using for recordsource? SQL String? ADO?

Sal

syedjavid · October 25th, 2003, 02:01 AM

yes SQL SERVER 2000,
SQL string

syedjavid

sal · October 25th, 2003, 01:49 PM

If you are sending a string from Crystal report, create a stored procedure on the server and this will improve prformance, but only by about 20% or so.

Make sure that you are using your indexes in your database table.

How many joins are you using?
How many tables are you hitting?

Sal

syedjavid · October 26th, 2003, 05:46 AM

thanks, i will try

syedjavid