topic Re: Can this statement be optimized? in Application Development and Automation Discussions

Can this statement be optimized?

Former Member — Tue, 20 Jan 2009 06:00:27 GMT

loop at lt_hide_log_list into ls_hide_log_list.

delete table et_save_log_customizing from ls_hide_log_list.

endloop.

Thanks for helping.

Best regards,

Lament

Re: Can this statement be optimized?

Former Member — Tue, 20 Jan 2009 06:02:17 GMT

can u tell what all those tables are??how they are related???

Re: Can this statement be optimized?

Former Member — Tue, 20 Jan 2009 06:03:25 GMT

Hi Gates,

Can u please elaborate u r question please.

Re: Can this statement be optimized?

Former Member — Tue, 20 Jan 2009 06:03:50 GMT

They are all the type tihttpnvp

That is the "name-value" list.

Regards,

Lament

Re: Can this statement be optimized?

Former Member — Tue, 20 Jan 2009 06:14:48 GMT

Hi Gates,

I dont think it requires further optimization. The code is already optmized. Inside LOOP when you are using a work area to delete the values from another internal table of same line type, the performance is satisfactory. The code that you have used is the recommended way of using the delete statement.

So you can use the code as it is.

Best Regards,

Ram.

Re: Can this statement be optimized?

former_member222860 — Tue, 20 Jan 2009 06:15:40 GMT

loop at lt_hide_log_list into ls_hide_log_list.

delete table et_save_log_customizing from ls_hide_log_list.

APPEND lt_hide_log_list.

endloop.

thanks

Mahesh

Re: Can this statement be optimized?

Former Member — Tue, 20 Jan 2009 06:18:16 GMT

Hi,

when u use a work area...it is like...

The statement deletes the first internal table row whose values in the columns of the table key match those of the corresponding components of wa. If the key fields in wa are empty, no entry is deleted.

So if you want to delete more than one row from the table et_save_log_customizing having the same key as the work area...u have to use..

loop at lt_hide_log_list into ls_hide_log_list.

DELETE TABLE et_save_log_customizing WITH KEY name = ls_hide_log_list-name.

endloop.

preformance wise both are ok...

Re: Can this statement be optimized?

Former Member — Wed, 21 Jan 2009 07:04:50 GMT

Thanks very much for all your reply

Regards,