ASP .NET 2.0 Performance

[Roman]

I am looking to improve the performance of my application. The result
page is 17k but it takes years to come up. There is an underlying sql
2005 query, but results come back rather fast. It seems to me that
caching is not there. Any suggestions?

Thanks in advance

[shiv_koirala]

Hi Roman,

Are you saying 17000 records. First thing do not know what a user will
do by viewing 17000 record at one glance. Best will be to pagination. I
mean 10 record at one time

As you said SQL 2005 there is a concept called as SQL cache dependency
but wondering do you really require that.

Regards
Shiv
Free 1000 .NET and SQL Server Interview questions with answers
http://www.questpond.com

[Roman]

Thanks for your help. I meant 17kb as rendered file size to say it
didn't generate much traffic.

As for the database, it is tiny. Also, other pages which do not query
the db perform the same way. It appears that application server is
building the page every time even if it didn't change.

Thanks again

sh**********@yahoo.com wrote:

Hi Roman,

Are you saying 17000 records. First thing do not know what a user will
do by viewing 17000 record at one glance. Best will be to pagination. I
mean 10 record at one time

As you said SQL 2005 there is a concept called as SQL cache dependency
but wondering do you really require that.

Regards
Shiv
Free 1000 .NET and SQL Server Interview questions with answers
http://www.questpond.com

[^MisterJingo^]

Roman wrote:

Thanks for your help. I meant 17kb as rendered file size to say it
didn't generate much traffic.

As for the database, it is tiny. Also, other pages which do not query
the db perform the same way. It appears that application server is
building the page every time even if it didn't change.

Thanks again

Hi Roman,

Just to clarify, are you running this app from iis, or through the
development webserver in vs2005? If you are running it from iis, does
the page take a long time to load each time you view it, or on first
view?

[^MisterJingo^]

ack,

ignore my question! I normally post on the asp forums and thought I was
reading this there.

Sorry about this :)

[Roman]

It takes long to load each time I view it.

^MisterJingo^ wrote:

Roman wrote:

Thanks for your help. I meant 17kb as rendered file size to say it
didn't generate much traffic.

As for the database, it is tiny. Also, other pages which do not query
the db perform the same way. It appears that application server is
building the page every time even if it didn't change.

Thanks again

Hi Roman,

Just to clarify, are you running this app from iis, or through the
development webserver in vs2005? If you are running it from iis, does
the page take a long time to load each time you view it, or on first
view?

[^MisterJingo^]

Roman wrote:

It takes long to load each time I view it.

>From iis (webspace either on your machine or a webhost) or the vs2005

webserver?

[Roman]

>From a remote ie browser. Nowhere within iis' lan or development
environment.

^MisterJingo^ wrote:

Roman wrote:

It takes long to load each time I view it.

From iis (webspace either on your machine or a webhost) or the vs2005

webserver?

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Without seeing the code we can solve nothing, of course nobody will have the
time to see the entire code so this mean you will have to do some profiling
yourself.

A very simple way of doing this is by wrapping key parts of your app with
DateTime instances and checking the Ticks :
DateTime start = DateTime.Now;
// your code
TimeSpan span = DateTiem.Now.Substract( start);
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Roman" <rg*******@hotmail.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

It takes long to load each time I view it.

^MisterJingo^ wrote:

>Roman wrote:

Thanks for your help. I meant 17kb as rendered file size to say it
didn't generate much traffic.

As for the database, it is tiny. Also, other pages which do not query
the db perform the same way. It appears that application server is
building the page every time even if it didn't change.

Thanks again

Hi Roman,

Just to clarify, are you running this app from iis, or through the
development webserver in vs2005? If you are running it from iis, does
the page take a long time to load each time you view it, or on first
view?

[Peter Bromberg [C# MVP]]

Roman,
Turn on page tracing and do some Trace.Warn 's at strategic locations in the
code showing where the page is at and the times.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Roman" wrote:

I am looking to improve the performance of my application. The result
page is 17k but it takes years to come up. There is an underlying sql
2005 query, but results come back rather fast. It seems to me that
caching is not there. Any suggestions?

Thanks in advance

[Roman]

Thanks for your help. Is there a way to tell what pages/page parts
were cached in IIS? How does IIS decide, without rendering the page,
that this page has changed and it needs to be reloaded?
Peter wrote:

Roman,
Turn on page tracing and do some Trace.Warn 's at strategic locations in the
code showing where the page is at and the times.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Roman" wrote:

I am looking to improve the performance of my application. The result
page is 17k but it takes years to come up. There is an underlying sql
2005 query, but results come back rather fast. It seems to me that
caching is not there. Any suggestions?

Thanks in advance

[Peter Bromberg [C# MVP]]

Roman,
See here for some background:

http://www.eggheadcafe.com/articles/20060407.asp

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Roman" wrote:

Thanks for your help. Is there a way to tell what pages/page parts
were cached in IIS? How does IIS decide, without rendering the page,
that this page has changed and it needs to be reloaded?
Peter wrote:

Roman,
Turn on page tracing and do some Trace.Warn 's at strategic locations in the
code showing where the page is at and the times.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Roman" wrote:

I am looking to improve the performance of my application. The result
page is 17k but it takes years to come up. There is an underlying sql
2005 query, but results come back rather fast. It seems to me that
caching is not there. Any suggestions?
>
Thanks in advance
>
>

[Roman]

This is greag. Thanks.
Peter wrote:

Roman,
See here for some background:

http://www.eggheadcafe.com/articles/20060407.asp

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Roman" wrote:

Thanks for your help. Is there a way to tell what pages/page parts
were cached in IIS? How does IIS decide, without rendering the page,
that this page has changed and it needs to be reloaded?
Peter wrote:

Roman,
Turn on page tracing and do some Trace.Warn 's at strategic locations in the
code showing where the page is at and the times.
Peter
>
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com
>
>
>
>
"Roman" wrote:
>
I am looking to improve the performance of my application. The result
page is 17k but it takes years to come up. There is an underlying sql
2005 query, but results come back rather fast. It seems to me that
caching is not there. Any suggestions?

Thanks in advance

[Roman]

In the previous reply I meant to say this is great.

I have one more question.

Assuming you had established caching duration as 1 hour. What happens
if during this time the cached page changed and conversely if caching
duration expired and page didn't change?

Thanks in advance
Peter wrote:

Roman,
See here for some background:

http://www.eggheadcafe.com/articles/20060407.asp

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Roman" wrote:

Thanks for your help. Is there a way to tell what pages/page parts
were cached in IIS? How does IIS decide, without rendering the page,
that this page has changed and it needs to be reloaded?
Peter wrote:

Roman,
Turn on page tracing and do some Trace.Warn 's at strategic locations in the
code showing where the page is at and the times.
Peter
>
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com
>
>
>
>
"Roman" wrote:
>
I am looking to improve the performance of my application. The result
page is 17k but it takes years to come up. There is an underlying sql
2005 query, but results come back rather fast. It seems to me that
caching is not there. Any suggestions?

Thanks in advance