An optimize run, step by step

An optimize run, step by step A workflow diagram generated by Archify. 01 / Prepare 02 / Measure each order, then finish EX / Stop or error Check config · cube, views, TIs exist · Prepare Check config cube, views, TIs exist Protect · VMM/VMT up (v11) · Prepare · checkpoint Protect VMM/VMT up (v11) checkpoint Original order · RAM + timings · Prepare Original order RAM + timings Next order · one at a time, until done · Measure each order, then finish Next order one at a time, until done Reorder + time · cache cleared each run · Measure each order, then finish · median Reorder + time cache cleared each run median Pick the best · within 1%, 2.5%, 5% · Measure each order, then finish Pick the best within 1%, 2.5%, 5% Apply or restore · then write the report · Measure each order, then finish Apply or restore then write the report Stopped · original put back · Stop or error Stopped original put back Run again · resumes · Stop or error Run again resumes all tried

How an order is measured

  • • Each view and TI runs 'executions' times with the cube cache cleared before every run; the median counts
  • • Memory comes from the server's reported change after each reorder

How the best is picked

  • • The first order within 1% of the best on memory and on query (and TI) time wins; then 2.5%, then 5%
  • • The original order is checked first, so it wins when nothing is clearly better

When it stops

  • • The original order is put back and a partial report is written
  • • The checkpoint is kept: run the same command again to continue