BDC Session method performance.

[Former Member]

Dear Gurus,

I am using bdc session method to upload about 300000 records. My bdc is working fine but i am worried about the record load.

Questions

1) how to know how much time it will take to upload 300000 records .Number of fields to upload are 23 and it will use only two screens.

2) how to see my code performance before uploading data .

3) Is it possible to see how many records are processed and how many records still need to be processeds when we select background mode to upload data while background job is still in processing. If yes please tell me how to see.

4) Can we process incorrect records from sm35 itself.

5) If we want to stop processing how to stop processing in between uploading.

Help greatly appreciated.

Thanks in advance.

Regards

Dave

Edited by: Devendra Sharma on May 23, 2008 8:04 PM

[naimesh_patel]

1) how to know how much time it will take to upload 300000 records .Number of fields to upload are 23 and it will use only two screens.

- Take a wild guess of multipling small chunk of data. Eg. time to upload 1000 records and mulitply it. But it will be a wild guess only.

2) how to see my code performance before uploading data .

- Try to upload small chunk first in your system or upload all the data in the Quality / testing environment.

3) Is it possible to see how many records are processed and how many records still need to be processeds when we select background mode to upload data while background job is still in processing. If yes please tell me how to see.

- Using SM35. Open your session, you will see the status of each transaction

4) Can we process incorrect records from sm35 itself.

- Yes. Thats advantage of the SM35.

5) If we want to stop processing how to stop processing in between uploading.

One job will be created with the same name as session name when you run the session in background mode. You can kill the session in SM37. But it is not advisable.

Regards,

Naimesh Patel