B2bCostCenter db call is repeated too many times

[former_member430615]

Hello,


Hybris performance is degraded when a user logs in. On Dynatrace, i found there are soo many calls to SELECT … FROM b2bcostcenters item_t0 as you can see in the screenshot. Which is the main reason for the slow performance. Any idea why this method might be called this many times?the full db call is:select item_t0.PK from b2bcostcenters item_t0 where ( item_t0.p_unit ='*****') and (item_t0.TypePkString='*****' and ( item_t0.p_unit in ('*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****','*****'

thanks!