By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,081 Members | 1,885 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,081 IT Pros & Developers. It's quick & easy.

Page Loading Slow

P: n/a
We have a page that is loading very slow. There is not a lot of data, not a
lot of users are connected at the same time and the page does not produce an
error, so I am not sure where to start to look for why it is slowing down. I
thought about the DB first and added NOLOCK to a couple of stored procedures
that were being run, but with no effect. Can someone offer some tips on where
to start looking or how I can begin to diagnose this problem? Thank you.
Apr 6 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
I forgot to mention that when the submit button is clicked, the page begins
to load and starts out loading very slow. If I click the submit button again,
the page then loads very quickly. Also, in case it matters, the framework is
1.1.

"Wannabe" wrote:
We have a page that is loading very slow. There is not a lot of data, not a
lot of users are connected at the same time and the page does not produce an
error, so I am not sure where to start to look for why it is slowing down. I
thought about the DB first and added NOLOCK to a couple of stored procedures
that were being run, but with no effect. Can someone offer some tips on where
to start looking or how I can begin to diagnose this problem? Thank you.
Apr 6 '07 #2

P: n/a
Wannabe,
It *Sounds* like a database issue, from the small amount of information you
have actually provided. Give more details or sample code. If you want, you
can use the Stopwatch class to time the various portions of the page load, or
you can just turn on Page Tracing and look at the times reported in its
output to see where the hangup is.

How long does "just the database code" take to execute? That, to me, would
be the key area here.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Wannabe" wrote:
I forgot to mention that when the submit button is clicked, the page begins
to load and starts out loading very slow. If I click the submit button again,
the page then loads very quickly. Also, in case it matters, the framework is
1.1.

"Wannabe" wrote:
We have a page that is loading very slow. There is not a lot of data, not a
lot of users are connected at the same time and the page does not produce an
error, so I am not sure where to start to look for why it is slowing down. I
thought about the DB first and added NOLOCK to a couple of stored procedures
that were being run, but with no effect. Can someone offer some tips on where
to start looking or how I can begin to diagnose this problem? Thank you.
Apr 6 '07 #3

P: n/a
I have checked the database and the stored procedures run quite fast. I have
included a trace from the page. Not sure of how to read it myself.

