diff options
Diffstat (limited to 'sql-bench/Results/ATIS-mysql-SunOS_5.7_sun4m')
-rw-r--r-- | sql-bench/Results/ATIS-mysql-SunOS_5.7_sun4m | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/sql-bench/Results/ATIS-mysql-SunOS_5.7_sun4m b/sql-bench/Results/ATIS-mysql-SunOS_5.7_sun4m index c2da532cc0e..f64ec0c218c 100644 --- a/sql-bench/Results/ATIS-mysql-SunOS_5.7_sun4m +++ b/sql-bench/Results/ATIS-mysql-SunOS_5.7_sun4m @@ -1,19 +1,19 @@ -Testing server 'MySQL 3.22.20' at 1999-03-19 12:57:30 +Testing server 'MySQL 3.23.29 gamma' at 2000-12-17 0:10:20 ATIS table test Creating tables -Time for create_table (28): 2 secs ( 0.05 usr 0.05 sys + 0.00 cusr 0.00 csys = 0.10 cpu) +Time for create_table (28): 3 wallclock secs ( 0.03 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.00 CPU) Inserting data -Time to insert (9768): 40 secs ( 7.14 usr 7.21 sys + 0.00 cusr 0.00 csys = 14.35 cpu) +Time to insert (9768): 30 wallclock secs ( 5.85 usr 4.98 sys + 0.00 cusr 0.00 csys = 0.00 CPU) Retrieving data -Time for select_simple_join (500): 37 secs ( 9.62 usr 7.92 sys + 0.00 cusr 0.00 csys = 17.54 cpu) -Time for select_join (200): 572 secs (81.23 usr 73.44 sys + 0.00 cusr 0.00 csys = 154.67 cpu) -Time for select_distinct (800): 292 secs (28.26 usr 22.92 sys + 0.00 cusr 0.00 csys = 51.18 cpu) -Time for select_group (2700): 209 secs (20.70 usr 12.94 sys + 0.00 cusr 0.00 csys = 33.64 cpu) +Time for select_simple_join (500): 21 wallclock secs ( 7.16 usr 3.20 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +Time for select_join (200): 137 wallclock secs (56.58 usr 27.51 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +Time for select_distinct (800): 127 wallclock secs (20.08 usr 8.51 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +Time for select_group (2800): 140 wallclock secs (14.60 usr 5.95 sys + 0.00 cusr 0.00 csys = 0.00 CPU) Removing tables -Time to drop_table (28): 1 secs ( 0.02 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.04 cpu) -Total time: 1153 secs (147.11 usr 124.50 sys + 0.00 cusr 0.00 csys = 271.61 cpu) +Time to drop_table (28): 1 wallclock secs ( 0.03 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.00 CPU) +Total time: 459 wallclock secs (104.37 usr 50.19 sys + 0.00 cusr 0.00 csys = 0.00 CPU) |