topic Re: Modifying Query program in Application Development and Automation Discussions

Modifying Query program

Former Member — Tue, 29 May 2007 09:20:07 GMT

Hi All,

When I modifed the query genarated program(copied to SE38), by adding additional 2 fields.. the performance of the program became very bad..

the actual program is taking 44 seconds.. where as modified program is taking

1600 seconds..

when I tried to find the problem, the data selection(select stmts) is very fast.. but the read statements inside the loop taking very much time eventhough I used binary search or hashed key internal table.. even the display statements also taking very long time..(The records it is printing is 40k).. so in debugging I am not finding any difference..

Is there any solution for this.. what might be the actuall problem

Please help me..

Thanks in advance..

Re: Modifying Query program

Former Member — Tue, 29 May 2007 09:24:06 GMT

Why you modified the Query program?

Were the needed fields which you added were not there in those tables

You can verywell change the query/infosets and add the fields/delete the fields as per you requirement?

Better to change the query/infoset instead of modifying the query related program.

Try to read the Tables in the loop with the correct key fields to avoid time taking.

Reward points if useful

Regards

Anji

Re: Modifying Query program

Former Member — Tue, 29 May 2007 09:25:34 GMT

Hi Haritha,

If you are looping at the internal table with header line and which container k's of record then will need(take) lot of time to be printed, what you can do is you can use fieldsymbols or workarea to reduce a bit of run time.

Regards,

Jayant

Re: Modifying Query program

Former Member — Tue, 29 May 2007 10:00:31 GMT

Hi,

I added the fields PO Released person name, where I can find this value from CDPOS and CDHDR.. I added some fields by adding to field groups of query.. those are not causing problem..

but when I tried to add PO Released Person it is giving problem..

how to change the query infoset for this field..

Thank you