Emptying the Search Tables

Emptying the DotNetNuke search tables can considerably reduce the size of the DotNetNuke database. It requires access as a host superuser.

Having emptied the search tables they will be re-populated, but better optimised, with less items which are old.

To delete the existing DotNetNuke indexed content execute the following four lines, from the Host>SQL page

truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition
delete {databaseOwner}{objectQualifier}SearchItemWord
delete {databaseOwner}{objectQualifier}SearchWord
delete {databaseOwner}{objectQualifier}SearchItem

The content of the site will be re-indexed by the scheduled task (every 30 minutes by default), or it can be triggered from the Host>Search Admin page. Click on Re-index Content

Version 5 of the Reports module caused an error with the indexing. To fix this turn off the indexing by issuing the following command on the Host/SQL page:

update {databaseOwner}{objectQualifier}desktopmodules set SupportedFeatures = 1 where FriendlyName = 'Reports'