Last post Jan 01, 2006 12:51 AM by TimGT
Dec 29, 2005 10:33 PM|TimGT|LINK
My SiteLog DB has 611,506,332 entries in it. What is the best way to purge this? I recall simply deleting everything in the SiteLog DB in the paste but I think that messed something up.
Anybody know how I can correctly drop all those items?
Dec 30, 2005 04:38 AM|dawoe|LINK
Dec 30, 2005 12:44 PM|cathal|LINK
use truncate table, rather than delete ... , it's much faster and doesn't log individual row deletes i.e. do "truncate table sitelog" . There is a scheduled task "DotNetNuke.Services.Log.SiteLog.PurgeSiteLog, DOTNETNUKE" designed to do this, log in as host,
and go to host->schedule, and make sure it's enabled.
Jan 01, 2006 12:49 AM|TimGT|LINK
Jan 01, 2006 12:51 AM|TimGT|LINK
Actually I just noticed.. I enabled " DotNetNuke.Services.Log.SiteLog.PurgeSiteLog, DOTNETNUKE " and it says "Site Log purged."
Yet I still have close to a billion entries in my SiteLog table.