Search
Home
Website Services
LetItShine Update Service
YouTube Snip-O-Matic
Support
Terms And Conditions
Website Components & Solutions
Contact Support
Server Status
DNN Support Blog
Action Form Notes
Remote Assistance
LetItShine FileTransfer
Safe Setting Transfer
Forums
Search Forum
Search
Advanced Search
Topics
Posts
Unanswered
Active Topics
Forums
>
DotNetNuke Support
>
DotNetNuke Support
Reply To Topic
Topic:
Database size is Way Too Big
Username:
Security Code:
Enter the code shown above in the box below.
Subject:
RE: Database size is Way Too Big
Message:
[quote] Posted By <span class='af-profile-name'>Deleted User</span> on 3/16/2012 10:17 AM If your DNN database size has grown out of control, the following article might help you. It is about the search feature creating excessive entries in database and how to clear the index out to reclaim the space. Credits to Will Strohl. http://www.willstrohl.com/Blog/EntryId/576/Saving-Database-Space-in-DotNetNuke-Clearing-the-Search-Index TRUNCATE TABLE [dbo].[SearchItemWordPosition] DELETE FROM [dbo].[SearchItemWord] DELETE FROM [dbo].[SearchWord] DELETE FROM [dbo].[SearchItem] And here is a second link that shows us how to clear the search index tables without truncating them. http://weblogs.asp.net/christoc/archive/2006/06/26/DotNetNuke-Daily-Tip-_2300_3-6_2F00_26_2F00_06-Clear-Search-Tables.aspx delete SearchItemWordPosition where SearchItemWordId in (select SearchItemWordId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem)) delete SearchWord where SearchWordsId in (select SearchWordsId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem)) delete SearchItemWord where SearchItemId in (select SearchItemId from SearchItem) delete SearchItem here's objectQualifier included code delete {objectQualifier}SearchItemWordPosition where SearchItemWordId in (select SearchItemWordId from {objectQualifier}SearchItemWord where SearchItemID in (select SearchItemId from {objectQualifier}SearchItem)) delete {objectQualifier}SearchWord where SearchWordsId in (select SearchWordsId from {objectQualifier}SearchItemWord where SearchItemID in (select SearchItemId from {objectQualifier}SearchItem)) delete {objectQualifier}SearchItemWord where SearchItemId in (select SearchItemId from {objectQualifier}SearchItem) delete {objectQualifier}SearchItem [/quote]
Smilies
Submit
Cancel
Subscribe:
Check the box to receive email notifications for this topic.
Topic Review
Deleted User
New Member
Posts:62
3/16/2012 10:17 AM
If your DNN database size has grown out of control, the following article might help you. It is about the search feature creating excessive entries in database and how to clear the index out to reclaim the space.
Credits to Will Strohl.
http://www.willstrohl.com...ing-the-Search-Index
TRUNCATE TABLE [dbo].[SearchItemWordPosition]
DELETE FROM [dbo].[SearchItemWord]
DELETE FROM [dbo].[SearchWord]
DELETE FROM [dbo].[SearchItem]
And here is a second link that shows us how to clear the search index tables without truncating them.
http://weblogs.asp.net/ch...r-Search-Tables.aspx
delete SearchItemWordPosition where SearchItemWordId in (select SearchItemWordId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem))
delete SearchWord where SearchWordsId in (select SearchWordsId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem))
delete SearchItemWord where SearchItemId in (select SearchItemId from SearchItem) delete SearchItem
here's objectQualifier included code
delete {objectQualifier}SearchItemWordPosition where SearchItemWordId in (select SearchItemWordId from {objectQualifier}SearchItemWord where SearchItemID in (select SearchItemId from {objectQualifier}SearchItem))
delete {objectQualifier}SearchWord where SearchWordsId in (select SearchWordsId from {objectQualifier}SearchItemWord where SearchItemID in (select SearchItemId from {objectQualifier}SearchItem))
delete {objectQualifier}SearchItemWord where SearchItemId in (select SearchItemId from {objectQualifier}SearchItem) delete {objectQualifier}SearchItem