Skip to Content

BPC Housekeeping related to comments, BPF and work status

Hi All,

BPC 10 on HANA.

For one of our clients, we have huge data in the system and it is becoming difficult to keep up the performance as well as things related to housekeeping. We are doing things like lite optimize, transaction data archival, etc. already. What I am trying to understand is if there is a standard process for housekeeping related to comments, BPF and work status and whether will it really improve the performance of the system?

I read about comments tables - CMT and CMTA and that there is a class CL_UJC_CMTMANAGER whose method ARCHIVE_CMT can be implemented to move old comments from CMT to CMTA table. I would like to understand if this moving of comments from comments to archive table impacts performance?

Further, are there any similar activities for work status (apart from delete locks) and BPF as well?

Regards,

Ashish

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 13, 2016 at 09:40 AM

    Hi Ashish,

    I don't think that work status tables can significantly affect performance... Same story about comments - do you have a huge number of comments? You have to test the performance effect yourself using copy of the environment...

    Vadim

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.