Request Details
Session Id: 45kmzt55ak4rpn45ewtroeq5 Request Type: GET
Time of Request: 4/6/2007 8:13:08 AM Status Code: 200
Request Encoding: Unicode (UTF-8) Response Encoding: Unicode (UTF-8)
Trace Information
Category Message From First(s) From Last(s)
aspx.page Begin Init
aspx.page End Init 0.000130 0.000130
aspx.page Begin PreRender 0.010091 0.009961
aspx.page End PreRender 0.010138 0.000047
aspx.page Begin SaveViewState 0.010889 0.000751
aspx.page End SaveViewState 0.010968 0.000079
aspx.page Begin Render 0.010987 0.000019
aspx.page End Render 0.013403 0.002416
Control Tree
Control Id Type Render Size Bytes (including children) Viewstate Size Bytes
(excluding children)
__PAGE _ASP.Main_aspx 6433 20
_ctl0 System.Web.UI.ResourceBasedLiteralControl 948 0
frmMain System.Web.UI.HtmlControls.HtmlForm 5454 0
_ctl1 System.Web.UI.ResourceBasedLiteralControl 310 0
TD1 System.Web.UI.HtmlControls.HtmlTableCell 623 0
_ctl2 System.Web.UI.LiteralControl 14 0
DIV1 System.Web.UI.HtmlControls.HtmlGenericControl 248 0
_ctl3 System.Web.UI.LiteralControl 4 0
_ctl4 System.Web.UI.LiteralControl 57 0
DIV2 System.Web.UI.HtmlControls.HtmlGenericControl 149 0
_ctl5 System.Web.UI.LiteralControl 27 0
_ctl6 System.Web.UI.LiteralControl 44 0
_ctl7 System.Web.UI.ResourceBasedLiteralControl 279 0
lblSystemAcronym System.Web.UI.WebControls.Label 83 40
_ctl8 System.Web.UI.LiteralControl 40 0
lblSystemName System.Web.UI.WebControls.Label 106 88
_ctl9 System.Web.UI.LiteralControl 17 0
lblTestEvent System.Web.UI.WebControls.Label 108 92
_ctl10 System.Web.UI.ResourceBasedLiteralControl 936 0
repeaterControl System.Web.UI.WebControls.Repeater 1225 36
repeaterControl:_ctl0 System.Web.UI.WebControls.RepeaterItem 200
0
repeaterControl:_ctl0:_ctl0
System.Web.UI.DataBoundLiteralControl 200 16
repeaterControl:_ctl1 System.Web.UI.WebControls.RepeaterItem 203
0
repeaterControl:_ctl1:_ctl0
System.Web.UI.DataBoundLiteralControl 203 20
repeaterControl:_ctl2 System.Web.UI.WebControls.RepeaterItem 203
0
repeaterControl:_ctl2:_ctl0
System.Web.UI.DataBoundLiteralControl 203 20
repeaterControl:_ctl3 System.Web.UI.WebControls.RepeaterItem 206
0
repeaterControl:_ctl3:_ctl0
System.Web.UI.DataBoundLiteralControl 206 24
repeaterControl:_ctl4 System.Web.UI.WebControls.RepeaterItem 212
0
repeaterControl:_ctl4:_ctl0
System.Web.UI.DataBoundLiteralControl 212 32
repeaterControl:_ctl5 System.Web.UI.WebControls.RepeaterItem 201
0
repeaterControl:_ctl5:_ctl0
System.Web.UI.DataBoundLiteralControl 201 16
_ctl11 System.Web.UI.LiteralControl 79 0
leftnav System.Web.UI.HtmlControls.HtmlGenericControl 162 56
_ctl12 System.Web.UI.ResourceBasedLiteralControl 545 0
_ctl13 System.Web.UI.LiteralControl 31 0
Session state
Session Key Type Value
PersonnelID System.String bc202c64-7cf6-4c62-bd27-dad90854f9e1
Username System.String testuser
AccountID System.String 35971e32-34b1-4e90-97b3-9d1c86d76463
LoginTime System.DateTime 4/6/2007 8:12:05 AM
DatabaseName System.String TBMCS
Account TDCS.Account TDCS.Account
C2SystemID System.String dc7cd453-6105-44e8-9596-1d3cd94622a2
TestEvent System.String Service Pack 7 Regression Test
ReadOnly System.Boolean False
TestEventID System.String bafae83a-e023-4d27-b0f2-0e48961c8c29
Application State
Application Key Type Value
NumberOfUsers System.Int32 1
Cookies Collection
Name Value Size
RadEditorGlobalSerializeCookie
[radSpoCommentsModules]-[]#[radSpoCommentsToolbars]-[['Toolbar%200',true,'TopradSpoComments',0]]#[radDevCommentsModules]-[]#[radDevCommentsToolbars]-[['Toolbar%200',true,'TopradDevComments',0]]#[radTechnicalReferenceModules]-[]#[radTechnicalReferenceToolbars]-[['Toolbar%200',true,'TopradTechnicalReference',0]]#[radSuggestedFixModules]-[]#[radSuggestedFixToolbars]-[['Toolbar%200',true,'TopradSuggestedFix',0]]#[radMissionImpactModules]-[]#[radMissionImpactToolbars]-[['Toolbar%200',true,'TopradMissionImpact',0]]#[radWorkAroundModules]-[]#[radWorkAroundToolbars]-[['Toolbar%200',true,'TopradWorkAround',0]]#[radProblemDescriptionModules]-[]#[radProblemDescriptionToolbars]-[['Toolbar%200',true,'TopradProblemDescription',0]]#[radSequenceOfEventsModules]-[]#[radSequenceOfEventsToolbars]-[['Toolbar%200',true,'TopradSequenceOfEvents',0]]#[radDtrgCommentsModules]-[]#[radDtrgCommentsToolbars]-[['Toolbar%200',true,'TopradDtrgComments',0]]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextModules]-[]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_1edb3662dd834c8fa48d8282 8b510456_rteBuildingBlockText',0]]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextModules]-[]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_997f5bcc95e44793afb357a6 3d83f451_rteBuildingBlockText',0]]#[rteSectionInstructionsModules]-[]#[rteSectionInstructionsToolbars]-[['Toolbar%200',true,'ToprteSectionInstructions',0]]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextModules]-[]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_c4082c5af84a4730942b58a3 aa6afb7d_rteBuildingBlockText',0]]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextModules]-[]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_89cc79e701784e1384fa67b2 e1155810_rteBuildingBlockText',0]]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextModules]-[]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_4380a9178b734ec8912c532e ea575275_rteBuildingBlockText',0]]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextModules]-[]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_222f034c00ac438d8b5f129d f33bc6f3_rteBuildingBlockText',0]]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextModules]-[]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_44352a330b7e4060aa7c9542 c450a76d_rteBuildingBlockText',0]]#[rteSurveysModules]-[]#[rteSurveysToolbars]-[['Toolbar%200',true,'ToprteSurveys',0]]#[rteCommentsModules]-[]#[rteCommentsToolbars]-[['Toolbar%200',true,'ToprteComments',0]]#[rteTechnicalReferenceModules]-[]#[rteTechnicalReferenceToolbars]-[['Toolbar%200',true,'ToprteTechnicalReference',0]]#[rteSuggestedFixModules]-[]#[rteSuggestedFixToolbars]-[['Toolbar%200',true,'ToprteSuggestedFix',0]]#[rteSequenceOfEventsModules]-[]#[rteSequenceOfEventsToolbars]-[['Toolbar%200',true,'ToprteSequenceOfEvents',0]]#[rteWorkAroundModules]-[]#[rteWorkAroundToolbars]-[['Toolbar%200',true,'ToprteWorkAround',0]]#[rteProblemDescriptionModules]-[]#[rteProblemDescriptionToolbars]-[['Toolbar%200',true,'ToprteProblemDescription',0]]#[rteMissionImpactModules]-[]#[rteMissionImpactToolbars]-[['Toolbar%200',true,'ToprteMissionImpact',0]]# 3470
Headers Collection
Name Value
Cache-Control no-cache
Connection Keep-Alive
Accept image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/x-shockwave-flash, application/vnd.ms-excel,
application/vnd.ms-powerpoint, application/msword, application/vnd.xfdl;
version="6.5.0", */*
Accept-Encoding gzip, deflate
Accept-Language en-us
Cookie
RadEditorGlobalSerializeCookie=[radSpoCommentsModules]-[]#[radSpoCommentsToolbars]-[['Toolbar%200',true,'TopradSpoComments',0]]#[radDevCommentsModules]-[]#[radDevCommentsToolbars]-[['Toolbar%200',true,'TopradDevComments',0]]#[radTechnicalReferenceModules]-[]#[radTechnicalReferenceToolbars]-[['Toolbar%200',true,'TopradTechnicalReference',0]]#[radSuggestedFixModules]-[]#[radSuggestedFixToolbars]-[['Toolbar%200',true,'TopradSuggestedFix',0]]#[radMissionImpactModules]-[]#[radMissionImpactToolbars]-[['Toolbar%200',true,'TopradMissionImpact',0]]#[radWorkAroundModules]-[]#[radWorkAroundToolbars]-[['Toolbar%200',true,'TopradWorkAround',0]]#[radProblemDescriptionModules]-[]#[radProblemDescriptionToolbars]-[['Toolbar%200',true,'TopradProblemDescription',0]]#[radSequenceOfEventsModules]-[]#[radSequenceOfEventsToolbars]-[['Toolbar%200',true,'TopradSequenceOfEvents',0]]#[radDtrgCommentsModules]-[]#[radDtrgCommentsToolbars]-[['Toolbar%200',true,'TopradDtrgComments',0]]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextModules]-[]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_1edb3662dd834c8fa48d8282 8b510456_rteBuildingBlockText',0]]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextModules]-[]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_997f5bcc95e44793afb357a6 3d83f451_rteBuildingBlockText',0]]#[rteSectionInstructionsModules]-[]#[rteSectionInstructionsToolbars]-[['Toolbar%200',true,'ToprteSectionInstructions',0]]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextModules]-[]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_c4082c5af84a4730942b58a3 aa6afb7d_rteBuildingBlockText',0]]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextModules]-[]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_89cc79e701784e1384fa67b2 e1155810_rteBuildingBlockText',0]]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextModules]-[]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_4380a9178b734ec8912c532e ea575275_rteBuildingBlockText',0]]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextModules]-[]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_222f034c00ac438d8b5f129d f33bc6f3_rteBuildingBlockText',0]]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextModules]-[]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_44352a330b7e4060aa7c9542 c450a76d_rteBuildingBlockText',0]]#[rteSurveysModules]-[]#[rteSurveysToolbars]-[['Toolbar%200',true,'ToprteSurveys',0]]#[rteCommentsModules]-[]#[rteCommentsToolbars]-[['Toolbar%200',true,'ToprteComments',0]]#[rteTechnicalReferenceModules]-[]#[rteTechnicalReferenceToolbars]-[['Toolbar%200',true,'ToprteTechnicalReference',0]]#[rteSuggestedFixModules]-[]#[rteSuggestedFixToolbars]-[['Toolbar%200',true,'ToprteSuggestedFix',0]]#[rteSequenceOfEventsModules]-[]#[rteSequenceOfEventsToolbars]-[['Toolbar%200',true,'ToprteSequenceOfEvents',0]]#[rteWorkAroundModules]-[]#[rteWorkAroundToolbars]-[['Toolbar%200',true,'ToprteWorkAround',0]]#[rteProblemDescriptionModules]-[]#[rteProblemDescriptionToolbars]-[['Toolbar%200',true,'ToprteProblemDescription',0]]#[rteMissionImpactModules]-[]#[rteMissionImpactToolbars]-[['Toolbar%200',true,'ToprteMissionImpact',0]]#

User-Agent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322; .NET CLR 2.0.50727; InfoPath.1)
AspFilterSessionId 45kmzt55ak4rpn45ewtroeq5
Server Variables
Name Value
ALL_HTTP HTTP_CACHE_CONTROL:no-cache HTTP_CONNECTION:Keep-Alive
HTTP_ACCEPT:image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/x-shockwave-flash, application/vnd.ms-excel,
application/vnd.ms-powerpoint, application/msword, application/vnd.xfdl;
version="6.5.0", */* HTTP_ACCEPT_ENCODING:gzip, deflate
HTTP_ACCEPT_LANGUAGE:en-us
HTTP_COOKIE:RadEditorGlobalSerializeCookie=[radSpoCommentsModules]-[]#[radSpoCommentsToolbars]-[['Toolbar%200',true,'TopradSpoComments',0]]#[radDevCommentsModules]-[]#[radDevCommentsToolbars]-[['Toolbar%200',true,'TopradDevComments',0]]#[radTechnicalReferenceModules]-[]#[radTechnicalReferenceToolbars]-[['Toolbar%200',true,'TopradTechnicalReference',0]]#[radSuggestedFixModules]-[]#[radSuggestedFixToolbars]-[['Toolbar%200',true,'TopradSuggestedFix',0]]#[radMissionImpactModules]-[]#[radMissionImpactToolbars]-[['Toolbar%200',true,'TopradMissionImpact',0]]#[radWorkAroundModules]-[]#[radWorkAroundToolbars]-[['Toolbar%200',true,'TopradWorkAround',0]]#[radProblemDescriptionModules]-[]#[radProblemDescriptionToolbars]-[['Toolbar%200',true,'TopradProblemDescription',0]]#[radSequenceOfEventsModules]-[]#[radSequenceOfEventsToolbars]-[['Toolbar%200',true,'TopradSequenceOfEvents',0]]#[radDtrgCommentsModules]-[]#[radDtrgCommentsToolbars]-[['Toolbar%200',true,'TopradDtrgComments',0]]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextModules]-[]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_1edb3662dd834c8fa48d8282 8b510456_rteBuildingBlockText',0]]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextModules]-[]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_997f5bcc95e44793afb357a6 3d83f451_rteBuildingBlockText',0]]#[rteSectionInstructionsModules]-[]#[rteSectionInstructionsToolbars]-[['Toolbar%200',true,'ToprteSectionInstructions',0]]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextModules]-[]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_c4082c5af84a4730942b58a3 aa6afb7d_rteBuildingBlockText',0]]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextModules]-[]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_89cc79e701784e1384fa67b2 e1155810_rteBuildingBlockText',0]]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextModules]-[]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_4380a9178b734ec8912c532e ea575275_rteBuildingBlockText',0]]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextModules]-[]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_222f034c00ac438d8b5f129d f33bc6f3_rteBuildingBlockText',0]]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextModules]-[]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_44352a330b7e4060aa7c9542 c450a76d_rteBuildingBlockText',0]]#[rteSurveysModules]-[]#[rteSurveysToolbars]-[['Toolbar%200',true,'ToprteSurveys',0]]#[rteCommentsModules]-[]#[rteCommentsToolbars]-[['Toolbar%200',true,'ToprteComments',0]]#[rteTechnicalReferenceModules]-[]#[rteTechnicalReferenceToolbars]-[['Toolbar%200',true,'ToprteTechnicalReference',0]]#[rteSuggestedFixModules]-[]#[rteSuggestedFixToolbars]-[['Toolbar%200',true,'ToprteSuggestedFix',0]]#[rteSequenceOfEventsModules]-[]#[rteSequenceOfEventsToolbars]-[['Toolbar%200',true,'ToprteSequenceOfEvents',0]]#[rteWorkAroundModules]-[]#[rteWorkAroundToolbars]-[['Toolbar%200',true,'ToprteWorkAround',0]]#[rteProblemDescriptionModules]-[]#[rteProblemDescriptionToolbars]-[['Toolbar%200',true,'ToprteProblemDescription',0]]#[rteMissionImpactModules]-[]#[rteMissionImpactToolbars]-[['Toolbar%200',true,'ToprteMissionImpact',0]]#
HTTP_REFERER:https://testserver/myapp/(45kmzt55ak...TestEvent.aspx
HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET
CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1)
HTTP_ASPFILTERSESSIONID:45kmzt55ak4rpn45ewtroeq5
ALL_RAW Cache-Control: no-cache Connection: Keep-Alive Accept: image/gif,
image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash,
application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword,
application/vnd.xfdl; version="6.5.0", */* Accept-Encoding: gzip, deflate
Accept-Language: en-us Cookie:
RadEditorGlobalSerializeCookie=[radSpoCommentsModules]-[]#[radSpoCommentsToolbars]-[['Toolbar%200',true,'TopradSpoComments',0]]#[radDevCommentsModules]-[]#[radDevCommentsToolbars]-[['Toolbar%200',true,'TopradDevComments',0]]#[radTechnicalReferenceModules]-[]#[radTechnicalReferenceToolbars]-[['Toolbar%200',true,'TopradTechnicalReference',0]]#[radSuggestedFixModules]-[]#[radSuggestedFixToolbars]-[['Toolbar%200',true,'TopradSuggestedFix',0]]#[radMissionImpactModules]-[]#[radMissionImpactToolbars]-[['Toolbar%200',true,'TopradMissionImpact',0]]#[radWorkAroundModules]-[]#[radWorkAroundToolbars]-[['Toolbar%200',true,'TopradWorkAround',0]]#[radProblemDescriptionModules]-[]#[radProblemDescriptionToolbars]-[['Toolbar%200',true,'TopradProblemDescription',0]]#[radSequenceOfEventsModules]-[]#[radSequenceOfEventsToolbars]-[['Toolbar%200',true,'TopradSequenceOfEvents',0]]#[radDtrgCommentsModules]-[]#[radDtrgCommentsToolbars]-[['Toolbar%200',true,'TopradDtrgComments',0]]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextModules]-[]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_1edb3662dd834c8fa48d8282 8b510456_rteBuildingBlockText',0]]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextModules]-[]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_997f5bcc95e44793afb357a6 3d83f451_rteBuildingBlockText',0]]#[rteSectionInstructionsModules]-[]#[rteSectionInstructionsToolbars]-[['Toolbar%200',true,'ToprteSectionInstructions',0]]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextModules]-[]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_c4082c5af84a4730942b58a3 aa6afb7d_rteBuildingBlockText',0]]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextModules]-[]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_89cc79e701784e1384fa67b2 e1155810_rteBuildingBlockText',0]]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextModules]-[]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_4380a9178b734ec8912c532e ea575275_rteBuildingBlockText',0]]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextModules]-[]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_222f034c00ac438d8b5f129d f33bc6f3_rteBuildingBlockText',0]]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextModules]-[]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_44352a330b7e4060aa7c9542 c450a76d_rteBuildingBlockText',0]]#[rteSurveysModules]-[]#[rteSurveysToolbars]-[['Toolbar%200',true,'ToprteSurveys',0]]#[rteCommentsModules]-[]#[rteCommentsToolbars]-[['Toolbar%200',true,'ToprteComments',0]]#[rteTechnicalReferenceModules]-[]#[rteTechnicalReferenceToolbars]-[['Toolbar%200',true,'ToprteTechnicalReference',0]]#[rteSuggestedFixModules]-[]#[rteSuggestedFixToolbars]-[['Toolbar%200',true,'ToprteSuggestedFix',0]]#[rteSequenceOfEventsModules]-[]#[rteSequenceOfEventsToolbars]-[['Toolbar%200',true,'ToprteSequenceOfEvents',0]]#[rteWorkAroundModules]-[]#[rteWorkAroundToolbars]-[['Toolbar%200',true,'ToprteWorkAround',0]]#[rteProblemDescriptionModules]-[]#[rteProblemDescriptionToolbars]-[['Toolbar%200',true,'ToprteProblemDescription',0]]#[rteMissionImpactModules]-[]#[rteMissionImpactToolbars]-[['Toolbar%200',true,'ToprteMissionImpact',0]]#
Referer: MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR
2.0.50727; InfoPath.1) AspFilterSessionId: 45kmzt55ak4rpn45ewtroeq5
APPL_MD_PATH /LM/W3SVC/1/Root/tdcs
APPL_PHYSICAL_PATH E:\TDCS\
AUTH_TYPE
AUTH_USER
AUTH_PASSWORD
LOGON_USER
REMOTE_USER
CERT_COOKIE 72d7df51713bdc1b0a3e54746f0dc319
CERT_FLAGS 1
CONTENT_LENGTH 0
CONTENT_TYPE
GATEWAY_INTERFACE CGI/1.1
HTTPS on
HTTPS_KEYSIZE 128
HTTPS_SECRETKEYSIZE 1024
INSTANCE_ID 1
INSTANCE_META_PATH /LM/W3SVC/1
PATH_INFO /tdcs/Main.aspx
PATH_TRANSLATED E:\TDCS\Main.aspx
QUERY_STRING
REMOTE_PORT 45499
REQUEST_METHOD GET
SCRIPT_NAME /tdcs/Main.aspx
SERVER_PORT 443
SERVER_PORT_SECURE 1
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/6.0
URL /tdcs/Main.aspx
HTTP_CACHE_CONTROL no-cache
HTTP_CONNECTION Keep-Alive
HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/x-shockwave-flash, application/vnd.ms-excel,
application/vnd.ms-powerpoint, application/msword, application/vnd.xfdl;
version="6.5.0", */*
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_ACCEPT_LANGUAGE en-us
HTTP_COOKIE
RadEditorGlobalSerializeCookie=[radSpoCommentsModules]-[]#[radSpoCommentsToolbars]-[['Toolbar%200',true,'TopradSpoComments',0]]#[radDevCommentsModules]-[]#[radDevCommentsToolbars]-[['Toolbar%200',true,'TopradDevComments',0]]#[radTechnicalReferenceModules]-[]#[radTechnicalReferenceToolbars]-[['Toolbar%200',true,'TopradTechnicalReference',0]]#[radSuggestedFixModules]-[]#[radSuggestedFixToolbars]-[['Toolbar%200',true,'TopradSuggestedFix',0]]#[radMissionImpactModules]-[]#[radMissionImpactToolbars]-[['Toolbar%200',true,'TopradMissionImpact',0]]#[radWorkAroundModules]-[]#[radWorkAroundToolbars]-[['Toolbar%200',true,'TopradWorkAround',0]]#[radProblemDescriptionModules]-[]#[radProblemDescriptionToolbars]-[['Toolbar%200',true,'TopradProblemDescription',0]]#[radSequenceOfEventsModules]-[]#[radSequenceOfEventsToolbars]-[['Toolbar%200',true,'TopradSequenceOfEvents',0]]#[radDtrgCommentsModules]-[]#[radDtrgCommentsToolbars]-[['Toolbar%200',true,'TopradDtrgComments',0]]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextModules]-[]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_1edb3662dd834c8fa48d8282 8b510456_rteBuildingBlockText',0]]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextModules]-[]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_997f5bcc95e44793afb357a6 3d83f451_rteBuildingBlockText',0]]#[rteSectionInstructionsModules]-[]#[rteSectionInstructionsToolbars]-[['Toolbar%200',true,'ToprteSectionInstructions',0]]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextModules]-[]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_c4082c5af84a4730942b58a3 aa6afb7d_rteBuildingBlockText',0]]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextModules]-[]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_89cc79e701784e1384fa67b2 e1155810_rteBuildingBlockText',0]]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextModules]-[]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_4380a9178b734ec8912c532e ea575275_rteBuildingBlockText',0]]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextModules]-[]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_222f034c00ac438d8b5f129d f33bc6f3_rteBuildingBlockText',0]]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextModules]-[]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_44352a330b7e4060aa7c9542 c450a76d_rteBuildingBlockText',0]]#[rteSurveysModules]-[]#[rteSurveysToolbars]-[['Toolbar%200',true,'ToprteSurveys',0]]#[rteCommentsModules]-[]#[rteCommentsToolbars]-[['Toolbar%200',true,'ToprteComments',0]]#[rteTechnicalReferenceModules]-[]#[rteTechnicalReferenceToolbars]-[['Toolbar%200',true,'ToprteTechnicalReference',0]]#[rteSuggestedFixModules]-[]#[rteSuggestedFixToolbars]-[['Toolbar%200',true,'ToprteSuggestedFix',0]]#[rteSequenceOfEventsModules]-[]#[rteSequenceOfEventsToolbars]-[['Toolbar%200',true,'ToprteSequenceOfEvents',0]]#[rteWorkAroundModules]-[]#[rteWorkAroundToolbars]-[['Toolbar%200',true,'ToprteWorkAround',0]]#[rteProblemDescriptionModules]-[]#[rteProblemDescriptionToolbars]-[['Toolbar%200',true,'ToprteProblemDescription',0]]#[rteMissionImpactModules]-[]#[rteMissionImpactToolbars]-[['Toolbar%200',true,'ToprteMissionImpact',0]]#
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET
CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1)
HTTP_ASPFILTERSESSIONID 45kmzt55ak4rpn45ewtroeq5

