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...Upgrading DNN P...Upgrading DNN P...DNN 7.2.2 -> 7.4.0 upgrade cause problems with edit modeDNN 7.2.2 -> 7.4.0 upgrade cause problems with edit mode
Previous
 
Next
New Post
5/13/2015 11:33 AM
 
what are the biggest tables - Eventlog with 100 thousands of entries may slow down DNN as well.
(in SSMS: right click database node and see default report "Space used by top tables")
Follow my blog post to clean the eventlog: http://www.dnnsoftware.com/community-...

you may also use SQL profiler to analyse, which report is too large.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/13/2015 1:51 PM
 

Hello again!

I ran your script, but eventually it didn't solve our problem. Response time to get into Edit mode is still very long. We have quite a lot (HTML) content . We use custom "Mandeeps Live" modules for this purpose - that's why there are LiveHtml_Content and LiveArticles_Article_Version in "TOP 10 disc usage" tables.

You can see other tables on the picture below:

Project is quite big - more than 125 portals (some of them have more than 1000 pages and / or news). 

 We've already done some analysis on the database - there were no "strange stuff" - only queries / procedures from DNN Core (for getting information about Tabs, Modules, TabModules, TabPermission etc..)..

 
New Post
5/14/2015 7:40 AM
 
258k TabModules is really large. You should analyse the stored procedure, that takes so Long.
You may also try my Turbo scripts (on a site backup or backup at least the database first), which should improve performance significantly.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/15/2015 7:17 AM
 

Hello again!

 As i said - we've already done that and found out stored procedures that are "time consuming". They are all part of DNN core, so we think that modyfing them is not a good idea - or it is? We do not know where to start. We have problems with page load speed since the begining of our project. We've chosen community version of DNN for our project. Do you personally think that we should think about DotNetNuke Evoq Content? Is community (open source) version capable to handle such large and complex projects (more than 100 portals, a lot of content, users, roles, etc.). The only problem now is page load and edit mode speed (very slow - from 10 seconds and up).

 We've found your "Turbo scripts" some months ago, but eventually using them did not resolve our problem.

Thank you

 

 
New Post
5/15/2015 8:16 AM
 
Kivi,
t would be helpful to get to know the exact names of the sprocs, which are so time consuming.
I haven't spent too many specific effort on optimization for large numbers of tabs, but Turbo Scripts (especially TurboSchema) should improve.
Evoq uses DNN Platform for managing pages and modules, I am not aware of any differences in this area.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...DNN 7.2.2 -> 7.4.0 upgrade cause problems with edit modeDNN 7.2.2 -> 7.4.0 upgrade cause problems with edit mode


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