472,334 Members | 1,468 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,334 software developers and data experts.

Page Loading Slow

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
5 2654
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: David Given | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Say I have a piece of Javascript that transforms the HTML on a page. (In order to work around CSS...
1
by: Fabricio Tofoli | last post by:
Hello all, I have a simple ASP.NET project that displays the contents of a MySql database table in the web page. All pages are extremelly slow,...
0
by: Simon | last post by:
I have W2K and SQL server on one computer. I have a problem with pages which are accessing the database in Page_Load method. When I load pages...
3
by: Bala | last post by:
Hi, In my page there is 4 dropdown list boxes.when page loading that time i am loading the nearly 3000 items array. so its taking too much time...
3
by: Bernie Yung | last post by:
Hi, We have a problem now that som of our clients are using a slow connection, and because the complexity of the ASPX pages it takes a long time...
3
by: Daz | last post by:
Hi everyone. I am making a stand alone web application, that listens for when the DOM content of a frame is loaded. Once it's loaded, I would...
5
by: henryrhenryr | last post by:
Appologies for unclear title. I don't really understand the problem I'm facing. My system: PHP 5.2.1, Win2K, Apache 2, MySQL 5 (local - problem...
1
by: jlea | last post by:
I know I'm not the first to report the extreme slow page load problem after applying Vista SP1 and using VS2008 (I don't know if the same is true...
2
by: | last post by:
Hi, I have 2 scenarios: First, an aspx page that contains 300 controls with the labels of course in a table. Second, an empty aspx page that...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
0
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.