topic Re: which is better ? in Application Development and Automation Discussions

which is better ?

Former Member — Thu, 07 Dec 2006 06:27:54 GMT

Hi Friends ,

During BDC for huge no. of records which method is better ?

Call Transaction or Session ? why ?

thanx ,

Senthil

Re: which is better ?

Former Member — Thu, 07 Dec 2006 06:31:41 GMT

Hi Senthil

Depends on various factors:

1. Frequency of the data upload

2. Nature of data(Master/Transactional)

3. User or Support Maintenace to handle incase of errors.

Though personally, i would recommend SESSION method for easy handling and re-processing incase of errors.

Kind Regards

Eswar

Re: which is better ?

Former Member — Thu, 07 Dec 2006 06:33:08 GMT

If the number of records r so high then its better to go with session method because call transaction method will not be preferable with the so many records

Generally I prefer to use SESSION method because the system gives a log and automatically creates a new session for all trxs failed.

In session method processing and updating the records fallow the synchronous methond where as in case of call transaction it fallows processing in synchronous and updating in asynchronous method.

you can process multiple applications at a time in session method where as in call transaction it is not possible.

Some more informations is available here

http://www.sap-img.com/abap/difference-between-batch-input-and-call-transaction-in-bdc.htm

call transaction doesnot have logfile concept where as session method will have by default, in call transaction u have to desing that explicitly

Re: which is better ?

Former Member — Thu, 07 Dec 2006 06:37:41 GMT

If you have more number of records then session method would be preferable

because in this all the records will be processed only one at a time and the total session after processing all the records then goes to data base for the updating so as in call trasaction method session willnot wait until each and every records updated in the data base and gives the response back

so if the session moves to the data base for each n every record for updating the traffic at the database level increases so the speed of the process decreases

where as in session method whole session will be processed once in the application and after completion of this session will goes to the data base only once for updating because of this network traffic decreases

so this process would be better

when u take the case of erros, those will be collected in the log file so that u can reprocess those in session method... further

not only that if u have so many records there would be a possibility to process those records more than one application at that time session method would be compatable for that

where as CT method will not support multiple application processing

if u find it useful mark the points

Regards,

Naveen