EpMem Branch Comparison

    commandavg_ratio_new_old
    170.3505
    1035.1909
    1254.0204
    1363.4095
    1569.5269
    265.9272
    373.4856
    473.4047
    578.5528
    671.7344
    740.3247
    834.8425
    91.6931
    download full data set as csv
    SELECT d.command, FLOOR(d.episodes/1000) AS episodes, (100*((d.compare_msec)/d.base_msec)) AS compare_ratio_new_old
    FROM (SELECT c.command, c.episodes, (1000*(c.base_totalsec/c.base_reps)) AS base_msec, (1000*(c.compare_totalsec/c.compare_reps)) AS compare_msec
    FROM (SELECT a.command, a.episodes, a.reps AS base_reps, a.totalsec AS base_totalsec, b.d_reps AS compare_reps, b.d_totalsec AS compare_totalsec
    FROM (SELECT d_command AS command, d_episodes AS episodes, d_reps AS reps, d_totalsec AS totalsec
    FROM exp_data_73
    WHERE d_branch='trunk' AND d_domain='tanksoar' AND d_machine='falcor' AND d_rseed=55512 AND d_command IN (1,2,3,4,5,6,7,8,9,10,12,13,15)) a, exp_data_73 b
    WHERE b.d_branch='reimp' AND b.d_domain='tanksoar' AND b.d_machine='falcor' AND b.d_rseed=55512 AND b.d_command=a.command AND b.d_episodes=a.episodes) c) d
    ORDER BY d.command ASC, d.episodes ASC
      commandavg_ratio_new_old
      11129.2697
      14104.0238
      storage158.6832
      download full data set as csv
      SELECT d.command, FLOOR(d.episodes/1000) AS episodes, (100*((d.compare_msec)/d.base_msec)) AS compare_ratio_new_old
      FROM (SELECT c.command, c.episodes, (1000*(c.base_totalsec/c.base_reps)) AS base_msec, (1000*(c.compare_totalsec/c.compare_reps)) AS compare_msec
      FROM (SELECT a.command, a.episodes, a.reps AS base_reps, a.totalsec AS base_totalsec, b.d_reps AS compare_reps, b.d_totalsec AS compare_totalsec
      FROM (SELECT d_command AS command, d_episodes AS episodes, d_reps AS reps, d_totalsec AS totalsec
      FROM exp_data_73
      WHERE d_branch='trunk' AND d_domain='tanksoar' AND d_machine='falcor' AND d_rseed=55512 AND d_command IN ('storage',11,14)) a, exp_data_73 b
      WHERE b.d_branch='reimp' AND b.d_domain='tanksoar' AND b.d_machine='falcor' AND b.d_rseed=55512 AND b.d_command=a.command AND b.d_episodes=a.episodes) c) d
      ORDER BY d.command ASC, d.episodes ASC