topic Re: Rfc Executing take time for first time. in Application Development and Automation Discussions

Rfc Executing take time for first time.

Former Member — Wed, 28 May 2008 12:53:04 GMT

Dear all,

I creat a one rfc

FUNCTION ZPIM_EDI_PULL_GRDATA.

*"----

""Local Interface:

*" IMPORTING

*" VALUE(IMP_EDINO) LIKE YPIMT_GRUNLOAD-COUNTER

*" TABLES

*" EDI_GR STRUCTURE ZEDI_ICS_GR

*"----

SELECT * FROM YPIMT_GRUNLOAD

INTO corresponding fields

of table EDI_GR

WHERE counter = IMP_EDINO.

ENDFUNCTION.

when i Executing this program it will take time for first and second time but after 2 ,3 execution it become fast.

Can any suggest be why this problem is coming.

Regards

girish

Former Member — Wed, 28 May 2008 12:56:54 GMT

Hi,

Instead of using * , use the field names...

It will reduce the time..

regards,

lavanya

Former Member — Wed, 28 May 2008 12:56:57 GMT

Hello,

This is because the first time is not on the db buffer. In order to do a faster stm, try avoiding INTO CORRESPONDING FIELDS, it is slow.

Bye

Gabriel P-