Register | Log In
Store Download Support Blogs Forums Contact
Resources > Forums
HomeHomeUsing DotNetNuk...Using DotNetNuk...Performance and...Performance and...DNN 6.1 site growing until too large for web hostDNN 6.1 site growing until too large for web host
Previous
 
Next
New Post
11/17/2011 8:42 AM
 
User is offline stephen hadley

www.underridenetwork.org
Joined: 11/18/2005
Posts: 55

My DNN sites for years grow monthly in proportion to the amount of traffic they get until they are so large I must reload them. I usually lose my member list in the process. I am also having editing problems with html module freezing. The site is now down and my backup will not load as it uses Portal 0 and it says it cannot be null so I must reload site all by hand.

Site is www.underridenetwork.org which is non-profit. Thanks for help.
 
New Post
11/17/2011 9:23 AM
 
User is offline Chris Hammond


Chris Hammond's Avatar

www.chrishammond.com
Joined: 1/14/2003
Posts: 6147
Do you have the site log enabled in the host settings? I would turn that off, it can cause the database for your site to grow quite large. Most people use Google Analytics for traffic analysis these days, and the site logs are turned off by default.

You should also setup some database maintenance scripts that backup your db/logs and shrink the log files every so often as they can grow quite large as well.

You shouldn't need to start your website over from scratch at any point in time.
Chris Hammond
Director of Training Programs, DotNetNuke Corp.


I raising money for TeamLIVESTRONG, if you found my forum post helpful, perhaps you'd like to donate to my ride.
Benefiting LiveStrong
 
New Post
11/17/2011 10:18 AM
 
User is offline Scott Willhite


Scott Willhite's Avatar

www.dotnetnuke.com
Joined: 4/11/2003
Posts: 3017

Hi Stephen ~

Chris suggestion is a good one.  There are usually two main possible culprits for database growth, the SiteLog table (as Chris indicated) and the EventLog table, which records errors.  If you have additional modules installed, they could be contributing to things, but your site looks fairly straightforward and these are probably the areas to look at.

Can I ask a few questions about your site and it's environment?  All of this information can be found on your Host > Dashboard page.  If you wanted to send me the XML export from this module, I would be happy to have a look at it and make some further recommendations.  You can reach me at scott.willhite@dotnetnuke.com

  • What is your database Software Platforum, Product Edition and Version?
  • What is the size of your DATA and LOG tables?
  • What is your Scheduler Mode?
  • How many Portals and Users are in this instance?

We'll help you get figured out ;-)

Scott Willhite, Co-Founder & Director of Community Programs for DotNetNuke

"It is only with the heart that one can see rightly... what is essential is invisible to the eye. "
~ Antoine de Saint-Exupéry
 
New Post
11/17/2011 2:16 PM
 
User is offline stephen hadley

www.underridenetwork.org
Joined: 11/18/2005
Posts: 55

Thanks for the quick responses. As the site is basically down I do not have the site info yet. DNN 6.1 seems to finally be incompatible with my version 4 skin. I cannot do site wizard because it does not like my backups portal 0 nor its version 4 skin. The HTML editor seems to be buggier than ever, I edit a quarter page of plain text and save it and the text just disappears at times, this is going to take forever.

I have tried to turn off all of the logging and empty whatever i could from the menu selections including site logging. My Cpanel at my host has traffic analysis going back 3 months but I do not think that is a large file. As a community user I do not know anything about database scripting, why does DNN require scripting for non-pro version? It seems to me that any caches or logs should be turned off or at least cleaned by default with an advanced menu for advanced users. It should also backup the users list. These have been my same problems for several years and hundreds of hours.

When I get the site back up I will pass along the specifics to track down the culprit.

Thanks
 
New Post
11/17/2011 2:22 PM
 
User is offline Costas Zividis


Joined: 10/29/2010
Posts: 385
What is the size of your database ?

And how do you host, shared, dedicated, what ?

Venice Travel Guide
 
 Page 1 of 4
1234Next 
Previous
 
Next
HomeHomeUsing DotNetNuk...Using DotNetNuk...Performance and...Performance and...DNN 6.1 site growing until too large for web hostDNN 6.1 site growing until too large for web host


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
Attend A Webinar
Free Demo Site
Download DotNetNuke Professional Edition Trial
Have Someone Contact Me
Have Someone Contact Me
Charlotte DoDNN

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

Exact Target Exec Alert
r2integrated
Telerik JustCode Free

DotNetNuke Scoop!

Sponsors

DotNetNuke Corporation

DotNetNuke Corp. is the steward of the DotNetNuke open source project, the most widely adopted Web Content Management Platform for building web sites and web applications on Microsoft. Organizations use DotNetNuke to quickly develop and deploy interactive and dynamic web sites, intranets, extranets and web applications. The DotNetNuke platform is available in a free Community and subscription-based Professional and Enterprise Editions with an Elite Support option. DotNetNuke Corp. also operates the DotNetNuke Store where users purchase third party apps for the platform.
Copyright © 2002-2012 DotNetNuke Corp. / Terms of Use / Privacy
Hosted by MaximumASP