locked
Improving ASP page performance RRS feed

  • Question

  • User-73514677 posted

    Hi,

    I am using ASP and Sql server 2000. The time taken to load the home page contents, takes a longer time as the database fetching gets around 2000 records. When the StoredProcedure is executed in the query analyzer, it takes hardly 2 seconds to fetch the data, but showing it in the ASP page, takes around 12 seconds..

    What can be done to improve the ASP performance.

    Thank you

    Monday, June 14, 2010 3:04 AM

Answers

All replies

  • User-823196590 posted

    Here are some ideas:
    http://www.15seconds.com/issue/000106.htm

    We might be able to give specific tips if you share some of your code with us.

    • Marked as answer by Anonymous Tuesday, September 28, 2021 12:00 AM
    Monday, June 14, 2010 7:46 AM
  • User-73514677 posted

    Hi,

    Thank you very much for the reply.

    When the page is loading, a stored procedure is executed and which returns around 2000 records.

    These records are shown in the html table. So the Page load takes longer time.

     

    The javascript function "changeStudents" is called in body onload.

    Thank you

    Monday, June 14, 2010 8:24 AM
  • User-823196590 posted

    When the page is loading, a stored procedure is executed and which returns around 2000 records.

    These records are shown in the html table. So the Page load takes longer time.

    Do you really need to do that?  Are 2000 records on a page even useable by a human?

    Monday, June 14, 2010 10:00 AM
  • User-73514677 posted

    Hi,

    I have a dropdownbox in the page, which lists the college names. Depending on the college, only those college details are shown. The javascript function, which i had provided, is on the onchange event of the dropdownbox.

    Sorry for not providing this information.

    Thank you

    Tuesday, June 15, 2010 12:32 AM
  • User-823196590 posted

    If you are loading all of the data/details in one shot, you might want to consider just loading the college names, and when the dropdown changes, have the form post and then retrieve the details for that college.

    Tuesday, June 15, 2010 2:06 PM
  • User-73514677 posted

    Hi,

    On the onchange event, how to call the stored procedure.

    Thursday, June 17, 2010 12:41 AM
  • User-823196590 posted

    You can't.

    In javascript you have to fire a form.submit from the dropdown onchange event handler.

    You would then have your asp code call the stored procedure.  This all requires a change in logic for your asp.

    Thursday, June 17, 2010 8:32 AM
  • User-73514677 posted

    Hi,

    Thank you very much for the reply. I understood,what you meant.

    I changed the logic, and it is working

    Monday, June 21, 2010 1:39 AM