"Peter Bromberg [C# MVP]" wrote:
Wannabe,
It *Sounds* like a database issue, from the small amount of information you
have actually provided. Give more details or sample code. If you want, you
can use the Stopwatch class to time the various portions of the page load, or
you can just turn on Page Tracing and look at the times reported in its
output to see where the hangup is.

How long does "just the database code" take to execute? That, to me, would
be the key area here.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Wannabe" wrote:
I forgot to mention that when the submit button is clicked, the page begins
to load and starts out loading very slow. If I click the submit button again,
the page then loads very quickly. Also, in case it matters, the framework is
1.1.

"Wannabe" wrote:
We have a page that is loading very slow. There is not a lot of data, not a
lot of users are connected at the same time and the page does not produce an
error, so I am not sure where to start to look for why it is slowing down. I
thought about the DB first and added NOLOCK to a couple of stored procedures
that were being run, but with no effect. Can someone offer some tips on where
to start looking or how I can begin to diagnose this problem? Thank you.
Apr 6 '07 #4

P: n/a
OK, well maybe it would be a good time for all of us to learn what to look
at. I don't need to go any further than this:

aspx.page Begin Init
aspx.page End Init 0.000130 0.000130
aspx.page Begin PreRender 0.010091 0.009961
aspx.page End PreRender 0.010138 0.000047
aspx.page Begin SaveViewState 0.010889 0.000751
aspx.page End SaveViewState 0.010968 0.000079
aspx.page Begin Render 0.010987 0.000019
aspx.page End Render 0.013403 0.002416

