General discussion

Locked

database times out

By dparkins ·
I have an sql2000 table with 2.8million records in it. Along with that I have set up an asp page to retrieve data from this table and show it on the screen. The problem is this; the page times out every time. Is there some line of code I can put on my asp page to lengthen the time? I don't want to do it in the global asa file. Or, is there something I should be doing with the table itself. I've set it up with a primary key and indexed it. Thanks in Advance. Dave

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

database times out

by khillabolt In reply to database times out

In ASP:
Server.ScriptTimeout = NumSeconds

NumSeconds:
Specifies the maximum number of seconds that a script can run before the server terminates it. The default value is 90 seconds.

Hope this helps...
Kevin

Collapse -

database times out

by dparkins In reply to database times out

Poster rated this answer

Collapse -

database times out

by dparkins In reply to database times out

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums