Slow ASP.NET Crystal Reports - Restart the web site?

My client has an ASP.NET 1.1 website which uses Crystal Reports. It runs on a Windows 2000 server (one box for both web and sql [msde]) with IIS 5.0.

In the last day or so, some of the crystal reports take too long and the browser can't display the web page (IE message). Script timeout is set to about 30 minutes while execution timeout is set to several hours. It seems like page times out after about 20 minutes.

These are existing reports and I don't think the size of them has grown. I suspect the website needs to be "rebooted" but I don't want to restart the entire box since there may be other web sites running on it. Short of restarting the server and / or IIS, what can I do to clear out any accumulated junk for our website?

Thanks.
LVL 1
ZekeLAAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

meetingexpectationsCommented:
Clear the temp folder, usually C:/Windows/Temp, that is where Crystal reports create temp files.
0
ZekeLAAuthor Commented:
The latest file in WINNT\Temp is from 2009. Or is it just that the temp folder may be too full?
0
meetingexpectationsCommented:
That could be the reason. You need to periodically clean the temp folder, or at least add the code to dispose off the temp crystal files on page unload..Ex:

rptReportDocument is my CrystalDecisions.CrystalReports.Engine.ReportDocument
Private Sub Page_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Unload
            Try

                If IsNothing(rptReportDocument) = False Then
                    rptReportDocument.Close()
                    rptReportDocument.Dispose()
                End If

               Catch ex As Exception
                End Try
   End Sub
0
ZekeLAAuthor Commented:
Thanks for that code. I plan to implement it if testing shows no problems with it.
0
ZekeLAAuthor Commented:
Hosting company rebooted server which corrected the problem. Giving partial points to temp folder ideas as that seems like it was related.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.