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...10k daily user website with around 40k articles10k daily user website with around 40k articles
Previous
 
Next
New Post
5/2/2014 7:57 PM
 

Hallo,

I'm willing to migrate my old custom-made cms (classic asp+sql server) to DNN.

The site is a city portal with more than 10k daily users and has 6000 registered users and 40k articles.

Now.. I really love DNN, it's what I was trying to do from scratch but only better, my only concern is performance.

It never happened to me that a local site, and even more a totally empty site, a fresh dnn install was so coumbersome and slow to load empty pages or do even the most basic tasks. This leaves me with the struggle to go on down the path of switching to DNN and eventually build my implementations as modules or carry on my .NET porting of my CMS (which of course is blazing fast even with 4 millions fake records in the db).

Since this is a real world scenario and a big step I will be taking, the site is already in production, I need some suggestions on my actual servers to understand if they will be able to handle the load.

At the moment I have 2 cloud istances for that. One is the db server with 8 cores 8 GB ram and several other DBs running but with low impact. The other istance is 4 cores 4 gb ram and is the web server with only 2 other sites with low impact as well.

Will this infrastructure be able to handle the load of 10k daily visits browsing 40k records? (I'm using EasyDNNNews at the moment to migrate the articles and I checked the procedures it does pagination sql server side so it whould be quite efficient).

 
New Post
5/2/2014 8:46 PM
 
8 GB should be fine to handle your site, 6k registered users is not a big deal, I have clients with nearly 200k users.
I suggest trying my turboSQL script to tune your site (dnnscript.codeplex.com).

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/3/2014 6:08 AM
 
Hallo Sebastian! Thanks for your reply. I already installed your script, from day one. My main concern is more the 10k daily visits than the registered users and the fact that site/sql would run on separate virtual machines... so I've fear this will clutter the tcp virtual connection between the two.
 
New Post
5/3/2014 6:51 AM
 
Max,
I suggest setting cache level in Host Settings to heavy, this will increase cache time and reduce the number of queries going to the database. You might need to add memory to the web server to make best use of it (avoid cache being removed to release space for new items).
You should also use Timer Based Scheduler to prevent too many events triggering it.
Enable Module Output Caching wherever possible (static, non user depending content), this will prevent the module content to be rebuilt on each page call.
I confirm that not all communication between web server and database server is optimized, DNN 7.3.0 should help a bit, because the DNN dev team is working on performance, including a few database retrievals as well.
I also suggest running SQL Server Profiler to identify very frequent and very heavy database calls.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/3/2014 7:15 AM
 
Hallo and thanks again for your support.
I wish my cloud hosting would allow me to add resources (after all that should be one of the main points of being cloud) but at the moment it doesn't so I'm limited to 4/8 GB max.
About all your suggestions I checked and they are all in place except the Page Output Cache. I read in the docs that this should be enabled on a page basis but when I go in the page settings, under caching providers no provider shows up in the dropdown... that's odd since for module caching in host settings I can choose between file and memory so there should be at least a couple of built in caching providers for pages as well.
Am I missing something?
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Performance and...Performance and...10k daily user website with around 40k articles10k daily user website with around 40k articles


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