topic Re: Performance improvement in Application Development and Automation Discussions

Performance improvement

former_member185124 — Thu, 15 Jan 2015 10:12:51 GMT

Hi guys,

I have one requirement it is GIN(goods receipt and invoice data) Alv report from MB5S:Tcode.There are so many tables are there.I am retrieving data from tables by using 'FOR ALL ENTRIES' Query.Even the database performance shows 65%.Again i have create secondary index for non-key fields .Now the database performance show 55%.I want to decrease upto 30%.How it's possible if any one knows reply me.

Thanks & Regards,

Mahesh K

Re: Performance improvement

Former Member — Thu, 15 Jan 2015 10:25:01 GMT

Avoid for all entries and try to use inner join. You also can check "parallel cursor" technique.

Re: Performance improvement

former_member214878 — Thu, 15 Jan 2015 10:26:19 GMT

Hi Mahesh,

what u want to do exactly? To increase a performance of MB5S

or u have a similar report *Custom developed Z rep.* ? and for that u want to have an optimization techniques?

Thanks.

Rudra

Re: Performance improvement

former_member185124 — Thu, 15 Jan 2015 10:35:12 GMT

Dear Thiago,

Thanks for giving reply.I am using parrallel cursor technique .i.e., for abap performance but i need to improve the database performance.How it is .

Thanks & Regards,

mahesh k

Re: Performance improvement

former_member185124 — Thu, 15 Jan 2015 10:39:30 GMT

Dear Rudra,

I have develop a custom report.I have the improve the database performance .What are the techniques to do .Already i am using 'FOR ALL ENTRIES' in select query and secondary index on non-key fields but it shows upto 55%.But i need upto 30%.How to do this

Thanks & Regards,

Mahesh k

Re: Performance improvement

Former Member — Thu, 15 Jan 2015 10:56:52 GMT

Hi,

Your requirement is really strange.

If you want 30% database then simply increase the ABAP stuff.

Also keep in mind that the way abap runtime performance and database acces in development works can be different from production.

Kind regards, Rob Dielemans

Re: Performance improvement

ThomasZloch — Thu, 15 Jan 2015 11:16:35 GMT

Forget the percentages and rather look at absolute runtimes.

Run an ABAP trace with transaction SAT and sort the result list descending by "net time", the top few items in the list will be your performance bottlenecks to be investigated further (e.g. inefficient DB access, exponential growth of internal tables, inefficient loop inside loop constructs, too many RFCs, etc.).

This has been discussed many times, please search for available information.

Thomas

Re: Performance improvement

Former Member — Thu, 15 Jan 2015 11:18:38 GMT

Hii mahesh

it depends on amount of data you want to fetch as well, along with your select-option and where clauses you used. make sure you used maximum possible key fields so that db time is reduced

Regards

Gaurav

Re: Performance improvement

former_member185124 — Thu, 15 Jan 2015 11:23:59 GMT

Dear Gaurav,

Thanks for giving reply.I am using key fields only .If For non-key fields i am create a secondary index then it shows 55%.

Re: Performance improvement

ipravir — Thu, 15 Jan 2015 11:27:16 GMT

Hi Mahesh,

Follow the below methods, what we follows while developing or code.

1. Fetch the Data from table through Columns / Fields based query, try to avain '*' while doing query.

2. Always user FIELD-SYMBOL to read or loop the Data from Internal table.

3. Avain Loop inside Loop statement, try to do Index Looping always.

4. Check Internal Table Initialization, before do the For All Entries.

5.Try to avaind reuse component, if possible make the logic globle.

6. If possible, try to use parallel Process techniques.

7. Sort the table before Read from Internal Table, user BINARY SEARCH.

8. Sort the Information before delete the data from Internal table and user 'COMPARING FIELDS-NAME'

9. Before go for FOR ALL ENTRIES, try to sort the Information or if possible try to pass unique information in internal table (Repeatative maybe takes time to fetch records from Tables )

