MUX Blueprint query optimization

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

A blueprint query used in MUX on views needs optimization. Query beginning:

select
  :"SYS_B_00" pmd_analytical_partition_by,
  odf_abstract_blueprints.id odf_pk,
  odf_blueprints.IS_PRIVATE as is_private,
  ODF_ABSTRACT_BLUEPRINTS.CODE as code,
  odf_ca_abs_blueprint.odf_period_type as odf_period_type,
  odf_ca_abs_blueprint.odf_period_end as odf_period_end,
  odf_blueprints.TYPE as type,
  odf_ca_abs_blueprint.odf_period_start as odf_period_start,
  ODF_BLUEPRINTS.CLASSIFIER as assoc_object,
  odf_blueprints.BLUEPRINT_MODE as blueprint_mode

 

STEPS TO REPRODUCE:

1. On a large Clarity system, connect to MUX with many users and test the performance
2. Note that the blueprint query runs in views and how long it takes

Expected Results: The query to be taking under 0.1 sec or similar since it's called a lot

Actual Results: The query is taking 0.5 seconds. Since the number of executions is high, this can add up

Resolution

This is DE94909, closed as Cannot Reproduce

If you face the same issue, find exact steps and contact Support