X-Git-Url: http://matita.cs.unibo.it/gitweb/?a=blobdiff_plain;ds=inline;f=helm%2Fmatita%2Fscripts%2Fpublic_html%2Fbench.php;h=f1b424bb096f4442206c4983ed2875642b57644a;hb=1e52600b6c984b29eb6e3c1f23b251e23186f8fa;hp=158941ddc8b7ec0c05653da20594f0b46fafcd78;hpb=7f9103473bb5d60319e11e6017dfd4057c451952;p=helm.git diff --git a/helm/matita/scripts/public_html/bench.php b/helm/matita/scripts/public_html/bench.php index 158941ddc..f1b424bb0 100644 --- a/helm/matita/scripts/public_html/bench.php +++ b/helm/matita/scripts/public_html/bench.php @@ -5,8 +5,8 @@ // 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:@@@" . @@ -40,22 +40,25 @@ $query_csc = urlencode("Performances (byte and GC) per mark@@@select mark, SEC_T $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){ - if ($s = "-1") + if ($s == "-1") return "all"; else return $s; } -function links_of($name,$q){ - echo "
  • $name"; - foreach($limits as $k => $l) { - echo "" . +function links_of($name,$q,$limits){ + echo "
  • $name "; + foreach($limits as $l) { + $q1 = str_replace(urlencode("***"), " LIMIT 0,$l;", $q); + echo "" . minus1_to_all($l) . " "; } echo "
  • "; @@ -72,13 +75,13 @@ function links_of($name,$q){

    Common Queries

    Custom Query