Guys, if you have some more point to consider, please add.

Reagrds.

Praveer.

Re: Performance improvement

former_member185124 — Thu, 15 Jan 2015 11:29:18 GMT

Dear Thomas ,

I have run se30(old one).For SAT how to run this and how to find this(e.g. inefficient DB access, exponential growth of internal tables, inefficient loop inside loop constructs, too many RFCs, etc.).

Re: Performance improvement

Former Member — Thu, 15 Jan 2015 11:29:42 GMT

Dear mahesh

db performance depends on lot many things not only on abap code you write like server load indexing at db level system paramerers etc, so optimize your source code as much as possible thats only thing you can do at abap level

Regards

Gaurav

Re: Performance improvement

Former Member — Thu, 15 Jan 2015 11:30:36 GMT

Dear mahesh

Regards

Gaurav

Re: Performance improvement

ThomasZloch — Thu, 15 Jan 2015 11:40:14 GMT

Please paste a screenshot of the top 10 items in the hit list (not the percentage overview!), list must be sorted by net time descending, as mentioned.

(chapters 3 and 4 especially)

Thomas

Re: Performance improvement

former_member185124 — Thu, 15 Jan 2015 11:46:23 GMT

Dear Thomas,

I send a screen shot of Hit list .So,please find it.

Re: Performance improvement

Former Member — Thu, 15 Jan 2015 12:05:26 GMT

Hi Mahesh,

Try to use joins instead of for all entries. Use joins with key fields.

This will surely improve the performance.

Regards,

Pankaj

Re: Performance improvement

ThomasZloch — Thu, 15 Jan 2015 13:32:53 GMT

Almost there, tab "Hit list" sorted by column "Net" descending would be better.

We can already (barely) see that DB access to RSEG, MSEG and LFA1 takes some time, so investigate the SQL statements and make sure that you use primary or secondary key fields in your where conditions.

Please also search for previous discussions around how to solve specific performance issues.

Thomas

Re: Performance improvement

former_member214878 — Thu, 15 Jan 2015 13:59:27 GMT

Mahesh,

I believe u must be having a extensive data! That's inevitable in some cases like yours.

Now the basic things explained by Thomas is abs. must to be considered.

For better performance I would suggest - use packet wise reading in select query and handling a packet for the further calculation/final internal table creation part.

You can have a look on - OPEN CURSOR ^ BY PASSING BUFFER ^

Also have a look on -

1. Select statement where u need not to have *

2. WHERE condition part plays a crucial role, have as much as possible KEYS in the statement

3. Have a keep on ST05. SQL trace.

I think u can do it ... many times this is been discussed.

regards.

Rudra

Re: Performance improvement

Former Member — Fri, 16 Jan 2015 08:46:18 GMT

Hi Mahesh,

Please send us your program source code and snap shots of the secondary indexes you created.

Thank you,

John

Re: Performance improvement

balanand_s — Fri, 16 Jan 2015 09:04:53 GMT

Hello,

your problem is you wanted to reduce the no of hits to the database and in order to improve the performance Please follow the below steps...

1. Before using for all entries command, just copy the internal table data into temp internal table which contains same structure and then delete the duplicate entries from that internal table and then use it..

EX:

A is an internal table which is having 2000 entries.

A_Copy is an temp internal table.

A_Copy = A. "Copying the values from internal table A to A_Copy

Sort A_Copy Ascending by field-name1 field-name2. "Sort it by the field which u r using in where cond.

DELETE ADJACENT DUPLICATES FROM A_Copy COMPARING field-name1 and field-name2.

2.in the where condition use as listed in INDEXES for the particular table if any,

try to avoid passing duplicate entries, that will improve the performance more than 20%...

Hope this will be helpful for you....

If still you are facing the same issue, just share the select query completely will give you the appropriate solution..

Regards

Balanand S