You are viewing limited content. For full access, please sign in.

Question

Question

Reducing size of tables?

Updated June 10, 2014
asked on June 10, 2014

One of our customers is asking about reducing the size of their propval and searchresult(#) tables (their propval table has over 80 million rows).  

 

I know that the propval table contains the field values, so I'm wary of advocating messing with it...  Is there any documentation that either explains what is safe to do, or recommends against it?  Any purging/archiving processes or anything like that?

 

Thanks very much!

0 0

Answer

SELECTED ANSWER
replied on June 10, 2014

The searchresult tables are used as temporary storage for search results. The data is deleted when the search is complete.

 

The propval table contains the field data, as you noted, so you can't just clear it out. They can prune their templates of unneeded/unwanted information and that would reduce the size of the propval table. Depending on the number of entries in the repository, 80 million rows is not unexpected in this table. And as long as its indexes and statistics are properly maintained, you shouldn't see performance problems. Why would you want to reduce its size?

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...