As you can see above, your page is taking a long time in the PreRender
phase, and again taking a long time in the Render Phase. I suspect you've got
some complex databinding and a lot of controls, or one very complicated
control such as a grid, that's taking a long time and generating a lot of
ViewState. So that's where you need to spend your time. The Database call is
not even an issue here.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Wannabe" wrote:
I have checked the database and the stored procedures run quite fast. I have
included a trace from the page. Not sure of how to read it myself.

Request Details
Session Id: 45kmzt55ak4rpn45ewtroeq5 Request Type: GET
Time of Request: 4/6/2007 8:13:08 AM Status Code: 200
Request Encoding: Unicode (UTF-8) Response Encoding: Unicode (UTF-8)
Trace Information
Category Message From First(s) From Last(s)
aspx.page Begin Init
aspx.page End Init 0.000130 0.000130
aspx.page Begin PreRender 0.010091 0.009961
aspx.page End PreRender 0.010138 0.000047
aspx.page Begin SaveViewState 0.010889 0.000751
aspx.page End SaveViewState 0.010968 0.000079
aspx.page Begin Render 0.010987 0.000019
aspx.page End Render 0.013403 0.002416
Control Tree
Control Id Type Render Size Bytes (including children) Viewstate Size Bytes
(excluding children)
__PAGE _ASP.Main_aspx 6433 20
_ctl0 System.Web.UI.ResourceBasedLiteralControl 948 0
frmMain System.Web.UI.HtmlControls.HtmlForm 5454 0
_ctl1 System.Web.UI.ResourceBasedLiteralControl 310 0
TD1 System.Web.UI.HtmlControls.HtmlTableCell 623 0
_ctl2 System.Web.UI.LiteralControl 14 0
DIV1 System.Web.UI.HtmlControls.HtmlGenericControl 248 0
_ctl3 System.Web.UI.LiteralControl 4 0
_ctl4 System.Web.UI.LiteralControl 57 0
DIV2 System.Web.UI.HtmlControls.HtmlGenericControl 149 0
_ctl5 System.Web.UI.LiteralControl 27 0
_ctl6 System.Web.UI.LiteralControl 44 0
_ctl7 System.Web.UI.ResourceBasedLiteralControl 279 0
lblSystemAcronym System.Web.UI.WebControls.Label 83 40
_ctl8 System.Web.UI.LiteralControl 40 0
lblSystemName System.Web.UI.WebControls.Label 106 88
_ctl9 System.Web.UI.LiteralControl 17 0
lblTestEvent System.Web.UI.WebControls.Label 108 92
_ctl10 System.Web.UI.ResourceBasedLiteralControl 936 0
repeaterControl System.Web.UI.WebControls.Repeater 1225 36
repeaterControl:_ctl0 System.Web.UI.WebControls.RepeaterItem 200
0
repeaterControl:_ctl0:_ctl0
System.Web.UI.DataBoundLiteralControl 200 16
repeaterControl:_ctl1 System.Web.UI.WebControls.RepeaterItem 203
0
repeaterControl:_ctl1:_ctl0
System.Web.UI.DataBoundLiteralControl 203 20
repeaterControl:_ctl2 System.Web.UI.WebControls.RepeaterItem 203
0
repeaterControl:_ctl2:_ctl0
System.Web.UI.DataBoundLiteralControl 203 20
repeaterControl:_ctl3 System.Web.UI.WebControls.RepeaterItem 206
0
repeaterControl:_ctl3:_ctl0
System.Web.UI.DataBoundLiteralControl 206 24
repeaterControl:_ctl4 System.Web.UI.WebControls.RepeaterItem 212
0
repeaterControl:_ctl4:_ctl0
System.Web.UI.DataBoundLiteralControl 212 32
repeaterControl:_ctl5 System.Web.UI.WebControls.RepeaterItem 201
0
repeaterControl:_ctl5:_ctl0
System.Web.UI.DataBoundLiteralControl 201 16
_ctl11 System.Web.UI.LiteralControl 79 0
leftnav System.Web.UI.HtmlControls.HtmlGenericControl 162 56
_ctl12 System.Web.UI.ResourceBasedLiteralControl 545 0
_ctl13 System.Web.UI.LiteralControl 31 0
Session state
Session Key Type Value
PersonnelID System.String bc202c64-7cf6-4c62-bd27-dad90854f9e1
Username System.String testuser
AccountID System.String 35971e32-34b1-4e90-97b3-9d1c86d76463
LoginTime System.DateTime 4/6/2007 8:12:05 AM
DatabaseName System.String TBMCS
Account TDCS.Account TDCS.Account
C2SystemID System.String dc7cd453-6105-44e8-9596-1d3cd94622a2
TestEvent System.String Service Pack 7 Regression Test
ReadOnly System.Boolean False
TestEventID System.String bafae83a-e023-4d27-b0f2-0e48961c8c29
Application State
Application Key Type Value
NumberOfUsers System.Int32 1
Cookies Collection
Name Value Size
RadEditorGlobalSerializeCookie
[radSpoCommentsModules]-[]#[radSpoCommentsToolbars]-[['Toolbar%200',true,'TopradSpoComments',0]]#[radDevCommentsModules]-[]#[radDevCommentsToolbars]-[['Toolbar%200',true,'TopradDevComments',0]]#[radTechnicalReferenceModules]-[]#[radTechnicalReferenceToolbars]-[['Toolbar%200',true,'TopradTechnicalReference',0]]#[radSuggestedFixModules]-[]#[radSuggestedFixToolbars]-[['Toolbar%200',true,'TopradSuggestedFix',0]]#[radMissionImpactModules]-[]#[radMissionImpactToolbars]-[['Toolbar%200',true,'TopradMissionImpact',0]]#[radWorkAroundModules]-[]#[radWorkAroundToolbars]-[['Toolbar%200',true,'TopradWorkAround',0]]#[radProblemDescriptionModules]-[]#[radProblemDescriptionToolbars]-[['Toolbar%200',true,'TopradProblemDescription',0]]#[radSequenceOfEventsModules]-[]#[radSequenceOfEventsToolbars]-[['Toolbar%200',true,'TopradSequenceOfEvents',0]]#[radDtrgCommentsModules]-[]#[radDtrgCommentsToolbars]-[['Toolbar%200',true,'TopradDtrgComments',0]]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextModules]-[]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_1edb3662dd834c8fa48d8282 8b510456_rteBuildingBlockText',0]]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextModules]-[]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_997f5bcc95e44793afb357a6 3d83f451_rteBuildingBlockText',0]]#[rteSectionInstructionsModules]-[]#[rteSectionInstructionsToolbars]-[['Toolbar%200',true,'ToprteSectionInstructions',0]]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextModules]-[]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_c4082c5af84a4730942b58a3 aa6afb7d_rteBuildingBlockText',0]]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextModules]-[]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_89cc79e701784e1384fa67b2 e1155810_rteBuildingBlockText',0]]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextModules]-[]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_4380a9178b734ec8912c532e ea575275_rteBuildingBlockText',0]]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextModules]-[]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_222f034c00ac438d8b5f129d f33bc6f3_rteBuildingBlockText',0]]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextModules]-[]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_44352a330b7e4060aa7c9542 c450a76d_rteBuildingBlockText',0]]#[rteSurveysModules]-[]#[rteSurveysToolbars]-[['Toolbar%200',true,'ToprteSurveys',0]]#[rteCommentsModules]-[]#[rteCommentsToolbars]-[['Toolbar%200',true,'ToprteComments',0]]#[rteTechnicalReferenceModules]-[]#[rteTechnicalReferenceToolbars]-[['Toolbar%200',true,'ToprteTechnicalReference',0]]#[rteSuggestedFixModules]-[]#[rteSuggestedFixToolbars]-[['Toolbar%200',true,'ToprteSuggestedFix',0]]#[rteSequenceOfEventsModules]-[]#[rteSequenceOfEventsToolbars]-[['Toolbar%200',true,'ToprteSequenceOfEvents',0]]#[rteWorkAroundModules]-[]#[rteWorkAroundToolbars]-[['Toolbar%200',true,'ToprteWorkAround',0]]#[rteProblemDescriptionModules]-[]#[rteProblemDescriptionToolbars]-[['Toolbar%200',true,'ToprteProblemDescription',0]]#[rteMissionImpactModules]-[]#[rteMissionImpactToolbars]-[['Toolbar%200',true,'ToprteMissionImpact',0]]# 3470
Headers Collection
Name Value
Cache-Control no-cache
Connection Keep-Alive
Accept image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/x-shockwave-flash, application/vnd.ms-excel,
application/vnd.ms-powerpoint, application/msword, application/vnd.xfdl;
version="6.5.0", */*
Accept-Encoding gzip, deflate
Accept-Language en-us
Cookie
RadEditorGlobalSerializeCookie=[radSpoCommentsModules]-[]#[radSpoCommentsToolbars]-[['Toolbar%200',true,'TopradSpoComments',0]]#[radDevCommentsModules]-[]#[radDevCommentsToolbars]-[['Toolbar%200',true,'TopradDevComments',0]]#[radTechnicalReferenceModules]-[]#[radTechnicalReferenceToolbars]-[['Toolbar%200',true,'TopradTechnicalReference',0]]#[radSuggestedFixModules]-[]#[radSuggestedFixToolbars]-[['Toolbar%200',true,'TopradSuggestedFix',0]]#[radMissionImpactModules]-[]#[radMissionImpactToolbars]-[['Toolbar%200',true,'TopradMissionImpact',0]]#[radWorkAroundModules]-[]#[radWorkAroundToolbars]-[['Toolbar%200',true,'TopradWorkAround',0]]#[radProblemDescriptionModules]-[]#[radProblemDescriptionToolbars]-[['Toolbar%200',true,'TopradProblemDescription',0]]#[radSequenceOfEventsModules]-[]#[radSequenceOfEventsToolbars]-[['Toolbar%200',true,'TopradSequenceOfEvents',0]]#[radDtrgCommentsModules]-[]#[radDtrgCommentsToolbars]-[['Toolbar%200',true,'TopradDtrgComments',0]]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextModules]-[]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_1edb3662dd834c8fa48d8282 8b510456_rteBuildingBlockText',0]]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextModules]-[]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_997f5bcc95e44793afb357a6 3d83f451_rteBuildingBlockText',0]]#[rteSectionInstructionsModules]-[]#[rteSectionInstructionsToolbars]-[['Toolbar%200',true,'ToprteSectionInstructions',0]]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextModules]-[]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_c4082c5af84a4730942b58a3 aa6afb7d_rteBuildingBlockText',0]]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextModules]-[]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_89cc79e701784e1384fa67b2 e1155810_rteBuildingBlockText',0]]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextModules]-[]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_4380a9178b734ec8912c532e ea575275_rteBuildingBlockText',0]]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextModules]-[]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_222f034c00ac438d8b5f129d f33bc6f3_rteBuildingBlockText',0]]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextModules]-[]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_44352a330b7e4060aa7c9542 c450a76d_rteBuildingBlockText',0]]#[rteSurveysModules]-[]#[rteSurveysToolbars]-[['Toolbar%200',true,'ToprteSurveys',0]]#[rteCommentsModules]-[]#[rteCommentsToolbars]-[['Toolbar%200',true,'ToprteComments',0]]#[rteTechnicalReferenceModules]-[]#[rteTechnicalReferenceToolbars]-[['Toolbar%200',true,'ToprteTechnicalReference',0]]#[rteSuggestedFixModules]-[]#[rteSuggestedFixToolbars]-[['Toolbar%200',true,'ToprteSuggestedFix',0]]#[rteSequenceOfEventsModules]-[]#[rteSequenceOfEventsToolbars]-[['Toolbar%200',true,'ToprteSequenceOfEvents',0]]#[rteWorkAroundModules]-[]#[rteWorkAroundToolbars]-[['Toolbar%200',true,'ToprteWorkAround',0]]#[rteProblemDescriptionModules]-[]#[rteProblemDescriptionToolbars]-[['Toolbar%200',true,'ToprteProblemDescription',0]]#[rteMissionImpactModules]-[]#[rteMissionImpactToolbars]-[['Toolbar%200',true,'ToprteMissionImpact',0]]#
>
User-Agent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322; .NET CLR 2.0.50727; InfoPath.1)
AspFilterSessionId 45kmzt55ak4rpn45ewtroeq5
Server Variables
Name Value
ALL_HTTP HTTP_CACHE_CONTROL:no-cache HTTP_CONNECTION:Keep-Alive
HTTP_ACCEPT:image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/x-shockwave-flash, application/vnd.ms-excel,
application/vnd.ms-powerpoint, application/msword, application/vnd.xfdl;
version="6.5.0", */* HTTP_ACCEPT_ENCODING:gzip, deflate
HTTP_ACCEPT_LANGUAGE:en-us
HTTP_COOKIE:RadEditorGlobalSerializeCookie=[radSpoCommentsModules]-[]#[radSpoCommentsToolbars]-[['Toolbar%200',true,'TopradSpoComments',0]]#[radDevCommentsModules]-[]#[radDevCommentsToolbars]-[['Toolbar%200',true,'TopradDevComments',0]]#[radTechnicalReferenceModules]-[]#[radTechnicalReferenceToolbars]-[['Toolbar%200',true,'TopradTechnicalReference',0]]#[radSuggestedFixModules]-[]#[radSuggestedFixToolbars]-[['Toolbar%200',true,'TopradSuggestedFix',0]]#[radMissionImpactModules]-[]#[radMissionImpactToolbars]-[['Toolbar%200',true,'TopradMissionImpact',0]]#[radWorkAroundModules]-[]#[radWorkAroundToolbars]-[['Toolbar%200',true,'TopradWorkAround',0]]#[radProblemDescriptionModules]-[]#[radProblemDescriptionToolbars]-[['Toolbar%200',true,'TopradProblemDescription',0]]#[radSequenceOfEventsModules]-[]#[radSequenceOfEventsToolbars]-[['Toolbar%200',true,'TopradSequenceOfEvents',0]]#[radDtrgCommentsModules]-[]#[radDtrgCommentsToolbars]-[['Toolbar%200',true,'TopradDtrgComments',0]]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextModules]-[]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_1edb3662dd834c8fa48d8282 8b510456_rteBuildingBlockText',0]]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextModules]-[]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_997f5bcc95e44793afb357a6 3d83f451_rteBuildingBlockText',0]]#[rteSectionInstructionsModules]-[]#[rteSectionInstructionsToolbars]-[['Toolbar%200',true,'ToprteSectionInstructions',0]]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextModules]-[]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_c4082c5af84a4730942b58a3 aa6afb7d_rteBuildingBlockText',0]]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextModules]-[]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_89cc79e701784e1384fa67b2 e1155810_rteBuildingBlockText',0]]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextModules]-[]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_4380a9178b734ec8912c532e ea575275_rteBuildingBlockText',0]]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextModules]-[]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_222f034c00ac438d8b5f129d f33bc6f3_rteBuildingBlockText',0]]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextModules]-[]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_44352a330b7e4060aa7c9542 c450a76d_rteBuildingBlockText',0]]#[rteSurveysModules]-[]#[rteSurveysToolbars]-[['Toolbar%200',true,'ToprteSurveys',0]]#[rteCommentsModules]-[]#[rteCommentsToolbars]-[['Toolbar%200',true,'ToprteComments',0]]#[rteTechnicalReferenceModules]-[]#[rteTechnicalReferenceToolbars]-[['Toolbar%200',true,'ToprteTechnicalReference',0]]#[rteSuggestedFixModules]-[]#[rteSuggestedFixToolbars]-[['Toolbar%200',true,'ToprteSuggestedFix',0]]#[rteSequenceOfEventsModules]-[]#[rteSequenceOfEventsToolbars]-[['Toolbar%200',true,'ToprteSequenceOfEvents',0]]#[rteWorkAroundModules]-[]#[rteWorkAroundToolbars]-[['Toolbar%200',true,'ToprteWorkAround',0]]#[rteProblemDescriptionModules]-[]#[rteProblemDescriptionToolbars]-[['Toolbar%200',true,'ToprteProblemDescription',0]]#[rteMissionImpactModules]-[]#[rteMissionImpactToolbars]-[['Toolbar%200',true,'ToprteMissionImpact',0]]#
HTTP_REFERER:https://testserver/myapp/(45kmzt55ak...TestEvent.aspx
HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET
CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1)
HTTP_ASPFILTERSESSIONID:45kmzt55ak4rpn45ewtroeq5
ALL_RAW Cache-Control: no-cache Connection: Keep-Alive Accept: image/gif,
image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash,
application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword,
application/vnd.xfdl; version="6.5.0", */* Accept-Encoding: gzip, deflate
Accept-Language: en-us Cookie:
RadEditorGlobalSerializeCookie=[radSpoCommentsModules]-[]#[radSpoCommentsToolbars]-[['Toolbar%200',true,'TopradSpoComments',0]]#[radDevCommentsModules]-[]#[radDevCommentsToolbars]-[['Toolbar%200',true,'TopradDevComments',0]]#[radTechnicalReferenceModules]-[]#[radTechnicalReferenceToolbars]-[['Toolbar%200',true,'TopradTechnicalReference',0]]#[radSuggestedFixModules]-[]#[radSuggestedFixToolbars]-[['Toolbar%200',true,'TopradSuggestedFix',0]]#[radMissionImpactModules]-[]#[radMissionImpactToolbars]-[['Toolbar%200',true,'TopradMissionImpact',0]]#[radWorkAroundModules]-[]#[radWorkAroundToolbars]-[['Toolbar%200',true,'TopradWorkAround',0]]#[radProblemDescriptionModules]-[]#[radProblemDescriptionToolbars]-[['Toolbar%200',true,'TopradProblemDescription',0]]#[radSequenceOfEventsModules]-[]#[radSequenceOfEventsToolbars]-[['Toolbar%200',true,'TopradSequenceOfEvents',0]]#[radDtrgCommentsModules]-[]#[radDtrgCommentsToolbars]-[['Toolbar%200',true,'TopradDtrgComments',0]]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextModules]-[]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_1edb3662dd834c8fa48d8282 8b510456_rteBuildingBlockText',0]]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextModules]-[]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_997f5bcc95e44793afb357a6 3d83f451_rteBuildingBlockText',0]]#[rteSectionInstructionsModules]-[]#[rteSectionInstructionsToolbars]-[['Toolbar%200',true,'ToprteSectionInstructions',0]]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextModules]-[]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_c4082c5af84a4730942b58a3 aa6afb7d_rteBuildingBlockText',0]]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextModules]-[]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_89cc79e701784e1384fa67b2 e1155810_rteBuildingBlockText',0]]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextModules]-[]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_4380a9178b734ec8912c532e ea575275_rteBuildingBlockText',0]]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextModules]-[]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_222f034c00ac438d8b5f129d f33bc6f3_rteBuildingBlockText',0]]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextModules]-[]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_44352a330b7e4060aa7c9542 c450a76d_rteBuildingBlockText',0]]#[rteSurveysModules]-[]#[rteSurveysToolbars]-[['Toolbar%200',true,'ToprteSurveys',0]]#[rteCommentsModules]-[]#[rteCommentsToolbars]-[['Toolbar%200',true,'ToprteComments',0]]#[rteTechnicalReferenceModules]-[]#[rteTechnicalReferenceToolbars]-[['Toolbar%200',true,'ToprteTechnicalReference',0]]#[rteSuggestedFixModules]-[]#[rteSuggestedFixToolbars]-[['Toolbar%200',true,'ToprteSuggestedFix',0]]#[rteSequenceOfEventsModules]-[]#[rteSequenceOfEventsToolbars]-[['Toolbar%200',true,'ToprteSequenceOfEvents',0]]#[rteWorkAroundModules]-[]#[rteWorkAroundToolbars]-[['Toolbar%200',true,'ToprteWorkAround',0]]#[rteProblemDescriptionModules]-[]#[rteProblemDescriptionToolbars]-[['Toolbar%200',true,'ToprteProblemDescription',0]]#[rteMissionImpactModules]-[]#[rteMissionImpactToolbars]-[['Toolbar%200',true,'ToprteMissionImpact',0]]#
Referer: MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR
2.0.50727; InfoPath.1) AspFilterSessionId: 45kmzt55ak4rpn45ewtroeq5
APPL_MD_PATH /LM/W3SVC/1/Root/tdcs
APPL_PHYSICAL_PATH E:\TDCS\
AUTH_TYPE
AUTH_USER
AUTH_PASSWORD
LOGON_USER
REMOTE_USER
CERT_COOKIE 72d7df51713bdc1b0a3e54746f0dc319
CERT_FLAGS 1
CONTENT_LENGTH 0
CONTENT_TYPE
GATEWAY_INTERFACE CGI/1.1
HTTPS on
HTTPS_KEYSIZE 128
HTTPS_SECRETKEYSIZE 1024
INSTANCE_ID 1
INSTANCE_META_PATH /LM/W3SVC/1
PATH_INFO /tdcs/Main.aspx
PATH_TRANSLATED E:\TDCS\Main.aspx
QUERY_STRING
REMOTE_PORT 45499
REQUEST_METHOD GET
SCRIPT_NAME /tdcs/Main.aspx
SERVER_PORT 443
SERVER_PORT_SECURE 1
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/6.0
URL /tdcs/Main.aspx
HTTP_CACHE_CONTROL no-cache
HTTP_CONNECTION Keep-Alive
HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/x-shockwave-flash, application/vnd.ms-excel,
application/vnd.ms-powerpoint, application/msword, application/vnd.xfdl;
version="6.5.0", */*
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_ACCEPT_LANGUAGE en-us
HTTP_COOKIE
RadEditorGlobalSerializeCookie=[radSpoCommentsModules]-[]#[radSpoCommentsToolbars]-[['Toolbar%200',true,'TopradSpoComments',0]]#[radDevCommentsModules]-[]#[radDevCommentsToolbars]-[['Toolbar%200',true,'TopradDevComments',0]]#[radTechnicalReferenceModules]-[]#[radTechnicalReferenceToolbars]-[['Toolbar%200',true,'TopradTechnicalReference',0]]#[radSuggestedFixModules]-[]#[radSuggestedFixToolbars]-[['Toolbar%200',true,'TopradSuggestedFix',0]]#[radMissionImpactModules]-[]#[radMissionImpactToolbars]-[['Toolbar%200',true,'TopradMissionImpact',0]]#[radWorkAroundModules]-[]#[radWorkAroundToolbars]-[['Toolbar%200',true,'TopradWorkAround',0]]#[radProblemDescriptionModules]-[]#[radProblemDescriptionToolbars]-[['Toolbar%200',true,'TopradProblemDescription',0]]#[radSequenceOfEventsModules]-[]#[radSequenceOfEventsToolbars]-[['Toolbar%200',true,'TopradSequenceOfEvents',0]]#[radDtrgCommentsModules]-[]#[radDtrgCommentsToolbars]-[['Toolbar%200',true,'TopradDtrgComments',0]]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextModules]-[]#[BB_1edb3662dd834c8fa48d82828b510456_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_1edb3662dd834c8fa48d8282 8b510456_rteBuildingBlockText',0]]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextModules]-[]#[BB_997f5bcc95e44793afb357a63d83f451_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_997f5bcc95e44793afb357a6 3d83f451_rteBuildingBlockText',0]]#[rteSectionInstructionsModules]-[]#[rteSectionInstructionsToolbars]-[['Toolbar%200',true,'ToprteSectionInstructions',0]]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextModules]-[]#[BB_c4082c5af84a4730942b58a3aa6afb7d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_c4082c5af84a4730942b58a3 aa6afb7d_rteBuildingBlockText',0]]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextModules]-[]#[BB_89cc79e701784e1384fa67b2e1155810_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_89cc79e701784e1384fa67b2 e1155810_rteBuildingBlockText',0]]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextModules]-[]#[BB_4380a9178b734ec8912c532eea575275_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_4380a9178b734ec8912c532e ea575275_rteBuildingBlockText',0]]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextModules]-[]#[BB_222f034c00ac438d8b5f129df33bc6f3_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_222f034c00ac438d8b5f129d f33bc6f3_rteBuildingBlockText',0]]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextModules]-[]#[BB_44352a330b7e4060aa7c9542c450a76d_rteBuildingBlo ckTextToolbars]-[['Toolbar%200',true,'TopBB_44352a330b7e4060aa7c9542 c450a76d_rteBuildingBlockText',0]]#[rteSurveysModules]-[]#[rteSurveysToolbars]-[['Toolbar%200',true,'ToprteSurveys',0]]#[rteCommentsModules]-[]#[rteCommentsToolbars]-[['Toolbar%200',true,'ToprteComments',0]]#[rteTechnicalReferenceModules]-[]#[rteTechnicalReferenceToolbars]-[['Toolbar%200',true,'ToprteTechnicalReference',0]]#[rteSuggestedFixModules]-[]#[rteSuggestedFixToolbars]-[['Toolbar%200',true,'ToprteSuggestedFix',0]]#[rteSequenceOfEventsModules]-[]#[rteSequenceOfEventsToolbars]-[['Toolbar%200',true,'ToprteSequenceOfEvents',0]]#[rteWorkAroundModules]-[]#[rteWorkAroundToolbars]-[['Toolbar%200',true,'ToprteWorkAround',0]]#[rteProblemDescriptionModules]-[]#[rteProblemDescriptionToolbars]-[['Toolbar%200',true,'ToprteProblemDescription',0]]#[rteMissionImpactModules]-[]#[rteMissionImpactToolbars]-[['Toolbar%200',true,'ToprteMissionImpact',0]]#
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET
CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1)
HTTP_ASPFILTERSESSIONID 45kmzt55ak4rpn45ewtroeq5

