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

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumSite Forum Upgrade Issues - Please PostSite Forum Upgrade Issues - Please Post
Previous
 
Next
New Post
12/23/2009 5:31 AM
 

Wow - now that last reply submitted in only a couple of seconds!

 
New Post
12/23/2009 5:51 AM
 

An anomally with the "About this site" forum:

In the "DotNetNuke Forum" view (http://www.dotnetnuke.com/Community/Forums/tabid/795/Default.aspx) the most recent post is reported as "11/6/2009 7:03 AM
by Crispy". However, if you enter the forum (I tested as an unauthenticated user and logged in as myself) this post is nowhere to be seen. The most recent post is "12/10/2009 6:09 PM by Philip Beadle"

 
New Post
12/23/2009 6:10 AM
 

One more observation regarding performance:

When logged out, the response time browsing around the forums is pretty good (2-3 seconds on average to load each new page on average).

When logged in, the response time varies hugely. It has sometimes taken 3 minutes to load a new page (this is just browsing around, not submitting anything).

Just a guess but I am wondering if this discrepancy could be due to module caching? I am not an expert but doesn't module caching mean that unauthenticated users can get cached content but content for logged in users must be rendered from scratch on every request? If so, could the rendering process be being held up waiting for SQL queries to return results? In a complex data model like the forums, with a very high number of DB reads taking place but also a fair number of writes (posts, statistics etc), table locking could be a serious problem. Have you considered rewiting the SPs that return data to do "dirty" reads, in other words return the data as is at that moment rather than waiting on any other transactions that involve the same table to complete? I would say that in this module that is quite acceptable. The syntax to use is: select t1.col1, t1.col2, t1.col3 from table1 t1 with(nolock) join table2 t2 with(nolock) on t1.key = t2.key

 
New Post
12/23/2009 6:28 AM
 

A few words about performance here (specifically):

  • The SQL Profile results of the new forum vs the old forum are better, there is no doubt about that. 
    • DB usage is lower too (calls to it, duration, number of read/writes).
  • Load testing has shown the new module overall performed pretty well (against this site). 
  • There are other modules/issues/errors on this site that affect what happens here. 
  • The module depends heavily on profile data, this is a long running core query when the site restarts or it was a user's profile that hasn't been loaded.
    • Remember, the way profile is stored on a site like this there are millions of rows of data to retrieve from. 
  • I have yet to see a page take anywhere near 3 minutes to load. On initial DNN site startup it has historically been somewhat long to load, but we are talking about 1.5 minutes tops. 
    • I am not dismissing your claims, I just cannot verify it after trying to tax this module the past 24 hours (yes, almost all of them). 
  • As for Caching:
    • No user specific data (ie. retrieved aggregated forum content, search content, available forums/groups) is cached.
    • User profile is retrieved from core once for each user, then cached at core level and the forum also caches a forum user object (that contains the profile info)
    • Forum Information, Thread Information and Group Information are cached when loaded (this is on demand, part of why the initial load does take a few)
    • Specific Posts are NOT cached. 
    • Forum configuration is stored in ModuleSettings and therefore cached at the core level. 

 


Chris Paterra

Get direct answers to your questions in the Community Exchange.
 
New Post
12/23/2009 8:13 AM
 

I am working on Quick Reply locally, not sure when it will make its way here. I have it working but really need to test all scenarios.  


Chris Paterra

Get direct answers to your questions in the Community Exchange.
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumSite Forum Upgrade Issues - Please PostSite Forum Upgrade Issues - Please Post


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