Rfc Executing take time for first time.

[Former Member]

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]

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]

Hi,

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

It will reduce the time..

regards,

lavanya

[Former Member]

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-