mariadb-10.4.24/sql-bench/test-select.sh

57 $start_time=new Benchmark;
97 $loop_time=new Benchmark;
123 $end_time=new Benchmark;
156   $loop_time=new Benchmark;
161   $end_time=new Benchmark;
168   $loop_time=new Benchmark;
173   $end_time=new Benchmark;
180 $loop_time=new Benchmark;
181 $rows=0;
186   $rows+=fetch_all_rows($dbh,"select idn from bench1 where region='$region'");
187   $rows+=fetch_all_rows($dbh,"select idn from bench1 where region='$region' and idn=$i");
188   $rows+=fetch_all_rows($dbh,"select idn from bench1 where region='$region' and rev_idn=$i");
189   $rows+=fetch_all_rows($dbh,"select idn from bench1 where region='$region' and grp=$grp");
190 …$rows+=fetch_all_rows($dbh,"select idn from bench1 where region>='B' and region<='C' and grp=$grp"…
191 …$rows+=fetch_all_rows($dbh,"select idn from bench1 where region>='B' and region<='E' and grp=$grp"…
192   $rows+=fetch_all_rows($dbh,"select idn from bench1 where grp=$grp"); # This is hard
196 $end_time=new Benchmark;
197 print "Time for select_big ($count:$rows): " .
202 $loop_time=new Benchmark;
207 $rows=0;
237     $rows+=$found;
242     $rows+=fetch_all_rows($dbh,$query . $or_part);
243     $rows+=fetch_all_rows($dbh,$query . $or_part2);
245     $rows+=fetch_all_rows($dbh,"$query ($or_part) and idn < 50");
246     $rows+=fetch_all_rows($dbh,"$query (($or_part) or (region='A' and grp < 10)) and region <='B'")
249   $end_time=new Benchmark;
255 print " for select_range ($count:$rows): " .
264   $loop_time=new Benchmark;
286     $end_time=new Benchmark;
294   $loop_time=new Benchmark;
307     $end_time=new Benchmark;
319   $loop_time=new Benchmark;
320   $rows=0;
323     $rows+=fetch_all_rows($dbh,"select grp,count(*) from bench1 group by grp");
325   $end_time=new Benchmark;
326   print "Time for count_group_on_key_parts ($i:$rows): " .
329   $loop_time=new Benchmark;
330   $rows=0;
333     $rows+=fetch_all_rows($dbh,"select grp_no_key,count(*) from bench1 group by grp_no_key");
335   $end_time=new Benchmark;
336   print "Time for count_group ($i:$rows): " .
339   $loop_time=new Benchmark;
340   $rows=0;
343 …$rows+=fetch_all_rows($dbh,"select grp_no_key,count(*) as cnt from bench1 group by grp_no_key orde…
345   $end_time=new Benchmark;
346   print "Time for count_group_with_order ($i:$rows): " .
353   $loop_time=new Benchmark;
354   $rows=$estimated=$count=0;
358     $rows+=fetch_all_rows($dbh,"select count(distinct region) from bench1");
359     $end_time=new Benchmark;
364   print " for count_distinct_key_prefix ($count:$rows): " .
367   $loop_time=new Benchmark;
368   $rows=$estimated=$count=0;
372     $rows+=fetch_all_rows($dbh,"select count(distinct grp) from bench1");
373     $end_time=new Benchmark;
378   print " for count_distinct ($count:$rows): " .
384     $loop_time=new Benchmark;
385     $rows=$estimated=$count=0;
389       $rows+=fetch_all_rows($dbh,"select count(distinct grp),count(distinct rev_idn) from bench1");
390       $end_time=new Benchmark;
395     print " for count_distinct_2 ($count:$rows): " .
399   $loop_time=new Benchmark;
400   $rows=$estimated=$count=0;
404     $rows+=fetch_all_rows($dbh,"select region,count(distinct idn) from bench1 group by region");
405     $end_time=new Benchmark;
410   print " for count_distinct_group_on_key ($count:$rows): " .
413   $loop_time=new Benchmark;
414   $rows=$estimated=$count=0;
418     $rows+=fetch_all_rows($dbh,"select grp,count(distinct idn) from bench1 group by grp");
419     $end_time=new Benchmark;
424   print " for count_distinct_group_on_key_parts ($count:$rows): " .
427   $loop_time=new Benchmark;
428   $rows=$estimated=$count=0;
432     $rows+=fetch_all_rows($dbh,"select grp,count(distinct rev_idn) from bench1 group by grp");
433     $end_time=new Benchmark;
438   print " for count_distinct_group ($count:$rows): " .
441   $loop_time=new Benchmark;
442   $rows=$estimated=$count=0;
447     $rows+=fetch_all_rows($dbh,"select idn,count(distinct region) from bench1 group by idn");
448     $end_time=new Benchmark;
453   print " for count_distinct_big ($count:$rows): " .