Results 1 to 3 of 3

Thread: asp run time

  1. #1
    Join Date
    Feb 2004
    Posts
    20

    Unanswered: asp run time

    Hi

    My problem is that i need to run a query through asp page. but this query takes around 3 Hrs to run against oracle database coz these are live databases. As we know that script run time of asp is default 90 Sec.
    then how to do it.

    Plz Help...!!!!!!!!!!!!!!

    Thanks

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Index your tables, optimize the query, and increase the ASP time out.

    Server.ScriptTimeout = <seconds>
    That which does not kill me postpones the inevitable.

  3. #3
    Join Date
    Dec 2003
    Posts
    454
    Is your query complicated or there are many many rows of data in your table? Are you using the store procedure?

Posting Permissions

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