Regarding Time taken For data loading

[Former Member]

hai

just tell me approximately

How much time taken for loading some data records like

1-million data records----

---

how much time taken

to load the data

10-million data records -

---

??

like that

pls tell me

txs

rizwan

[Former Member]

hey hey hey,.. pls. dont disturb.. let it run....it will definitely take more time , ... not just 20 mins.

There are loads that can go for hours,... since this has more number of records,... you should wait ok?

Thanks,

Raj

[Former Member]

hai raj

im loading text data for one characteristic..

it has 1-million data records

since 20 minutes it is loading the data

So is it takes like that more time .

If not , pls tell me what i have to do ..

i ll assign the points

bye

rizwan

[Former Member]

Hi Rizwan

It's not unusaul that load of 1 million records is running for 20 mins. Be patient on this.

You should always carry these data loads in background mode . GO to Infopackage change mode->Schedule tab ->Select option button "Start later in background" and in next screen schedule it immediately. This will ensure that your job will not be timedout. Using other option the data loading job runs in dialogue mode and it can timed out.

Regards

Pradip

[Former Member]

so,, you are talking about data loading performance ...

well sir,, pls. see if this helps.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3a699d90-0201-0010-bc99-d5c...

• assign points if useful **

Thanks,

Raj

[Former Member]

hai

And tell me ,how can i monitor the time taken for data loading and how can i reduce the time...

pls tell me

txs

rizwan

[Former Member]

You can monitor the time taken for data loading in RSA1-> Monitor for that infosource. Here in monitor screen go to header screen and you can find time in Runtime.

While loading to Cube, delete the indexes before loading a new request.This way you can reduce the data load time.

Regards

Pradip