Page 6 SearchItemWordPosition table takes up most of the database

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

Home

Getting Started

Installing DNN ...

SearchItemWordPosition table takes up most of the database

10/6/2010 2:12 PM

Sebastian Leupold

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

Posts: 46212

Re: SearchItemWordPosition table takes up most of the database Modified By Sebastian Leupold on 10/6/2010 2:14:26 PM

this looks like numerous duplicates, i.e. the original issue has not been fixed. you may modify AddSearchItemWordPosition module to avoid duplicates, e.g. by substituting final insert statement by a Merge statement avoiding duplicates:

MERGE INTO {databaseOwner}{objectQualifier}SearchItemWordPosition T
  USING @TempList S ON (T.SearchItemWordID = S.ItemWordID AND T.ContentPosition = S.Position)
  WHEN NOT MATCHED THEN
   INSERT (SearchItemWordID, ContentPosition)
   VALUES (ItemWordID, Position)

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

6/7/2011 9:42 PM

Dave Lalande

www.davelalande.com
Joined: 1/17/2008

Posts: 134

Re: SearchItemWordPosition table takes up most of the database

I am going to be moving my server needs to the cloud. I started looking over my db storage needs and I find these SearchItemWordPosition table and associates to have 58 million rows and 45 million rows. How do I fix this after truncating using 5.6.x DNN?

6/8/2011 7:47 PM

Sebastian Leupold

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

Posts: 46212

Re: SearchItemWordPosition table takes up most of the database

are you using latest version of DNN?
did you modify stored proc as stated before?

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

6/10/2011 3:02 AM

Feraya510

Joined: 6/9/2011

Posts: 2

Re: SearchItemWordPosition table takes up most of the database

- Please validate, large content is not indexed multiple times.

- Validate the terms in Search items table and adopt stop words.

[url=http://www.cheapesthandbagsforsale.com/goods-177.html]purchase chanel handbags[/url]
[url=http://www.cheapesthandbagsforsale.com/goods-176.html]chanel handbags collection[/url]

12/5/2011 4:07 PM

Matthias Wemel

Joined: 1/7/2011

Posts: 12

Re: SearchItemWordPosition table takes up most of the database

Sebastian,

We suffer the same issue (5.6.1).

The merge statement you've mentioned above does not appear in die stored procedure of the DNN 6.X database. Is it solved there?

So we just have to replace the INSERT statement with the MERGE statement?

Kind regards

Page 6 of 8

...5

SearchItemWordPosition table takes up most of the database

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)