performence question

[Former Member]

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

[Former Member]

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

[alex_m]

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.

[Former Member]

YOUR database hit must be low.

[Former Member]

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

[Former Member]

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

[Former Member]

hallow

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

regards

[Former Member]

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

[Former Member]

hi,

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

regards,

madhu

[Former Member]

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