Skip to Content

Index Steps in Daily Batch

Dear All,

We have a Process Chain which runs daily in Production system. As the performance is not so good we are planning to see if it is possible to take out the Index Drop and Creation step which is taking about an hour , from daily run and if we can run those some other time.

My question is:

1. Is this good/possible to do by taking out from daily run?

2. Will this actually improve performance?

3. Will the reporting/reports be impacted then?

4. If we plan to run some other time then will in impact the data in info providers?

Kindly suggest.

Regards

Zabi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 22, 2015 at 02:14 PM

    Hi Syed

    Before answering your questions, I would like to know which step is taking long time. Creating index or deleting index. And how many cubes are involved in the variant.

    If deleting index is taking long time, your questions are right and below is the answer.

         1. Is this good/possible to do by taking out from daily run?

    Don't remove the step from the process chain, because index deletion and creation is very much important to important for data load performance, but you could create a separate process chain which has only delete index step with which you could save some time

         2. Will this actually improve performance?

    This will not improve performance. On the other hand, this will decrease the performance

         3. Will the reporting/reports be impacted then?

    Reports will have impact if you haven't create index after loading the data. Since index plays a main role in data selection

         4. If we plan to run some other time then will in impact the data in info providers

    This is what I would recommend. You are right. you can delete index before any process chains starts, but after business hours.

    If index creation job is taking long time, then you should help from Basis team as well as this will be impacted by DB configurations.

    Let us know first which is creating issue. Then we will discuss further

    Regards

    Karthik

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member syed zabiullah

      Hi Syed,

      it is not a best approach to run 4 process chain in parallel specially when there is no load balancing (only one application server). because each process chain may have multiple steps (ex: del index, infopackage, dtp, etc etc as per your requirement)

      when you run 4 proess chains parallel, each process variant from each chain will run in background, which may occupy all of your background jobs which not only be a huge load on the system, but will downgrade the system performance. you will end up seeing each chain taking much more longer time to finish.

      please run the process chains always one after another, also make sure you are scheduling them after a certain time gap. may be 30 mins.. depends on your business call.