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 2 1211
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" <bi**@pointweb.net.nospam> wrote in message
news:uf**************@TK2MSFTNGP12.phx.gbl... 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
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" <el******@wayout.net> wrote in message
news:ea**************@TK2MSFTNGP09.phx.gbl... 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" <bi**@pointweb.net.nospam> wrote in message news:uf**************@TK2MSFTNGP12.phx.gbl... 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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: teedilo |
last post by:
We have an application with a SQL Server 2000 back end that is fairly
database intensive -- lots of fairly frequent queries, inserts, updates
-- the gamut. The application does not make use of...
|
by: bjarne |
last post by:
Willy Denoyette wrote;
> ... it
> was not the intention of StrousTrup to the achieve the level of efficiency
> of C when he invented C++, ...
Ahmmm. It was my aim to match the performance...
|
by: Jennifer Palonus |
last post by:
One of our customers reported a strange problem with our app, running on
Win2003 Server:
We have two VC++6 (classic C++) .exe's that talk to each other - an MFC app
talking to a COM server....
|
by: Bruno van Dooren |
last post by:
Hi,
i have a somewhat unusual question that is not really a c++ question, but
maybe one of you can help me.
I have programmed a windows service application that runs on an embedded pc.
the...
|
by: almurph |
last post by:
Hi everyone,
Hope you can help me. I'm converting an XMlDocuemnt object to a
string. I use the following code:
Dim doc As New XmlDocument
'Convert XmlDocument object -> String
Dim ms As...
|
by: Rithish |
last post by:
Hello. I noticed a strange thing while using strtotime() and date()
functions in combination to generate from MySQL into a readable format.
By default, the MySQL date field will be 0000-00-00...
|
by: mikes1962 |
last post by:
I am developing a Dialog based application using visual c++ .net 2003
running on XP, and when I run I periodically get the following error
message.
"The application has requested runtime to...
|
by: Rasika WIJAYARATNE |
last post by:
Hello everyone,
We have a forum system on our website. The main web application is
running in a virutal directory called /t7 and the forum system is on /
t7/forums/. When someone wants to post...
|
by: sheldonlg |
last post by:
I got an unusual request. One customer wants a password/access made
available to a user that is valid for only, say, ten minutes. I know
that I can enforce this by having a revalidation of the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |