Noticed the latest version 7.4.1 (I updated from 7.3.4) the following values in the columns (SettingName) > Table TabSettings are no longer inserted when a page (tab) is added:

DefaultAdminContainer
DebugMode
DefaultDocType

While the value CacheDuration in SettingName column (with an empty value in the SettingValue column) is inserted when a new page is added or an existing page is updated for whatever reason.

If I am correct CacheDuration (in the SettingName > TableSettings) was not there prior to ver. 7.4.x

I have deleted the "obsolete" (if I may call them as such)  values using the following:

DELETE FROM TabSettings
WHERE SettingName = 'DefaultDocType';

Have tested the pages, added, deleted and changed the page settings, so far no issue, I feel the page load is a bit faster.

Am I correct these values are not longer needed?

I also used Will Stroh instructions to clean reference of old skins that have been deleted, and reset the portal to the default skin.

http://www.willstrohl.com/Blog/PostId/515/How-to-Clear-Out-Skins-and-Containers-in-DotNetNu

Many thanks Sebastian for your reply:

The PortalSettings Table does not have DebugMode and DefaultDocType SettingsName value; it only has the DefaultAdminContainer please see the following, I made a screenshot of the TabSettings table (ver 7.4.1 CE) prior to me removing them (as referred).

 

PortalSettings Table

Column > SettingName (some may include third party settings as well)

AddCachebusterToResourceUris

AddCompatibleHttpHeader

addresscell

addresscity

addresscountry

addressfax

addresspostal

addressregion

addressstreet

addresstelephone

AllowUserUICulture

AUM_RedirectOldProfileUrl

AUM_VanityUrlPrefix

Column_Address

Column_Authorized

Column_CreatedDate

Column_DisplayName

Column_Email

Column_FirstName

Column_LastLogin

Column_LastName

Column_Telephone

ContentLocalizationEnabled

ControlBar_BookmarkCategory

ControlPanelMode

ControlPanelSecurity

ControlPanelVisibility

coreSitemapProviderEnabled

coreSitemapProviderOverride

coreSitemapProviderValue

CreateNewPageCultureType

CrmEnableCompositeFiles

CrmMinifyCss

CrmMinifyJs

CrmUseApplicationSettings

CrmVersion

DefaultAdminContainer

DefaultAdminSkin

DefaultAuthProvider

DefaultIconLocation

DefaultPortalAlias

DefaultPortalContainer

DefaultPortalSkin

DefaultTranslatorRoles-ar-JO

DefPreviewProfiles_Created

DisablePrivateMessage

Display_Mode

Display_SuppressPager

EnableBrowserLanguage

EnableModuleEffect

EnablePopups

EnableRegisterNotification

EnableSkinWidgets

EnableUrlLanguage

Facebook_APIKey

Facebook_APISecret

Facebook_Enabled

FavIconPath

Google_APIKey

Google_APISecret

Google_Enabled

HideFoldersEnabled

HideLoginControl

IncludePortalCss

InjectModuleHyperLink

InlineEditorEnabled

Live_APIKey

Live_APISecret

Live_Enabled

LiveID_Enabled

LiveID_IncludeHelp

MaximumVersionHistory

MaxSearchWordLength

MessagingAllowAttachments

MessagingProfanityFilters

MessagingRecipientLimit

MessagingSendEmail

MessagingThrottlingInterval

MinSearchWordLength

PageHeadText

paypalsandbox

paypalsubscriptioncancelreturn

paypalsubscriptionreturn

PortalAliasMapping

Profile_DefaultVisibility

Profile_DisplayVisibility

Profile_ManageServices

Records_PerPage

Redirect_AfterLogin

Redirect_AfterLogout

Redirect_AfterRegistration

Registration_ExcludeTerms

Registration_RandomPassword

Registration_RegistrationFormType

Registration_RequireConfirmPassword

Registration_RequireUniqueDisplayName

Registration_UseAuthProviders

Registration_UseEmailAsUserName

Registration_UseProfanityFilter

Search_ReindexRequestedOn

SearchAdminInitialization

SearchIncludeCommon

SearchIncludeNumeric

Security_CaptchaChangePassword

Security_CaptchaLogin

Security_CaptchaRegister

Security_CaptchaRetrivePassword

Security_DisplayNameFormat

Security_EmailValidation

Security_RequireValidProfile

Security_RequireValidProfileAtLogin

Security_UserNameValidation

Security_UsersControl

SitemapCacheDays

SitemapExcludePriority

SitemapIncludeHidden

SitemapLevelMode

SitemapMinPriority

SMTPAuthentication

SMTPConnectionLimit

SMTPEnableSSL

SMTPMaxIdleTime

SMTPmode

SMTPPassword

SSLEnabled

SSLEnforced

SSLURL

STDURL

Store_Password

Store_Username

TimeZone

Tweetification_AppUserName

Tweetification_AutoFollow

Tweetification_AutoTweet

Tweetification_ConsumerKey

Tweetification_ConsumerSecret

Tweetification_Enabled

Tweetification_TweetThis

Twitter_APIKey

Twitter_APISecret

Twitter_Enabled

UserIndexer_ReIndex

wnsogp-sitename

wnsogp-sitetype

wnsogp-useportaltitle

Yes you are right  Sebastian :) It is my overlook. But still the values are no longer added in the TabSettings table for version 7.4.x and deleting from the values from the TableSettings table was safe and somewhat bettered the page load.

HostSettings Table > Column > SettingName  (referred values in bold)