// 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(
$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 MAX(col) from tab where col = (select COUNT(DISTINCT test)) from bench group by mark order by mark desc)"
+ . "###" .
+ "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){
}
function links_of($name,$q,$limits){
- echo "<li>$name";
+ echo "<li>$name ";
foreach($limits as $l) {
- echo "<a href=\"showquery.php?query=$q LIMIT 0,$l; \">" .
+ $q1 = str_replace(urlencode("***"), " LIMIT 0,$l;", $q);
+ echo "<a href=\"showquery.php?query=$q1;\">" .
minus1_to_all($l) . "</a> ";
}
echo "</li>";