0

I am working on classic asp script, which when create file button is clicked creates an excel report. Problem is sometimes report is too big and it times out. Due to following code:

<%
Server.ScriptTimeout = 200
%>

One way to solve this issue is just increase the time. That will be very easy solution. But i want to know from some asp experts if there is any other efficient solution to this problem?

NoviceMe
  • 3,126
  • 11
  • 57
  • 117

1 Answers1

0

Consider having the database do the work, instead of the page, using DTS or SSIS. Or you can launch a Stroed Proc from your page.

Community
  • 1
  • 1
Diodeus - James MacFarlane
  • 112,730
  • 33
  • 157
  • 176