Looping through large recordsets

[Enya]

My ASP page keeps timing out, when attempting to loop through very large recordsets.

Any suggestion to solve my problem would be greatly appreciated. Thanks in advance.

 

[frOblivion]

At the beginning of your script type

Server.ScriptTimeout = 120

Where 120 can be any number you want it to be. I forget whether that number is minutes, seconds, or milliseconds. I use a lot of times functions and get them mixed up. I think its minutes though.

 

[Enya]

I have already set my Server.ScriptTimeout = 1200. My ASP page is timing out inspite of setting it to this value.

 

[hblackorby]

Note that it isn't always your ASP page timing out, but your browser is timing out waiting for some content. There was a very similiar question about this a bit ago. Try this link for help in keeping your browser from timing out:

thread333-58145 Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO