How to Delete DNN Useless Data and Clean the Search Index?
  retweet   

1.  DNN daily cleanning:

 

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

 

 

 

 

 



Comments

No comments so far. Be the first to post one.


Leave a comment

Name (required)

Email (required)

Website

CAPTCHA image
Enter the code shown above:

LatestArticles