// queries ::= query | query "###" queries
// query ::= name "@@@" sql
//
-$limits = array("30","50","-1");
-
+$limits = array("20","50","100","-1");
+
$quey_all = urlencode("Whole content:@@@select * from bench");
$query_fail = urlencode(
"Number of failures:@@@" .
$query_csc_opt = urlencode("Performances (opt and GC) per mark@@@select mark, SEC_TO_TIME(SUM(TIME_TO_SEC(time))) as sum_time, SEC_TO_TIME(SUM(TIME_TO_SEC(timeuser))) as sum_timeuser from bench where options = 'gc-on' and compilation = 'opt'group by mark order by mark desc"
);
-$query_total = urlencode("Number of compiled tests@@@select mark, COUNT(DISTINCT test) as N from bench group by mark order by mark desc"
-# . "###" .
-#"Lost tests"
+$query_total = urlencode(
+
+"Max N@@@select COUNT(DISTINCT test) from bench group by mark"
+ . "###" .
+ "Number of compiled tests@@@select mark, COUNT(DISTINCT test) as N from bench group by mark order by mark desc"
);
function minus1_to_all($s){
- if ($s = "-1") return "all" else return $s;
+ if ($s == "-1")
+ return "all";
+ else
+ return $s;
}
-function links_of($name,$q){
- echo "<li>$name";
+function links_of($name,$q,$limits){
+ echo "<li>$name ";
foreach($limits as $l) {
- echo "<a href=\"showquery.php?query=$q LIMIT 0,$l; \">$l</a> ";
+ $q1 = str_replace(urlencode("###"), " LIMIT 0,$l;" . urlencode("###"), $q);
+ echo "<a href=\"showquery.php?query=$q1 LIMIT 0,$l; \">" .
+ minus1_to_all($l) . "</a> ";
}
echo "</li>";
}
<h2>Common Queries</h2>
<p>
<ul>
- <? links_of("Broken tests",$query_fail) ?>
- <? links_of("Garbage collector killer",$query_gc) ?>
- <? links_of("Auto performances",$query_auto) ?>
- <? links_of("Global performances (bytecode)",$query_csc) ?>
- <? links_of("Global performances (nativecode)",$query_csc_opt) ?>
- <? links_of("Number of compiled tests",$query_total) ?>
- <? links_of("All table contents",$quey_all) ?>
+ <? links_of("Broken tests",$query_fail,$limits) ?>
+ <? links_of("Garbage collector killer",$query_gc,$limits) ?>
+ <? links_of("Auto performances",$query_auto,$limits) ?>
+ <? links_of("Global performances (bytecode)",$query_csc,$limits) ?>
+ <? links_of("Global performances (nativecode)",$query_csc_opt,$limits) ?>
+ <? links_of("Number of compiled tests",$query_total,$limits) ?>
+ <? links_of("All table contents",$quey_all,$limits) ?>
</ul>
</p>
<h2>Custom Query</h2>