- bench.options = 'gc-on' and
- bench.compilation = 'byte' and
- bench_svn.mark = bench.mark and
- bench1.result = 'fail' and
- bench1.mark = bench.mark and
- bench1.compilation = 'byte' and
- bench1.options = 'gc-on'
-group by bench.mark
-order by bench.mark desc
-***");
-
-$query_csc_opt = urlencode("
-Performances (opt and GC) per mark
-@@@
-select
- bench.mark,
- bench_svn.revision as revision,
- SUM(bench.time) as sum_time,
- SUM(bench.timeuser) as sum_timeuser,
- COUNT(DISTINCT bench.test) as performed_tests,
- COUNT(DISTINCT bench1.test) as failed_tests
-from
- bench, bench_svn,bench as bench1
-where
- bench.options = 'gc-on' and
- bench.compilation = 'opt' and
- bench_svn.mark = bench.mark and
- bench1.result = 'fail' and
- bench1.mark = bench.mark and
- bench1.compilation = 'opt' and
- bench1.options = 'gc-on'
-group by bench.mark
-order by bench.mark desc
+ bench_times.mark = bench_fails.mark and
+ bench_times_opt.mark = bench_fails_opt.mark and
+ bench_times.mark = bench_times_opt.mark and
+ bench_svn.mark = bench_times.mark
+ order by bench_svn.mark desc