"Peter Bromberg [C# MVP]" wrote:
Wannabe,
It *Sounds* like a database issue, from the small amount of information you
have actually provided. Give more details or sample code. If you want, you
can use the Stopwatch class to time the various portions of the page load, or
you can just turn on Page Tracing and look at the times reported in its
output to see where the hangup is.

How long does "just the database code" take to execute? That, to me, would
be the key area here.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Wannabe" wrote:
I forgot to mention that when the submit button is clicked, the page begins
to load and starts out loading very slow. If I click the submit button again,
the page then loads very quickly. Also, in case it matters, the framework is
1.1.
>
"Wannabe" wrote:
>
We have a page that is loading very slow. There is not a lot of data, not a
lot of users are connected at the same time and the page does not produce an
error, so I am not sure where to start to look for why it is slowing down. I
thought about the DB first and added NOLOCK to a couple of stored procedures
that were being run, but with no effect. Can someone offer some tips on where
to start looking or how I can begin to diagnose this problem? Thank you.
Apr 6 '07 #5

P: n/a
there is nothing here to indicate a problem. a couple of things to try:

1. the html is complex and takes a long time to render. to test, save as
html and load from file system.

2. the html references another url that takes a long time. check web
logs for times.

3. authentication takes a long time. (turn on anonymous and test).

4. do a network trace and look for timeouts.
-- bruce (sqlwork.com)

Peter Bromberg [C# MVP] wrote:
OK, well maybe it would be a good time for all of us to learn what to look
at. I don't need to go any further than this:

aspx.page Begin Init
aspx.page End Init 0.000130 0.000130
aspx.page Begin PreRender 0.010091 0.009961
aspx.page End PreRender 0.010138 0.000047
aspx.page Begin SaveViewState 0.010889 0.000751
aspx.page End SaveViewState 0.010968 0.000079
aspx.page Begin Render 0.010987 0.000019
aspx.page End Render 0.013403 0.002416

As you can see above, your page is taking a long time in the PreRender
phase, and again taking a long time in the Render Phase. I suspect you've got
some complex databinding and a lot of controls, or one very complicated
control such as a grid, that's taking a long time and generating a lot of
ViewState. So that's where you need to spend your time. The Database call is
not even an issue here.
Peter
Apr 6 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.