Forum


HomeHomePremiumPremiumAdministrationAdministrationdnnHeroCleanUpdnnHeroCleanUp
Previous
 
Next
New Post
5/5/2014 5:38 AM
 

I ran your script against my website but it did not reduce the database.  In your script you truncate the the ScheduleHistory, EventLog and the SiteLog tables.
In my case I am trying to reduce the size of the SearchItemPosition table which according to my hosting provider has grown to over 768MBs.   

Can your script be modified to achieve this or is there something else that has to be done?


Dave

  

 
New Post
5/5/2014 7:55 AM
 

Hi Dave,

If your site doesn't use or doesn't have the search box, which usually comes included in some skins, then you can add:

TRUNCATE TABLE {objectQualifier}SearchItemPosition

in that script right after 

TRUNCATE TABLE {objectQualifier}SiteLog


This will clean up that table.

But on top of that you should also deactivate the Search Engine Scheduler cause if you don't, that table will grow again.

BTW, I think the table name is "SearchItemWordPosition", not "SearchItemPosition"

Best regards,

Aderson

 
New Post
5/5/2014 9:59 AM
 

This site is using the Search Box.  Is there another way to reduce the size of this table?


Dave


 
New Post
5/5/2014 11:12 AM
 

Hi Dave,

If the site uses the search, it will index its content. Then it will require that table with all the content it is there now.

If you would like, send me the login information to the site so I can take a closer look, but I don't think there is much to be done.

Send it to my email: aderson [at] dnnhero [dot] com

Cheers,

Aderson

 
Previous
 
Next
HomeHomePremiumPremiumAdministrationAdministrationdnnHeroCleanUpdnnHeroCleanUp



Try FREE
30 days money back guaranteed