topic Re: RFC_READ_TABLE performance in Application Development and Automation Discussions

RFC_READ_TABLE performance

Former Member — Fri, 04 Sep 2009 14:27:28 GMT

All,

I'm using this standard FM RFC_READ_TABLE to access data from several tables in another SAP system.

I have to call this function module 4 times one each for VBAK, LIKP, LTAK and MKPF tables.

I would like to know if there would be any performance issues if this FM is called several times for different tables.

Please help.

Meghna

Re: RFC_READ_TABLE performance

HermannGahm — Fri, 04 Sep 2009 14:40:01 GMT

Hi,

if you do one call per table it depends on the data volume that has to be read from each table

and how this tables are accessed in the remote system (where clause and indexes).

Setup a SQL Trace in the remote system to see how the tables are accessed.

The transfer time of the rfc depends mainly on the data volume in this case.

Kind regards,

Hermann

Re: RFC_READ_TABLE performance

Former Member — Sun, 06 Sep 2009 05:06:25 GMT

Meghna,

The RFC_READ_TABLE FM will not cause performance issue just for using multiple times. It is very important how you set the selection filters in the FM parameters. Set this parameter considering primary & secondary index while calling RFC for each table. This will keep source system performance good. Remember, RFC performance degrades exponentially with increase in data volume. So ensure minimum data is returned. This will ensure good RFC call performance.

BR,

SB.

Re: RFC_READ_TABLE performance

former_member251078 — Mon, 07 Sep 2009 15:26:30 GMT

RFC tables are high volatile tables. So you need to rebuild the indexes corresponding to RFC tables. Also if you are using Oracle as backend system, there are seperate statistics provided for these tables, these should be take care to improve the performance.

Yours Sincerely

Dileep

Re: RFC_READ_TABLE performance

HermannGahm — Mon, 07 Sep 2009 17:45:22 GMT

Hi Dileep,


> RFC tables are high volatile tables. ...
> Dileep

While this is right for RFC status tables like e.g. ARFCSTATE and others, the OP asked

> for VBAK, LIKP, LTAK and MKPF tables

and these are not volatile...

Kind regards,

Hermann

Re: RFC_READ_TABLE performance

Former Member — Tue, 08 Sep 2009 04:16:18 GMT

Hi Megha ,

I would suggest to create you own remote FM with desired functionality and fetch the data of all four tables in one call.

Select data from these tables based on your conditions , this will reduce the data fetched each time.

It should give you some improvement in performance.