topic Re: Performance problems with the AUSP table. in Application Development and Automation Discussions

Performance problems with the AUSP table.

former_member317781 — Wed, 02 Mar 2011 07:33:16 GMT

hi masters,

in my prog am using the AUSP SELECT like this.

SELECT SINGLE * FROM ausp WHERE objek EQ ausp_objek AND

atinn EQ cabn-atinn.

and when used the TRACE I see that this select statement duration is 350.930 which is in RED color.

how can i improve this select pls?

thank you,

jacob.

Re: Performance problems with the AUSP table.

Former Member — Wed, 02 Mar 2011 08:26:32 GMT

this is probably not your problem,

+Repeat several times, before you execute the trace.

+Summarize the trace (trace - summarize by SQL statements), what is your total DB time and what are the most expensive statements?

Re: Performance problems with the AUSP table.

Former Member — Wed, 02 Mar 2011 16:07:52 GMT

Hi Jacob,

Check if you can also add KLART to your query so it will use an better index (N3?) My experience is that the KLART field normally is a cosntant depending on the scope of your requirement.

Maybe also look at your trace which index it is using.

Kind regards,

Robert

Re: Performance problems with the AUSP table.

Former Member — Thu, 03 Mar 2011 07:19:47 GMT

Hi Jacob,

generally AUSP table is not taking time to execute query. plz check your trace again.

although you can add KLART andATZHL for filteration criteria and make index for this four field

( objek, atinn,atzhl and klart ). after that execute again..It will be not taking time to execute query.

Regards,

Kunjan

Re: Performance problems with the AUSP table.

fidel_fernandez — Mon, 20 May 2013 15:20:15 GMT

Hello,

I have the same problem. How do you solve it?

Thanks!

Fidel.

Re: Performance problems with the AUSP table.

Former Member — Mon, 07 Mar 2016 13:56:45 GMT

we also have severe performance problems with this table although all relevant index are available

I think it's just a matter of size of the table. We have no idea how to improve on accelearte the search with Transaction cv04n.