1. DNN daily cleaning:
Go to host>SQL (run as script)
====================================================
Truncate table {databaseOwner}{objectQualifier}Eventlog
Truncate table {databaseOwner}{objectQualifier}SiteLog
Truncate table {databaseOwner}{objectQualifier}ScheduleHistory
Truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition
========================================================
2. Reindex DNN site's search:
First clean up the tables: host>SQL>run as script:
=========================================================
Delete {databaseOwner}{objectQualifier}SearchItemWordPosition
Delete {databaseOwner}{objectQualifier}SearchItemWord
Delete {databaseOwner}{objectQualifier}SearchWord
Delete {databaseOwner}{objectQualifier}SearchItem
==================================================
Then re-index the content:
Host>search admin>re-index the content
Thanks to:
http://www.dnnskin.com/KnowledgeBas...index.aspx