Slow performance while running report via the internet

[catnps77]

Hi,

I am running Crystal Report 8 report from the ASP page that I created. Unfortunately, the performance of the report running is very very slow. It took about nearly 15 minutes just to generate the report. It has about 1315 records.

The database connection in the report that I am running is taken from the stored procedure. Which means, there are few parameters passing involved.

The thing is, when I run the stored procedure through a SQL Query, it only took 13 seconds to produce the data.

Hhmmm.. what can be the problem that my report generates so slowly? Can it be the report formating or other things?

Your advise is much appreciated...

Thanks,
Catherine

 

[pgtek]

hi
Is your report set on your web server a fast server or what.
I had this problem my report would run fast in crystal report designer but was slow on the web I had to convert my store procedure to a view and save my report with data if there no parameter to be pass.
The database was using open link odbc connection.

hope this helps

cheers

pgtek

 

[synapsevampire]

There are many factors which can cause performance degradation, the worst culprit being subreports (givent that you're using a SP).

What is the performance like within Crystal Reports?

Are you exporting the report?

Try posting more specifics.

-k