What is the best way to purge the SiteLog DB?

Home ›

ASP.NET Forums » Starter Kits and Source Projects » DotNetNuke » What is the best way to purge the SiteLog DB?

Shortcuts

Previous Next

What is the best way to purge the SiteLog DB?

Last post 01-01-2006 12:51 AM by TimGT. 4 replies.

Sort Posts:

What is the best way to purge the SiteLog DB?

12-29-2005, 10:33 PM

Contact

520 point Member
TimGT
Member since 11-05-2005, 4:10 PM
Posts 104

Hello,

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?

Thanks!

Re: What is the best way to purge the SiteLog DB?

12-30-2005, 4:38 AM

Contact

335 point Member
dawoe
Member since 03-26-2005, 2:02 PM
Belgium
Posts 69

You can activate a scheduled task for this. You can find it under the host menu and the scheduler menu.
There are several tasks that you can activate here.

Re: What is the best way to purge the SiteLog DB?

12-30-2005, 12:44 PM

Contact

13,648 point Star
cathal
Member since 06-18-2002, 4:02 PM
Belfast, Northern Ireland
Posts 2,702

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.

Cathal