OptimusPy: which mode do I run?

OptimusPy: which mode do I run? A workflow diagram generated by Archify. 01 / Apply an order you already have 02 / Measure: find the best order 03 / Every cube at once, or a narrower question set · apply one order · Apply an order you already have set apply one order Sync Order · to another server · Apply an order you already have · UI Sync Order to another server UI Start here · what do you need? · Measure: find the best order Start here what do you need? scan · biggest cubes by RAM · Measure: find the best order scan biggest cubes by RAM optimize · benchmark orders · Measure: find the best order · one cube optimize benchmark orders one cube Greedy · no idea of the order · Measure: find the best order · Fast mode optional Greedy no idea of the order Fast mode optional optimize-db · leaf-count rule · Every cube at once, or a narrower question · every cube optimize-db leaf-count rule every cube Predefined · compare your orders · Every cube at once, or a narrower question Predefined compare your orders One slot · Position / Dimension · Every cube at once, or a narrower question One slot Position / Dimension top cubes whole instance which cube? know the order

Measured

  • • optimize reorders the real cube, measures each order, then puts the original back unless auto-apply is on
  • • Already know the cube? Skip scan and go straight to optimize

Not measured

  • • set and Sync Order apply an order as given
  • • optimize-db sorts by leaf count and keeps a change only if memory did not grow

Typical path

  • • scan, then optimize the top cubes on DEV
  • • then set or Sync Order the winners on PROD