Commencer un nouveau sujet
Répondu

What factors cause slow Named Query performance?

What factors cause slow Named Query performance?


Meilleure réponse


Since the customer reporting this issue had two environments, one where the query ran quickly as expected, and a second environment where performance lagged, we compared both environments in order to identify differences between the two. 


We discovered the main difference between the two was the logging settings. In this specific scenario, changing the logging level from DEBUG to INFO log4j.logger.com.semarchy.mdm.datahub.services.query.datamgr.IDataManager=INFO so that both environments were in sync resolved the query performance issue.


1 commentaire

Réponse


Since the customer reporting this issue had two environments, one where the query ran quickly as expected, and a second environment where performance lagged, we compared both environments in order to identify differences between the two. 


We discovered the main difference between the two was the logging settings. In this specific scenario, changing the logging level from DEBUG to INFO log4j.logger.com.semarchy.mdm.datahub.services.query.datamgr.IDataManager=INFO so that both environments were in sync resolved the query performance issue.


Connexion pour poster un commentaire