Skip to Content
author's profile photo Former Member
0
Former Member

Data loading time too long

Posted on Sep 30, 2005 at 02:07 PM 12 Views

Hi there,

I have two Infopackages - one for year 2003 and one for year 2004. For year 2003 I use interval 200301-200312 and for year 2004 I use interval 200401-200412 as data selection. Then I started to load data from R/3. For year 2003 we have 4.9 Millions records and took 6 hours to load and for year 2004 we have 5.5 Millions records and took 46 hours to load. The interesting thing was that when I tried to use InfoPackage 2003 and put the interval 200401-200412 as data selection for loading 2004 data, it took only 7.x hours! Why? Is something wrong with the InfoPackage for 2004? Any idea and suggestion is greatly appreciated.

Weidong

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 30, 2005 at 04:20 PM
    0

    Hi Weidong,

    Check the processing type in both the infopackages. May be one of the infopackages has "PSA and then into Data Target" and the other infopackage has "PSA and Data Target in parallel".

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 30, 2005 at 04:46 PM
    0

    Hi there,

    Both load into PSA only. Any ideas? Thanks!

    Weidong

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Eugene Khusainov
    Eugene Khusainov
    Posted on Oct 01, 2005 at 06:45 AM
    0

    Hi,

    It might be related to DB space: different infopackages may use different table spaces with different volumes. Try to contact your basis guy.

    Best regards,

    Eugene

    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.