Skip to Content
author's profile photo
Former Member

DB View Performance enhancement

Hi All,

Client has a database view for a generic extraction of master data that has been running for sometime. It is a daily full load, which gets in records somewhere around 500,000 to 800,000 records. Now the complaintis that the load takes a long time and the window they have is

just 6hrs. He wants to investigate the view and see what can be done to minimize the load time.

Can someone tell me what are the best ways to make the view effective?

Is there any other way of generic extraction that would be more effective than the view?

is there any tweaking that needs to be done to enhance the load performance?

Thanks,

Mav.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Sep 30, 2005 at 12:04 AM

    Maverick,

    First check if you can split the load into small selections and do a parallel loads. Do the change run at the end of these loads. Make sure there is enough memory in the source system to handle all four jobs at the same time.

    On the source system tables check if your are running any statistics, else run statistics on these base tables.

    Also check table entries for ROIDOCPRMS - Control parameters for data transfer from the source system. Check with basis if you can increase the parallel Processors to speed up the extraction process.

    These are just few initial stepsÂ…

    Hope this helps..

    Sridhar.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 03, 2005 at 06:48 AM

    Hi Mav,

    take a look at the SQL statement execution of the extraction with ST05 trace option. It should put in evidence where it looses time ...

    Hope it helps

    GFV

    Add comment
    10|10000 characters needed characters exceeded