We have had the following issue reported by a customer related to DNN database growing excessively fast and large (gigabytes in a week or so):

 There is a bug in DotNetNuke it seems. Take a look at these pages:

http://www.dnncreative.com/Forum/tabid/88/forumid/4/tpage/1/view/topic/postid/19166/Default.aspx#19184

http://support.dotnetnuke.com/issue/ViewIssue.aspx?ID=10761


In the meantime I have run this over my database:

truncate table dbo.SearchItemWordPosition

delete dbo.SearchItemWordPosition

SearchItemWordPosition is the offending table. Mine had 992 million rows!!! Even as I type this the empty table has grown to 172,000 rows (in about 5 minutes).

I have created a DNN report page so I can run the truncation remotely with a mouse click which is a nice workaround, but I would like to stop the table growing as I’m sure you would too!

3Essentials takes no responsibility for the impact of truncating or deleting the specified table, and recommends you contact dotnetnuke.com for information on this issue and any corrective actions.