Professional Web Applications Themes

Unusual performance problem. - ASP.NET General

Hi, everyone. Posting this in the IIS group, because I don't think it is an ASP.NET question, crossposting because I am not sure. Apologizing in advance. I have a page with a datagrid that binds to a dataset that is generated from an Oracle database. If I trace the page load, and run ACT, the trace shows that the dataset load takes 9 seconds, and ACT says the page returns in 10.6 seconds. So I cached the dataset. On the first page load it is the same as above, as expected. Now on the second page load the dataset load ...

  1. #1

    Default Unusual performance problem.


    Hi, everyone. Posting this in the IIS group, because I don't think it is an
    ASP.NET question, crossposting because I am not sure. Apologizing in
    advance.

    I have a page with a datagrid that binds to a dataset that is generated from
    an Oracle database. If I trace the page load, and run ACT, the trace shows
    that the dataset load takes 9 seconds, and ACT says the page returns in 10.6
    seconds.

    So I cached the dataset. On the first page load it is the same as above, as
    expected. Now on the second page load the dataset load takes zero seconds
    (Whole page render takes 1.1 seconds) and ACT says the page returns in ...

    seven seconds.

    What's up with that? Logically, since I dropped off the 9 second dataset
    load, I had a net GAIN of 5.4 seconds by caching. According to trace, the
    page render, from beginning to end, takes 1.1 seconds. Where are those
    other seconds going to?

    -------
    William A. Sempf MCP, CIBS, CIW
    POINT Senior Technology Consultant
    Author of Effective Visual Studio .NET


    William Guest

  2. #2

    Default Re: Unusual performance problem.

    Hello

    May be the lost time is for databinding, which is done between hte loading
    the dataset and rendering the page. The datagrid items has to be populated
    and a lot of child controls ae created, which affects the performance. You
    can shift processing the records in the dataset to the redering stage, but
    you will lose te benefits of the datagrid, but will have better performance.

    Best Regards

    "William A. Sempf" <net.nospam> wrote in message
    news:ufeG#phx.gbl... 
    an 
    from 
    shows 
    10.6 
    as 
    .... 


    Sherif Guest

  3. #3

    Default Re: Unusual performance problem.


    I thought of that to, but trace.writes before and after the databinding (and
    everything else) show that the whole page render after caching only takes
    1.1 seconds.

    Also - wouldn't the databinding still take up the same amount of time if the
    dataset were cached or not cached? Then my uncached load time would be 14.6
    seconds.

    S

    "Sherif ElMetainy" <net> wrote in message
    news:phx.gbl... 
    performance. [/ref]
    is 
    > from 
    > shows 
    > 10.6 [/ref]
    above, [/ref]
    seconds 
    > ... [/ref]
    dataset [/ref]
    the 
    >
    >[/ref]


    William Guest

Similar Threads

  1. unusual cfquery problem
    By feral99 in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: May 9th, 12:13 AM
  2. most unusual os x system problem 10.2.x
    By Pell in forum Mac Applications & Software
    Replies: 2
    Last Post: July 27th, 11:31 PM
  3. Getting unusual error - I think.
    By Dave in forum ASP Database
    Replies: 6
    Last Post: July 7th, 08:57 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