Search
Friday, May 25, 2018

Published on Friday, July 21, 2017

TurboDNN

TurboSQL is a set of SQL scripts to improve Performance of DNN Platform (aka DotNetNuke) by optimizing indexes, references, views, functions & stored procedures. Further information on this product can be obtained from the following site:

https://dnnscript.codeplex.com/

Once the scripts are applied to a site, it is vitally important that they are removed before any attempt is made to upgrade the instance of DNN, otherwise the upgrade of the database will fail. If you are unsure whether TurboDNN has been applied to a site, use the following script (in SSMS) to check:

SELECT SettingName AS Script, SettingValue AS Version, LastModifiedOnDate as [Last_applied_on_date] FROM [HostSettings] WHERE SettingName LIKE N'Turbo%';

Alternatively, use the script in the following form using the SQL Console on your site:

SELECT SettingName AS Script, SettingValue AS Version, LastModifiedOnDate as [Last_applied_on_date] FROM {databaseOwner}[{objectQualifier}HostSettings] WHERE SettingName LIKE N'Turbo%';

 

Comments (0)Number of views (537)

Author: ExWeeto

Categories: CMS, DNN, Database, MSSQL

Tags:

Print

Please login or register to post comments.

“If I had eight hours to chop down a tree, I'd spend the first six of them sharpening my axe.”

Abraham Lincoln

Copyright 2018 by Exweeto Terms Of Use Privacy Statement