Register | Log In
Download Contact
Resources > Forums
HomeHomeGetting StartedGetting StartedInstalling DotN...Installing DotN...SearchItemWordPosition table takes up most of the databaseSearchItemWordPosition table takes up most of the database
Previous
 
Next
New Post
12/7/2011 6:19 PM
 
User is offline Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 36759
Support Novado wrote:
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

 yes, please give it a try

Cheers from Germany,
Sebastian Leupold (DotNetNuke MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group   European Network of DotNetNuke Professionals
 
New Post
4/16/2012 2:41 PM
 
User is offline Jon


Joined: 4/16/2012
Posts: 20
Sebastian Leupold wrote:

you may use this procedure to clear your search tables.

I am investigating the current behaviour.

 Would it not be better to drop the tables, rather than delete them, so that the deletion of the potentially millions of records is not logged?

It seems to me that it would be best practice, in this case, to drop the tables.

truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition
DROP {databaseOwner}{objectQualifier}SearchItemWord
DROP {databaseOwner}{objectQualifier}SearchWord
DROP {databaseOwner}{objectQualifier}SearchItem
 
New Post
4/16/2012 6:58 PM
 
User is offline Chris Hammond


Chris Hammond's Avatar

www.chrishammond.com
Joined: 1/14/2003
Posts: 6656

I wouldn't recommend dropping any tables that'll cause issues if you don't get them properly recreated. I would recommend truncating if possible

Chris Hammond
dnnCHAT.com a chat room for DotNetNuke discussions
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
 
New Post
4/17/2012 3:09 AM
 
User is offline Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 36759
tables with existing foreign key constraints cannot be dropped or truncated, but you may drop the constraint, truncate the table and recreate the constraint. You need to ensure after every DNN upgrade, whether the contraint definition has changed and you need to adopt your re-creation statement for it.
Cheers from Germany,
Sebastian Leupold (DotNetNuke MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group   European Network of DotNetNuke Professionals
 
New Post
2/26/2013 9:26 AM
 
User is offline rmaza


Joined: 2/26/2013
Posts: 1
Hello,

I have the same issue, version of dnn is 06.02.03.

I cleared the search tables but are refilled quickly.

It's the same thing that happens to Mark, I have duplicates by position.

Many thanks.
 
 Page 7 of 8
Previous123...678Next 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DotN...Installing DotN...SearchItemWordPosition table takes up most of the databaseSearchItemWordPosition table takes up most of the database


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

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

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

Attend A Webinar
Start Professional Edition Trial
Have Someone Contact Me

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

Sponsors

DotNetNuke Corporation

DotNetNuke (DNN) provides a suite of solutions that make designing, building and managing feature-rich sites and communities fast, easy and cost-effective. The DotNetNuke Platform CMS is the foundation for more than one million websites worldwide. DNN Social, our newest solution, enables businesses to create immersive, interactive communities. Thousands of organizations like True Value Hardware, Bose, Cornell University, Glacier Water, Dannon, Delphi, USAA, NASCAR, Northern Health and the City of Denver have leveraged DNN to deploy highly engaging business- critical websites. Our rapid growth in product sales and deployments resulted in DotNetNuke Corp. being named one of the fastest growing private companies in America by Inc. Magazine in 2011 and 2012.
Copyright © 2002-2013 DotNetNuke Corp. / Terms of Use / Privacy
Hosted by MaximumASP