Professional Web Applications Themes

trapping script timeout errors - ASP Database

Is there a way to redirect to a custom error page if the script times out. I have set the scripttimeout to 300 in both code and in iis but it still times out too early, plus if the user is too vague in the search and it times out i just wanna be able to tell them to refine their search...

  1. #1

    Default trapping script timeout errors

    Is there a way to redirect to a custom error page if the script times out.
    I have set the scripttimeout to 300 in both code and in iis but it still
    times out too early, plus if the user is too vague in the search and it
    times out i just wanna be able to tell them to refine their search


    Steven Guest

  2. #2

    Default Re: trapping script timeout errors

    Perhaps your query method is inefficient?


    "Steven Scaife" <com> wrote in message
    news:phx.gbl... 


    dave Guest

  3. #3

    Default Re: trapping script timeout errors

    Uses a stored procedure that builds the sql string dynamically inside of it,
    from a possible 50 search parameters. using a dsn-less connection in the
    ASP page. Its a 70gig SQL 2000 database with over 3,500,000 customers and
    grows daily. The searches are generally fast but there is the odd time when
    the query takes too long.

    What would you suggest to make it more efficient?

    "dave" <com> wrote in message
    news:phx.gbl... [/ref]
    out. 
    >
    >[/ref]


    Steven Guest

  4. #4

    Default Re: trapping script timeout errors

    Determine which set of parameters causes it to run slowly* and optimize it,
    perhaps setting up indexes for it to use when those parameters are sent.

    Bob Barrows

    *You can use SQL Profiler for this

    Steven Scaife wrote: [/ref][/ref]

    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.


    Bob Guest

Similar Threads

  1. Trapping errors
    By KenJohnson in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: May 15th, 01:15 AM
  2. TRapping Errors from a Java Component
    By mherel in forum Coldfusion - Advanced Techniques
    Replies: 3
    Last Post: June 10th, 03:27 PM
  3. Trapping datatype errors for web methods
    By Saffola in forum ASP.NET Web Services
    Replies: 2
    Last Post: August 13th, 05:13 PM
  4. error not trapping errors?
    By Dr in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 13th, 02:50 PM
  5. trapping compile time errors
    By Gerard A.W. Vreeswijk in forum Ruby
    Replies: 5
    Last Post: July 7th, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139