Menu
Forums > DotNetNuke Support > DotNetNuke Support
Reply To Topic Topic: Database size is Way Too Big
:
Posted By Deleted User 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
Username:
Security Code:
CAPTCHA image
Enter the code shown above in the box below.
Subject:
RE: Database size is Way Too Big
Message:
Smilies

Submit

Cancel
Subscribe:
Topic Review