topic Re: performance improving in database access in Application Development and Automation Discussions

performance improving in database access

Former Member — Wed, 12 Sep 2007 05:53:25 GMT

in se30 how shd i c the table acess to in the analysis.

for a kna1 table i shd c the no of accesses.

in 4.6c

goto->objecthitlist->database table is not active ...

is there any other way ..

how shd i confirm that performance is incresed after modifying a code.

seshatalpasai_madala — Wed, 12 Sep 2007 05:55:19 GMT

Hi,

You can see the table acess in SQL trace, TCODE- ST05. Check if this transaction is available in your release.

Regards,

Sesh

Former Member — Wed, 12 Sep 2007 08:50:34 GMT

the SE30 can not help you much with that problem (also the database display which appears ponyl if ou use 'no aggregation' )

For details on database accesses you need to run the SQL Trace, the SQL Trace is in any system since a very long time.

See my weblog for details:

Siegfried

Former Member — Wed, 12 Sep 2007 19:00:25 GMT

Are you looking for transaction DB02?

Rob