DNN 5.2.3 Stored Procedures executing numerous times during page loads
Posted
by David Neale
on Stack Overflow
See other posts from Stack Overflow
or by David Neale
Published on 2010-03-24T10:55:29Z
Indexed on
2010/03/24
11:13 UTC
Read the original article
Hit count: 548
After tracing the DB activity from a DNN 5.2.3 site I noticed that there are numerous identical calls to the database whilst loading the home page for the first time (afterwards the caching works successfully).
//Procedure : Number of executions
exec dbo.aspnet_Membership_GetUserByName @ApplicationName=N'DotNetNuke',@UserName=N'MYDOMAIN\ME',@UpdateLastActivity=0,@CurrentTimeUtc='2010-03-24 10:04:15:223' : 22
exec dbo.GetPortalAliasByPortalID @PortalID=0 : 15
exec dbo.GetUserProfile @UserID=8 : 11
exec dbo.GetUser @PortalID=0,@UserID=8 : 10
exec dbo.GetDatabaseVersion : 2
exec dbo.GetUserCountByPortal @PortalId=0: 2
exec dbo.GetDesktopModules : 2
exec dbo.KB_XMod_Forms_List @PortalId=0 : 2
exec dbo.KB_XMod_Templates_List @PortalId=0,@TemplateType=-1 : 2
Why so many duplicates?
© Stack Overflow or respective owner
