cancel
Showing results for 
Search instead for 
Did you mean: 

B2bCostCenter db call is repeated too many times

0 Kudos
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!

Accepted Solutions (0)

Answers (0)