Page 3 7.2.1 Slow - Administration and Configuration

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

Home All Forums

1
2
3
4
5

2/7/2014 5:07 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: 7.2.1 Slow

I tracked down the database calls for page settings. DNN is getting page information and settings, next folder information for the folders on the top level (for icon filepicker) and the list of all files, followed by a call to load file info for each file in top level folder - and this whole procedure is repeated for large Icon filepicker, i.e. if you are having 500 files in root folder of your website (e.g. /portals/0), you will end up with more than 1.000 database calls.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

4/23/2014 3:14 AM

Adam Underwood

Joined: 12/11/2012

Posts: 5

Re: 7.2.1 Slow

Hi guys,

I just wanted to add to this thread as I've also recently upgraded to DNN 7.2.2 from DNN 7.1.2 and I've seen a massive performance hit which has almost brought my site to a standstill and is definitely impacting customer experience.

The problem occurs once the site starts to receive load from users logging in and then the CPU on the server will hit 100% and everything grinds to a halt. I've logged a support ticket with DNN support but welcome any advice as they've gone very quiet!

One of my portals does have a folder off of the portal root which has 1,853 files in it which is required by my customers.

Help!

Thanks, Adam

4/23/2014 5:04 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: 7.2.1 Slow

you may try my turboSQL Scripts at dnnscript.codeplex.com, which improves a number of stored procedures, reducing the load.
However, it will not affect resources required by the web server (make sure, there is enough RAM for caching).

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

4/23/2014 5:16 AM

Adam Underwood

Joined: 12/11/2012

Posts: 5

Re: 7.2.1 Slow

Thanks Sebastian I'll checkout your Turbo Scripts, my server has 4Gb RAM and the DNN application process only ever reaches max 1.2GB est. so the server never hits its top limit even with other processes running, it hovers around 3.1GB used total on server.

4/23/2014 5:28 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: 7.2.1 Slow

The script may improve database performance but will not affect cache size - DNN 7.3.0 is targeting to improve memory footprint and performance as well.
PS: please backup your database prior to applying my scripts. They have been successfully applied to a few dozen sites, but as I learned from fixes contributed to DNN 7.2.2, it is hard to envision and catch all anomalies in existing databases.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

Page 3 of 6

...6

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:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)