Start a new topic
Discussions xDM xDM - Model and Application Design
Answered

What factors cause slow Named Query performance?

What factors cause slow Named Query performance?

Best Answer


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 Comment
Answer


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.


Login to post a comment
More topics in xDM - Model and Application Design
See all 276 topics
Help Desk Software by Freshdesk