What general checks can be carried out if there are MaxDB performance problems?
MaxDB parameterization Read the corresponding parameter note depending on the MaxDB version you use. If your parameter settings do not correspond to the recommendations, correct these parameters. MaxDB Version 7.5 – > Note 767635 MaxDB Version 7.6 – > Note 814704 b) R/3 parameterization Make sure that the rsdb/max_blocking_factor parameter is set in accordance with the recommendations. See Note 819324 and the notes referenced there. As of the 6.10 Kernel, FOR ALL ENTRIES is converted into a list, if this is possible. In connection with this, it is necessary to correctly set the rsdb/max_in_blocking_factor parameter to optimize database performance. For more precise details, see Note 819324 and the notes mentioned in it. Note that even in 6.x, FOR ALL ENTRIES are still sometimes converted into OR concatenations – more specifically, if several conditions in the WHERE section refer to the FOR ALL ENTRIES list. Therefore the rsdb/max_blocking_factor continues to be relevant. To ensure that
