topic Re: performence question in Application Development and Automation Discussions

performence question

Former Member — Tue, 10 Apr 2007 14:42:13 GMT

hallow

i use se30 to check performence and i wont to now

in the grafh for what i have to pay attntion (what i can change for better perfrmence)to abap or database or system

regards

Re: performence question

Former Member — Tue, 10 Apr 2007 14:45:32 GMT

The primary aim shoul be towards the database time only.

Then comes the ABAP time.

In general there is very little that you can do to improve the system time(As a programmer) This is more of a basis job(Improving system response time).

Regards,

Ravi

Re: performence question

alex_m — Tue, 10 Apr 2007 14:46:01 GMT

In graph display, u can find one icon tip left called HIT LIST, this will give u the list of acces to the data base. Here u can check the SQL access time.

Re: performence question

Former Member — Tue, 10 Apr 2007 14:46:47 GMT

YOUR database hit must be low.

Re: performence question

Former Member — Tue, 10 Apr 2007 14:47:37 GMT

Hi Antonio,

Please check this link for more detail on measurement results(SE30).

http://help.sap.com/saphelp_nw04s/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/frameset.htm

Regards,

Ferry Lianto

Re: performence question

Former Member — Tue, 10 Apr 2007 14:47:50 GMT

You basically need to concentrate on execution time of a select query. Check how long is it taking to fetch data from database.

Optimise select queries. Do not write a query in a loop endloop unless it is required.

Try to use indexes on database tables.

There are many performance tips in terms of abap programming.

Check this link for instance:

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp

Thanks,

SKJ

Re: performence question

Former Member — Tue, 10 Apr 2007 14:56:06 GMT

hallow

if i improve my program(the selects) where i can see it in abap or in database

regards

Re: performence question

Former Member — Tue, 10 Apr 2007 14:59:07 GMT

In select statements or any statement that deals with teh database(like modify database or update/insert database) the performance will be affected in database time.

For al other statements like loops, do-enddo, read statements etc, the abap time is affected.

Regards,

ravi

Re: performence question

Former Member — Tue, 10 Apr 2007 15:02:55 GMT

Hi Antonio,

Please check this link for performance tips on SELECT and others statements.

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

Regards,

Ferry Lianto

Re: performence question

Former Member — Tue, 10 Apr 2007 15:04:13 GMT

hi,

if u want to tune the selects then go for st05 analysis.

regards,

madhu