topic Re: Performance for tables statement in Application Development and Automation Discussions

Performance for tables statement

Former Member — Fri, 05 Dec 2008 10:04:18 GMT

Hi,

In below statements which one give the better performance and why?

1.tables mara.

select-options s_matnr for mara-matnr.

2.data: mara_wa type mara.

select-options:s_matnr for mara_wa-matnr.

Regards,

Suresh

Re: Performance for tables statement

JozsefSzikszai — Fri, 05 Dec 2008 10:07:14 GMT

there is no significant difference, this shouldn't be a performance issue! if there are performance problems with your program, it is not because of these statements!

Re: Performance for tables statement

Former Member — Fri, 05 Dec 2008 10:07:34 GMT

Hello,

One which does not have a Tables statement will give you better performance because it does not goes out searching for reference outside your program. I think so though with every declaration it will validate whether the declaration exist in the local declaration first and then the global declaration.

Thanks,

Jayant

Re: Performance for tables statement

Former Member — Fri, 05 Dec 2008 10:08:15 GMT

Dear Suresh,

1.tables mara.

select-options s_matnr for mara-matnr.

2.data: mara_wa type mara.

select-options:s_matnr for mara_wa-matnr.

the second statement give the better performance. As tables:mara take global memory if u definde as data: mara_wa type mara. it is local to that program 7 if u made any changes to the table it will not affect the program also.

So in the program try to use as many as u can local variables for the performances issues.

Best Regards,

Flavya

Re: Performance for tables statement

Former Member — Fri, 05 Dec 2008 10:09:03 GMT

this statement doesnot deal with the performance issue, it might be when you have used more loop statements and join select statements only then the performance gets affected.

Re: Performance for tables statement

Former Member — Fri, 05 Dec 2008 10:09:13 GMT

Hi,

Table statement automatically creates a WA in the memory with the Tables' name.

Hence i believe, the "select-options s_matnr for mara-matnr" is better.

In the second option you are creating one more wa with same reference., which is waste of money.

-Raj

Edited by: Rajat Chaturvedi on Dec 5, 2008 3:39 PM

Re: Performance for tables statement

RaymondGiuseppi — Fri, 05 Dec 2008 10:11:43 GMT

Look at [TABLES|http://help.sap.com/abapdocu/en/ABAPTABLES.htm].

The TABLES work area is an Interface Work Area, where the DATA work area is local. So performance derives from the kind of programs which are running, are there only one report or many reports that are interfaced, also how are the data selected record by record or mass selection, are there any screen involved, you have not really enough information for an absolute and definitive answer, for hints :

- TABLES should consume more space and resources, but is sharable

- DATA consumes less, but if sharing is necessary, you will consumer resources to transfer data...

- TABLES may be requested in some report/screen communication

- TABLES is not allowed in classes (OO)

Regards

Re: Performance for tables statement

Former Member — Fri, 05 Dec 2008 10:12:04 GMT

Hi,

As Eric suggested, this should not cause performance issue.

If you are asking just for info -

First method will take slightly more time than second one.

(I would rather say, first method will take slightly more memory than second one).

Regards,

Mohaiyuddin

Re: Performance for tables statement

Former Member — Fri, 05 Dec 2008 10:16:03 GMT

If u put the TABLES statements in u r coding it was get the total fields from database,(it was affect to DB performance) if u doesn't require all the fields from MARA table better to avoid the TABLES statement.

Re: Performance for tables statement

JozsefSzikszai — Fri, 05 Dec 2008 10:19:47 GMT


> the second statement give the better performance. As tables:mara take global memory if u definde as data: mara_wa type mara.  it is local to that program 7 if u made any changes to the table it will not affect the program also.
> 
> So in the program try to use as many as u can local variables for the performances issues.

most of your statements are completely incorrect...

both statements will define the same work area, if they are global or local, it depends on where they are placed in the program (in this case both will be global, otherwise you couldn't use it on the selection screen)

Re: Performance for tables statement

Former Member — Fri, 05 Dec 2008 10:55:37 GMT

Hi Eric,

Thanks a lot for correction.

Regards,

Flavya