Reduce the execution time

[Former Member]

Hi Experts,

Greetings!!

I have a se38 'Z' program While F8 it will trigger to smart form and download using GUI_DOWNLOAD as PDF format and it was download based on the Customer and Date (For Ex:In Selection screen Input parameter is like Customer 001 to 005 and Date is 17.02.2014 to 18.02.2014.In DB for the Customer 001 to 005 has 5 (Means Each customer has 1 document )Invoice document for 17.02.2013 and 18.02.2013 as well) So totally 10 invoice document has to be downloaded.After the all validation and calculation and manipulation having one Final Internal Tabel having these 10 Records.So the way of coding written is Looping the final table for Each record, First PDF conversion and then GUI_DOWNLOAD is happened.So If we run for One month date it will take Huge Time for Executed.Sometimes it leads to Dumps as well..

I feel for Download time is taken more time because if suppose 1000 records 1000 times loop will be executed..Please Suggest how to improve the performance..Is there anyway to optimize the code for better performance...

Help ful answer will be awarded...

Thanks,

CM Raj.

[Former Member]

Hello,

use transaction SAT for runtime analysis.

If only the download is a problem maybe try to export pdf with

the function module CONVERT_OTF_2_PDF

and write the file with OPEN DATASET because GUI_DOWNLOAD isnt the best solution.

(Creating PDFs always take a while 1000 pages take ~30mins on our system)

Regards Nico

[Former Member]

Thanks Nico..

In SAT i run the program.I am not able to understand where the exact time delay in program.Herewith i attached SAT screen shot.

after execution the total downloaded file is 114 files and size is 21MB.

Please suggest me Whether the time taken is only in Download part.

[Former Member]

Hi experts,

For downloading to local desktop other than GUI_DOWNLOAD will reduce the time taken.Is there any option is there? OPEN DATA SET is used only for App server files? For my case i have final Internal table from this for each file i need to download all data from Internal table.Is any alternative way is there to achieve instead of using GUI_DOWNLOAD?