Performance with ADMC Search help

[Former Member]

Hi Everyone.

Here there is a performance issue when we tried with the standard search help.It is happening in MEAN Transaction and the search help is for Address Number .While we tried it is giving dump for sometimes.

When I checked into the search help,It is a collective search help and the selection-method is from a View.

Could anyone face this ,please give some pointer to resolve this Performance issues.

If there is any way to reolve this ,we can clone the existing report and do the changes in the new ZMEAN Transaction .

Regards,

Kranti Yamparala.

[Former Member]

Hi Everyone.

Here there is a performance issue when we tried with the standard search help.It is happening in MEAN Transaction and the search help is for Address Number .While we tried it is giving dump for sometimes.

When I checked into the search help,It is a collective search help and the selection-method is from a View.

Could anyone face this ,please give some pointer to resolve this Performance issues.

If there is any way to reolve this ,we can clone the existing report and do the changes in the new ZMEAN Transaction .

Regards,

Kranti Yamparala.

[Former Member]

I don't understand the details of your question.

But anyway, a search help searches on a maybe very large table with very poor selection criteria, this can take

ages and there is nothing you can do.

You must take care that the selection critieria make sense,

+ either by defining mandatory inputs

+ or/and by adding some indices which you think are necessary

Siegfried

[HermannGahm]

Hi Kranti,

start with taking an SQL trace in order to find out where your time is spent.

Post the details here (ST05 summary, the statement and execution plan and variables used)

Kind regards,

Hermann