SQL script files

The included SQL scripts are used as a default for setting DotNetNuke for optimal Performance. These settings scripts have tested to work for DotNetNuke versions 5.x - 6.1.5. Documentation about the settings are included as comments in the SQL scripts.

Installation

  1. Login into your DotNetNuke as HOST
  2. Menu item Host -> SQL
  3. Choose 1 of the .SQL files to load in the edit window
  4. Set "Run as Script" ON
  5. Click "Execute"
Repeat step 3-5 for all required SQL scripts

After loading all required scripts

Restart your DotNetNuke Application Host->Host Settings->Scroll to bottom and click Restart Application
The restart is needed to clear internally cached values

PLEASE NOTE

These SQL scripts change values in the settings and scheduler tables. I developed these scripts to automate our best pratices. This does not imply that these settings are optimal for every (your) situation. You can change settings by using the normal Host settings forms.
If you have any suggestion, comment, advise, problem, please use CodePlex for reactions:
http://dnnperformance.codeplex.com/workitem/list/basic
or contact me directly by e-mail.

EMPOWER PEOPLE AROUND THE WORLD WITH A $25 LOAN

If you find my free donation useful to you, have a look at kiva.org
  • Register yourself at www.kiva.org
  • Link yourself to dotnetnuke_community via this link
  • Lend $25 to someone who needs it!
  • Get it back later and lend it again!

Last edited Apr 5, 2012 at 1:29 PM by EPT, version 2

Comments

No comments yet.