ASP.NET stops responding after executing a database query which is time consuming

Discussion in 'ASP .Net' started by, Aug 22, 2005.

  1. Guest


    I have a webpage which has aroud 20 steps as hyperlink.

    when start button is clicked, then step1 starts which does some
    operation in db and returns some value, based on that value i post the
    same page again to execute the next step. This continues untill the
    20th step is executed. Now some steps, take lot of time to execute some
    queries(9 million row updates) in the database. So stops
    responding and do not continue to next step eventhough the db operation
    for that step is completed.

    I have tried increasing the executiontimeout property but the problem
    still exists.

    Has anyone faced this problem? What are the possible solutions?

    I use AP.NET1.1 on XP box with IIS5.0

    any help appreciated.

    , Aug 22, 2005
    1. Advertisements

  2. visar

    visar Guest

    I'm not sure if you can guarantee the timeout time on the client side
    as the client may override your decisions. Why don't you try using
    something like AJAX to keep the page alive while the database is
    visar, Aug 22, 2005
    1. Advertisements

  3. Guest

    we are going to UAT in few days and at this point of time i cannot
    recommend new stuff like AJAX (just now read abt it and sounds
    interesting). All these days when there was less amt of data it was
    working fine till 20 steps now as the data is increasing we are facing
    this problem. I was hoping if any of process model attributes or
    httpruntime attibutes would solve the problem.

    , Aug 22, 2005
  4. Stefan

    Stefan Guest

    Does the browser/request timeout or the workerthread?
    Stefan, Aug 22, 2005
  5. Guest

    i'm not sure as to what is timing out.

    But here is the scenario.

    1)This application is on local m/c.

    2)The same application is on dev server.

    3) They both connect to same database.

    4) Now i run the steps from my local m/c. After the completion of each
    step i post back to the same page and update a column against that step
    in UI saying that step completed and proceeds to next step with the
    status as processing.

    5) Now at the same time i open the same page on dev server. whenever
    there is no delay there is no problem.

    6) But When a step takes long time, then i can see that by refreshing
    the page on devserver, that step is completed and it has stopped and
    did not proceed to next step.

    7) Then i check the local webpage and it is still saying processing.
    after refresh i can see that the step is completed but did not proceed
    to next step. It did not do a postback even after the step is
    completed.This happens to steps which takes longer time (upto 45 min)
    and not for steps which takes less time.

    Hope this helps in understanding the problem.

    , Aug 22, 2005
  6. Guest

    browser/request timeout -- i checked the IIS log and i do not see a
    408 error

    so i guess it is workerprocess timing out.
    , Aug 22, 2005
  7. Guest

    browser/request timeout -- i checked the IIS log and i do not see a
    408 error

    so i guess it is workerprocess timing out.
    , Aug 22, 2005
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. dotnet user
    dotnet user
    Aug 22, 2005
  2. elitehunter99
    Oct 17, 2006
  3. Boris
    Eric Brunel
    Dec 4, 2007
  4. QuestionMan stops responding / html & asp work

    QuestionMan, Jan 20, 2008, in forum: ASP .Net
    Jan 28, 2008
  5. Replies:
    DJ Stunks
    Feb 1, 2006

Share This Page