10

http://forums.asp.net/1069538/ShowPost.aspx

http://forums.asp.net/1210288/ShowPost.aspx

 

1. Caching - DNN caching settings (in host settings) can have an enormous impact on pageload. Try them out to see what works, bear in mind this will only affect Non form pages and essentially will prevent unnecessary database access.

2. Sql server optimization - default sql setup is far from optimal for DNN and does a whole load of stuff you just don't need, like roll back transaction log support. There are great many issues here but some heavy optimization will have a massive effect on speed for servers with load. This can emerge as a problem as soon as traffic starts rising and WILL cause embarrassing 'application unavailable' errors under load. Optimize early on.

3. Keep Alives - This is an ASP.net issue but essentially the app is unloaded from memory when not being used, so your 10-20 delay is the app firing up for the first time. There are tools you can buy to sort this out, but also learn about the ASP.net availability issues.

4. ASP.net application pool availability and the default machine.config settings will affect performance/availability issues.

If you look into all of this then your sites will be faster than 90% of DNN deployments out there.

 

Posted in: DNN Performance

Post Rating

Comments

Brenda Honn
2007年7月15日 20:25
Could you explain more about - Sql server optimization - or give a link where we can find more information on this.
David
2009年1月5日 18:14
I would like MSSQL optimization info too. My DNN is crawling and I can't figure out which part is bad. Is there debug info to show the time line?
dnnskin
2009年1月5日 19:09
These two links might help:

http://www.dnnskin.com/KnowledgeBase/DotNetNukeDNNSkins/tabid/500/articleType/ArticleView/articleId/22/Default.aspx


http://www.dnnskin.com/KnowledgeBase/DotNetNukeDNNSkins/tabid/500/articleType/ArticleView/articleId/21/Default.aspx
The DotNetNuke Expert
2009年11月1日 20:13
Another great thing for page optimization in Snapsis Page Blaster. Essentially a caching module, that requires less database calls. So helps a little with the database optimization question.
In general SQL optimization can only happen in non shared hosting environments. So, if you are running a dedicated server you can do some tweaks to SQL Server. Starting with a good install where the transaction logs are on different physical disks then the data & picking appropriate raid setup.
James of Web Ascender the DotNetNuke Experts

Post Comment

Name (required)

Email (required)

Website

CAPTCHA image
Enter the code shown above:

 
LatestArticles