Page 2 Dtabase clean up - Administration and Configuration

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

1
2
3
4
5

4/1/2010 8:43 PM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Dtabase clean up

Yehuda Tiram wrote:

You may use the following:

Clear search tables (Not sure up to what DNN version it is good):

delete SearchItemWordPosition where SearchItemWordId in (select SearchItemWordId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem))
delete SearchWord where SearchWordsId in (select SearchWordsId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem))
delete SearchItemWord where SearchItemId in (select SearchItemId from SearchItem) delete SearchItem

Clear eventlog

TRUNCATE TABLE eventlog

Clear Site Log

TRUNCATE TABLE sitelog

please always use variables in published scripts:

go to SQL in Host menu and paste/run each of the following statements:

TRUNCATE TABLE {databaseOwner}{objectQualifier}EventLog

TRUNCATE TABLE {databaseOwner}{objectQualifier}SiteLog

For clearing search tables, please read here: http://www.deutschnetnuke.de/AboutDotnetNuke/V3V4TippsTricks/Suchindexlöschen.aspx

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

4/1/2010 10:33 PM

Sam Erde

IOpenning.com
Joined: 11/16/2005

Posts: 49

Re: Dtabase clean up

I agree that clearing the logs will likely solve your problem. Once you get some space freed up, download and install the Scheduled SQL Jobs module from Iowa Computer Gurus at http://www.iowacomputergurus.com/free-products/dotnetnuke-modules/scheduled-sql-jobs.aspx. This will take care of the job on a regular basis for you. Good luck, and let us know how it turns out!

4/2/2010 4:06 AM

Yehuda Tiram

Joined: 12/3/2004

Posts: 362

Re: Dtabase clean up

Sebastian,

Do you think the search tables cleaning script I posted is wrong?

Yehuda Tiram
AtarimTR

972-2-5700114 | 972-54-4525492 | http://www.atarimtr.co.il

4/2/2010 6:27 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Dtabase clean up

Yehuda, I don't think your script is wrong, but in this case, simply truncating tables or delete unconditionally will be much faster (and have no risk of timing out). Subqueries are not optimal from performance point of view, if possible replace it by joins.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

4/2/2010 11:04 AM

Yehuda Tiram

Joined: 12/3/2004

Posts: 362

Re: Dtabase clean up

Got it. thanks.

Yehuda Tiram
AtarimTR

972-2-5700114 | 972-54-4525492 | http://www.atarimtr.co.il

Page 2 of 5

...5

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)