David JonesSEMARCHY TEAM
Technical Client Success Manager at Semarchy
Asked a question 11 months ago

What factors cause slow Named Query performance?


David JonesSEMARCHY TEAM
Technical Client Success Manager at Semarchy

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.