Inconsistent performance

[Former Member]

Hi,

We have a customised program that accesses the following tables, amongst others : MSEG, MKPF, MCHA, MCH1, MARA, MARC, etc

These tables keep records at different company codes level.

The strange thing is : when Company A is select, the report takes only a short while to complete. But when, say, Company B is selected, it took days to run.

These tables have the correct & relevant indices created so I don't think that's the issue. In terms of number of records, both companies have similar.

Why is this strange behaviour occurring?

Does anyone have similar experience or knows why the strange behaviour?

Is there some form for tuning that's involved?

Thanks

[Former Member · Accepted solution]

Before the tuning can be done, you need to analyse where things go wrong. Do an sql trace with ST05 for both companies. Check which statements consume the most time for the slow company and compare the data to the faster one.

If you cannot solve it then yourself post the information here. I predict a join on MKPF and MSEG (and maybe more tables) to show up.

Please also check this on what information we need to help you:

Cheers Michael

[Former Member]

Are the statistics for the table and index up to date?

Can you also compare the cost of the statement between the company codes?

Kind regards,

Mark