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, in review by Engineering