topic Re: performanec issue in Application Development and Automation Discussions

performanec issue

Former Member — Fri, 07 Sep 2007 08:09:23 GMT

Hi All

How the performance will be affected when we select the data into an Internal table and a standard table.

Regards

Srini

Re: performanec issue

seshatalpasai_madala — Fri, 07 Sep 2007 08:14:58 GMT

Hi,

What do you mean by Standard table?.

Regards,

Sesh

Re: performanec issue

Former Member — Fri, 07 Sep 2007 08:40:21 GMT

????????????????????????????????????????????????????????

What do you mean ???

If you use select * into itab from db_tab ....

Then the performance is not effected.

Performance is affected by the select an by the operations you are doing later with the itab.

Siegfried

Re: performanec issue

Former Member — Fri, 07 Sep 2007 18:31:20 GMT

I am not getting your question can you please ask clearly what you want or else close this thread.

Rashit

Re: performanec issue

Former Member — Mon, 10 Sep 2007 06:50:35 GMT

the data will be selected into an internal table

not into the standard table

internal tables are the temp buffer area where we will retrive the data from data base tables and put in internal tables for useing that data in some sitvations

the performance won't be there when your storing the data into internal table

the performance will come only when your retriving data from data base table

suppose if there 1000000 records and your retriving data from database and storing in internal table

at that time the performance problem will occur in select query

so performance won't be there when storing the data in imnternal table

reward if usefull