Program taking too much time to execute

[srivijay_dinnimath]

Hi Experts,

There is a requirement to delete some Open text files from the server. For that I am using below 2 FMs.

1.  ARCHIV_CONNECTINFO_GET_META  - To read fetch the file details

2.  ARCHIV_DELETE_META                        To delete the file

We have one custom table which contains key( object_id) for all the files(And this custom table contains million records in Production system).

And logic I am using to delete those file is,

1. Fetch the object_id from the custom table

2. Pass it to 1st FM with  sap_object.

3. Then pass outcome value from 1st FM to 2nd FM.

Initially I had used select statement with package size 1000. But this program was taking more than 4Hrs to execute in Non-production systems with 25000 data in custom table. And again executed the program by increasing the package size by 50000, but no use.

I can't run this program without using Packet size logic, as it will give TIME OUT dump.

Please suggest me if there is any alternate solution for this.

Regards,

Srivijay

[krishna_k19]

Hi Vijay,

    While fetching data from the table are you using all primary keys , if not then include those one and try.

And second thing , if part from primary keys if you are or you can use other keys means go with index .

Regards,

Krishna