Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Performance and...Performance and...Page Settings slowPage Settings slow
Previous
 
Next
New Post
8/19/2015 5:18 AM
 
if a small site is much faster, it sounds like a SQL Server issue.
Did you check SQL server performance using SQL profiler?

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
8/19/2015 10:17 AM
 
Yeah, I ran SQL profiler to the best of my ability and didn't find any queries with a huge elapsed time. During the page loading of Admin/pages.aspx, the largest duration observed was 12, I'm assuming milliseconds.
 
New Post
8/19/2015 6:07 PM
 
did you notice a sigle call performed hundreds times, e.g. for each page?

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
8/20/2015 10:26 AM
 
I don't think so. I started the trace, loaded the pages.aspx page, and then stopped the trace. There are 110 rows total. 35 rows had reads. Several of the rows are up the 700's on the reads. These are the rows that had reads:

These could of course too be from other visitors doing other things. The site is live.

exec sp_executesql N';Exec dbo.GetModule @0, @1',N'@0 int,@1 nvarchar(4000)',@0=771,@1=NULL
go
exec sp_executesql N';Exec dbo.GetModulePermissionsByTabID @0',N'@0 int',@0=1662
go
exec sp_executesql N';Exec dbo.GetModuleSettings @0',N'@0 int',@0=3305
go
exec sp_executesql N';Exec dbo.GetModuleSettings @0',N'@0 int',@0=3306
go
exec sp_executesql N';Exec dbo.GetModuleSettings @0',N'@0 int',@0=3307
go
exec sp_executesql N';Exec dbo.GetTabSettings @0',N'@0 int',@0=966
go
exec sp_executesql N';Exec dbo.GetModulePermissionsByTabID @0',N'@0 int',@0=966
go
exec sp_executesql N';Exec dbo.GetModuleSettings @0',N'@0 int',@0=1663
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=1584,@1=1
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=1663,@1=1
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=3305,@1=0
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=3305,@1=1
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=3306,@1=0
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=3306,@1=1
go
exec sp_executesql N';Exec dbo.GetModulePermissionsByTabID @0',N'@0 int',@0=8271
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=3307,@1=0
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=3307,@1=1
go
exec sp_executesql N';Exec dbo.GetModuleSettings @0',N'@0 int',@0=17381
go
exec sp_executesql N';Exec dbo.GetModuleSettings @0',N'@0 int',@0=17383
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=17381,@1=1
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=17383,@1=1
go
exec sp_executesql N';Exec dbo.CoreMessaging_CountNewThreads @0, @1',N'@0 int,@1 int',@0=1,@1=5
go
exec sp_executesql N';Exec dbo.CoreMessaging_CountNotifications @0, @1',N'@0 int,@1 int',@0=1,@1=5
go
exec sp_executesql N';Exec dbo.GetTabModules @0',N'@0 int',@0=967
go
exec sp_executesql N';Exec dbo.GetTabSettings @0',N'@0 int',@0=967
go
exec sp_executesql N';Exec dbo.GetModulePermissionsByTabID @0',N'@0 int',@0=967
go
exec sp_executesql N';Exec dbo.GetModuleSettings @0',N'@0 int',@0=1664
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=1584,@1=1
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=1664,@1=1
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=5500,@1=1
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=5502,@1=1
go
exec sp_executesql N';Exec dbo.GetModulePermissionsByTabID @0',N'@0 int',@0=8272
go
exec sp_executesql N';Exec dbo.GetModuleSettings @0',N'@0 int',@0=17384
go
exec sp_executesql N';Exec dbo.GetModuleSettings @0',N'@0 int',@0=17386
go
exec sp_executesql N';Exec dbo.GetTopHtmlText @0, @1',N'@0 int,@1 int',@0=17386,@1=1
go
 
New Post
8/20/2015 3:02 PM
 

This is all very strange. Why would my local machine, which is just an average desktop, be twice as fast when pointing the the same DB server, but running a local copy of the site?

To sum up my latests tests: 

I have the site running on the live server, and a copy of the site on my desktop.  Both are pointed to the db on the live server.  DB is same as live web server.

Loading the pages.aspx page on the live server has a TTFB of around 8s.  Loading it on the desktop copy, the TTFB is about 1.6s. 

On the live server, when I load the pages.aspx page for a portal (same installation) with a small number of pages, the ttfb is around 100 ms.   

 

 

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Performance and...Performance and...Page Settings slowPage Settings slow


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out