Program taking too much time to execute

srivijay_dinnimath — Thu, 18 Dec 2014 11:11:41 GMT

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

Re: Program taking too much time to execute

krishna_k19 — Thu, 18 Dec 2014 11:32:11 GMT

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

topic Re: Program taking too much time to execute in Application Development and Automation Discussions

Program taking too much time to execute

Re: Program taking too much time to execute