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 Ver.8 OLE DB connection from the Web. Performance is very slow

Status
Not open for further replies.

Dewey12

Programmer
Dec 17, 2001
6
CA
Here is my problem. I have a crystal report with approximately 125 subreports and 26 parameters. The parameters are being passed to the report via webpage. I am using the crystal rptserver.asp and the setlogoninfo.asp.
The report takes approximately 40 seconds to run. However, when a number of people are trying to run this report it takes even longer and 90% of the time they get the following error ;
"PAGE CANNOT BE DISPLAYED-
Technical Information (for support personnel)
Error Type:
Active Server Pages, ASP 0113 (0x80004005)
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools."
I set the timeout on the IIS to 15 minutes which should be plenty of time.
I need some input!! Any help will be GREATLY APPRECIATED!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top