=======================================================================================
SQLBENCH REPORT
=======================================================================================
ENGINE: heap
MACHINE: orisndriz05
RUN ID: 112
RUN DATE: 2009-12-01T17:44:00.426269
SERVER: drizzled
VERSION: staging
REVISION: 1236
COMMENT: 1236: Brian Aker 2009-12-01 [merge] Merge Brian + Monty. This has the
HEAP -...
=========================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
heap alter_table_add 12.00 -2.86% -0.33
within norms 11.00 12.00 11.67 0.47
heap alter_table_drop 11.00 -3.12% -0.33
within norms 10.00 11.00 10.67 0.47
heap connect 1.00 +25.00% 0.33
within norms 1.00 2.00 1.33 0.47
heap connect+select_1_row 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap connect+select_simple 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap count 13.00 +9.30% 1.33
within norms 13.00 17.00 14.33 1.89
heap count_distinct 6.00 +14.29% 1.00
outside norms 6.00 8.00 7.00 0.82
heap count_distinct_2 11.00 +5.71% 0.67
outside norms 11.00 12.00 11.67 0.47
heap count_distinct_big 20.00 +1.64% 0.33
within norms 19.00 22.00 20.33 1.25
heap count_distinct_group 13.00 -5.41% -0.67
within norms 11.00 13.00 12.33 0.94
heap count_distinct_group_on_key 10.00 -15.38% -1.33
outside norms 8.00 10.00 8.67 0.94
heap count_distinct_group_on_key_parts 11.00 -0.00% 0.00
within norms 10.00 12.00 11.00 0.82
heap count_distinct_key_prefix 4.00 +14.29% 0.67
outside norms 4.00 5.00 4.67 0.47
heap count_group_on_key_parts 9.00 -8.00% -0.67
outside norms 8.00 9.00 8.33 0.47
heap count_on_key 78.00 -1.30% -1.00
outside norms 76.00 78.00 77.00 0.82
heap create+drop 19.00 +1.72% 0.33
within norms 19.00 20.00 19.33 0.47
heap create_index 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap create_key+drop 23.00 -1.47% -0.33
within norms 22.00 23.00 22.67 0.47
heap create_MANY_tables 18.00 -0.00% 0.00
within norms 18.00 18.00 18.00 0.00
heap create_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap delete_all_many_keys 340.00 -10.03% -31.00
outside norms 289.00 340.00 309.00 22.23
heap delete_autocommit 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
heap delete_big 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap delete_big_many_keys 340.00 -10.03% -31.00
outside norms 289.00 340.00 309.00 22.23
heap delete_commit 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap delete_key 2.00 +14.29% 0.33
within norms 2.00 3.00 2.33 0.47
heap delete_range 8.00 -4.35% -0.33
within norms 7.00 8.00 7.67 0.47
heap delete_rollback 1.00 +40.00% 0.67
outside norms 1.00 2.00 1.67 0.47
heap drop_index 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap drop_table_when_MANY_tables 14.00 -0.00% 0.00
within norms 14.00 14.00 14.00 0.00
heap insert 90.00 +0.74% 0.67
within norms 90.00 92.00 90.67 0.94
heap insert_autocommit 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
heap insert_commit 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap insert_duplicates 12.00 +5.26% 0.67
outside norms 12.00 13.00 12.67 0.47
heap insert_key 316.00 -3.49% -10.67
outside norms 296.00 316.00 305.33 8.22
heap insert_many_fields 4.00 -0.00% 0.00
within norms 4.00 4.00 4.00 0.00
heap insert_rollback 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap insert_select_1_key 3.00 +10.00% 0.33
within norms 3.00 4.00 3.33 0.47
heap insert_select_2_keys 6.00 -5.88% -0.33
within norms 5.00 6.00 5.67 0.47
heap min_max 6.00 +14.29% 1.00
outside norms 6.00 8.00 7.00 0.82
heap min_max_on_key 16.00 +4.00% 0.67
outside norms 16.00 17.00 16.67 0.47
heap multiple_value_insert 5.00 -7.14% -0.33
within norms 4.00 5.00 4.67 0.47
heap once_prepared_select 21.00 +1.56% 0.33
within norms 21.00 22.00 21.33 0.47
heap order_by_big 15.00 -7.14% -1.00
outside norms 13.00 15.00 14.00 0.82
heap order_by_big_key 11.00 +10.81% 1.33
outside norms 11.00 14.00 12.33 1.25
heap order_by_big_key2 10.00 +11.76% 1.33
outside norms 10.00 12.00 11.33 0.94
heap order_by_big_key_desc 12.00 +5.26% 0.67
within norms 12.00 14.00 12.67 0.94
heap order_by_big_key_diff 11.00 +5.71% 0.67
within norms 11.00 13.00 11.67 0.94
heap order_by_big_key_prefix 12.00 +2.70% 0.33
within norms 12.00 13.00 12.33 0.47
heap order_by_key2_diff 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap order_by_key_prefix 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap order_by_range 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap outer_join 16.00 -2.13% -0.33
within norms 15.00 16.00 15.67 0.47
heap outer_join_found 15.00 +2.17% 0.33
within norms 15.00 16.00 15.33 0.47
heap outer_join_not_found 14.00 -2.44% -0.33
within norms 13.00 14.00 13.67 0.47
heap outer_join_on_key 12.00 -5.88% -0.67
outside norms 11.00 12.00 11.33 0.47
heap prepared_select 28.00 -5.00% -1.33
outside norms 25.00 28.00 26.67 1.25
heap select_1_row 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
heap select_1_row_cache 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap select_2_rows 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap select_big 11.00 +2.94% 0.33
within norms 11.00 12.00 11.33 0.47
heap select_cache 54.00 -0.62% -0.33
within norms 51.00 56.00 53.67 2.05
heap select_cache2 58.00 -3.57% -2.00
outside norms 54.00 58.00 56.00 1.63
heap select_column+column 3.00 -12.50% -0.33
within norms 2.00 3.00 2.67 0.47
heap select_diff_key 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap select_distinct 4.00 -0.00% 0.00
within norms 4.00 4.00 4.00 0.00
heap select_group 14.00 -0.00% 0.00
within norms 14.00 14.00 14.00 0.00
heap select_group_when_MANY_tables 4.00 -0.00% 0.00
within norms 4.00 4.00 4.00 0.00
heap select_join 1.00 -50.00% -0.33
within norms 0.00 1.00 0.67 0.47
heap select_key 50.00 -9.49% -4.33
outside norms 42.00 50.00 45.67 3.30
heap select_key2 49.00 +0.68% 0.33
within norms 48.00 51.00 49.33 1.25
heap select_key2_return_key 44.00 +2.94% 1.33
outside norms 44.00 47.00 45.33 1.25
heap select_key2_return_prim 50.00 -2.04% -1.00
within norms 47.00 50.00 49.00 1.41
heap select_key_prefix 51.00 -2.68% -1.33
within norms 46.00 52.00 49.67 2.62
heap select_key_prefix_join 4.00 +7.69% 0.33
within norms 4.00 5.00 4.33 0.47
heap select_key_return_key 46.00 -2.22% -1.00
within norms 42.00 47.00 45.00 2.16
heap select_many_fields 17.00 -2.00% -0.33
within norms 16.00 17.00 16.67 0.47
heap select_range 49.00 -0.00% 0.00
within norms 49.00 49.00 49.00 0.00
heap select_range_key2 7.00 +4.55% 0.33
within norms 7.00 8.00 7.33 0.47
heap select_range_prefix 8.00 -9.09% -0.67
outside norms 7.00 8.00 7.33 0.47
heap select_simple 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap select_simple_cache 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap select_simple_join 1.00 -50.00% -0.33
within norms 0.00 1.00 0.67 0.47
heap update_autocommit 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
heap update_big 36.00 -3.85% -1.33
outside norms 34.00 36.00 34.67 0.94
heap update_commit 1.00 -0.00% 0.00
within norms 1.00 1.00 1.00 0.00
heap update_of_key 19.00 -0.00% 0.00
within norms 19.00 19.00 19.00 0.00
heap update_of_key_big 17.00 +8.93% 1.67
outside norms 17.00 20.00 18.67 1.25
heap update_of_primary_key_many_keys 900.00 -8.30% -69.00
outside norms 787.00 900.00 831.00 49.40
heap update_rollback 2.00 -50.00% -0.67
outside norms 1.00 2.00 1.33 0.47
heap update_with_key 91.00 +1.09% 1.00
outside norms 91.00 93.00 92.00 0.82
heap update_with_key_prefix 36.00 -0.93% -0.33
within norms 35.00 36.00 35.67 0.47
heap wisc_benchmark 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
=========================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
heap alter_table_add 12.00 +0.83% 0.10
within norms 11.00 14.00 12.10 0.83
heap alter_table_drop 11.00 +4.35% 0.50
within norms 10.00 13.00 11.50 1.28
heap connect 1.00 +37.50% 0.60
outside norms 1.00 2.00 1.60 0.49
heap connect+select_1_row 2.00 +9.09% 0.20
within norms 2.00 3.00 2.20 0.40
heap connect+select_simple 2.00 -5.26% -0.10
within norms 1.00 2.00 1.90 0.30
heap count 13.00 +11.56% 1.70
within norms 13.00 17.00 14.70 1.73
heap count_distinct 6.00 +6.25% 0.40
within norms 5.00 8.00 6.40 0.92
heap count_distinct_2 11.00 +7.56% 0.90
within norms 11.00 16.00 11.90 1.45
heap count_distinct_big 20.00 +5.66% 1.20
within norms 18.00 25.00 21.20 2.09
heap count_distinct_group 13.00 -0.00% 0.00
within norms 11.00 14.00 13.00 0.77
heap count_distinct_group_on_key 10.00 -8.70% -0.80
within norms 8.00 11.00 9.20 1.08
heap count_distinct_group_on_key_parts 11.00 +7.56% 0.90
within norms 10.00 15.00 11.90 1.64
heap count_distinct_key_prefix 4.00 +14.89% 0.70
outside norms 4.00 6.00 4.70 0.64
heap count_group_on_key_parts 9.00 -11.11% -0.90
outside norms 8.00 9.00 8.10 0.30
heap count_on_key 78.00 -0.26% -0.20
within norms 76.00 83.00 77.80 1.99
heap create+drop 19.00 +3.06% 0.60
within norms 19.00 21.00 19.60 0.66
heap create_index 2.00 +4.76% 0.10
within norms 1.00 3.00 2.10 0.54
heap create_key+drop 23.00 -1.32% -0.30
within norms 22.00 23.00 22.70 0.46
heap create_MANY_tables 18.00 -2.86% -0.50
within norms 15.00 19.00 17.50 1.02
heap create_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap delete_all_many_keys 340.00 -13.45% -40.30
outside norms 273.00 340.00 299.70 16.12
heap delete_autocommit 3.00 -0.00% 0.00
within norms 3.00 3.00 3.00 0.00
heap delete_big 0.00 +100.00% 0.20
within norms 0.00 1.00 0.20 0.40
heap delete_big_many_keys 340.00 -13.56% -40.60
outside norms 273.00 340.00 299.40 16.12
heap delete_commit 1.00 +16.67% 0.20
within norms 1.00 2.00 1.20 0.40
heap delete_key 2.00 +20.00% 0.50
within norms 2.00 3.00 2.50 0.50
heap delete_range 8.00 -12.68% -0.90
outside norms 6.00 8.00 7.10 0.70
heap delete_rollback 1.00 +23.08% 0.30
within norms 1.00 2.00 1.30 0.46
heap drop_index 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap drop_table_when_MANY_tables 14.00 -1.45% -0.20
within norms 13.00 15.00 13.80 0.60
heap insert 90.00 +0.55% 0.50
within norms 88.00 92.00 90.50 1.28
heap insert_autocommit 3.00 -11.11% -0.30
within norms 2.00 3.00 2.70 0.46
heap insert_commit 1.00 +16.67% 0.20
within norms 1.00 2.00 1.20 0.40
heap insert_duplicates 12.00 +5.51% 0.70
outside norms 12.00 13.00 12.70 0.46
heap insert_key 316.00 -7.05% -20.80
outside norms 253.00 316.00 295.20 16.42
heap insert_many_fields 4.00 -0.00% 0.00
within norms 3.00 5.00 4.00 0.45
heap insert_rollback 1.00 +23.08% 0.30
within norms 1.00 2.00 1.30 0.46
heap insert_select_1_key 3.00 +11.76% 0.40
within norms 3.00 4.00 3.40 0.49
heap insert_select_2_keys 6.00 -13.21% -0.70
outside norms 4.00 6.00 5.30 0.64
heap min_max 6.00 +20.00% 1.50
outside norms 6.00 9.00 7.50 1.20
heap min_max_on_key 16.00 +5.33% 0.90
within norms 15.00 18.00 16.90 0.94
heap multiple_value_insert 5.00 -4.17% -0.20
within norms 4.00 5.00 4.80 0.40
heap once_prepared_select 21.00 +0.47% 0.10
within norms 20.00 22.00 21.10 0.54
heap order_by_big 15.00 -4.90% -0.70
within norms 13.00 15.00 14.30 0.90
heap order_by_big_key 11.00 +9.84% 1.20
outside norms 11.00 14.00 12.20 1.17
heap order_by_big_key2 10.00 +13.04% 1.50
outside norms 10.00 13.00 11.50 1.02
heap order_by_big_key_desc 12.00 +6.98% 0.90
within norms 12.00 14.00 12.90 0.94
heap order_by_big_key_diff 11.00 +5.17% 0.60
within norms 10.00 13.00 11.60 1.02
heap order_by_big_key_prefix 12.00 -0.00% 0.00
within norms 11.00 13.00 12.00 0.77
heap order_by_key2_diff 1.00 +16.67% 0.20
within norms 1.00 2.00 1.20 0.40
heap order_by_key_prefix 1.00 -25.00% -0.20
within norms 0.00 1.00 0.80 0.40
heap order_by_range 1.00 -42.86% -0.30
within norms 0.00 1.00 0.70 0.46
heap outer_join 16.00 +8.57% 1.50
within norms 15.00 20.00 17.50 2.06
heap outer_join_found 15.00 +13.79% 2.40
outside norms 15.00 21.00 17.40 2.20
heap outer_join_not_found 14.00 +7.89% 1.20
within norms 13.00 17.00 15.20 1.54
heap outer_join_on_key 12.00 +2.44% 0.30
within norms 11.00 15.00 12.30 1.49
heap prepared_select 28.00 -4.87% -1.30
within norms 24.00 29.00 26.70 1.73
heap select_1_row 3.00 -15.38% -0.40
within norms 2.00 3.00 2.60 0.49
heap select_1_row_cache 2.00 -0.00% 0.00
within norms 2.00 2.00 2.00 0.00
heap select_2_rows 2.00 +9.09% 0.20
within norms 2.00 3.00 2.20 0.40
heap select_big 11.00 +5.17% 0.60
within norms 10.00 13.00 11.60 1.02
heap select_cache 54.00 +7.06% 4.10
within norms 51.00 71.00 58.10 5.49
heap select_cache2 58.00 +2.36% 1.40
within norms 54.00 68.00 59.40 4.82
heap select_column+column 3.00 -15.38% -0.40
within norms 2.00 3.00 2.60 0.49
heap select_diff_key 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap select_distinct 4.00 +2.44% 0.10
within norms 4.00 5.00 4.10 0.30
heap select_group 14.00 +4.76% 0.70
within norms 13.00 17.00 14.70 1.35
heap select_group_when_MANY_tables 4.00 +2.44% 0.10
within norms 4.00 5.00 4.10 0.30
heap select_join 1.00 -100.00% -0.50
within norms 0.00 1.00 0.50 0.50
heap select_key 50.00 -11.11% -5.00
outside norms 42.00 50.00 45.00 2.10
heap select_key2 49.00 +1.01% 0.50
within norms 46.00 54.00 49.50 2.54
heap select_key2_return_key 44.00 +5.17% 2.40
within norms 43.00 51.00 46.40 2.50
heap select_key2_return_prim 50.00 -3.73% -1.80
within norms 44.00 52.00 48.20 2.36
heap select_key_prefix 51.00 +0.58% 0.30
within norms 45.00 57.00 51.30 4.34
heap select_key_prefix_join 4.00 +4.76% 0.20
within norms 4.00 5.00 4.20 0.40
heap select_key_return_key 46.00 -5.26% -2.30
outside norms 41.00 47.00 43.70 2.10
heap select_many_fields 17.00 -3.03% -0.50
within norms 15.00 17.00 16.50 0.67
heap select_range 49.00 +1.01% 0.50
within norms 48.00 57.00 49.50 2.54
heap select_range_key2 7.00 +4.11% 0.30
within norms 7.00 8.00 7.30 0.46
heap select_range_prefix 8.00 -9.59% -0.70
outside norms 7.00 8.00 7.30 0.46
heap select_simple 2.00 -17.65% -0.30
within norms 1.00 2.00 1.70 0.46
heap select_simple_cache 1.00 +9.09% 0.10
within norms 1.00 2.00 1.10 0.30
heap select_simple_join 1.00 -11.11% -0.10
within norms 0.00 1.00 0.90 0.30
heap update_autocommit 3.00 -3.45% -0.10
within norms 2.00 3.00 2.90 0.30
heap update_big 36.00 +1.37% 0.50
within norms 34.00 40.00 36.50 2.29
heap update_commit 1.00 +16.67% 0.20
within norms 1.00 2.00 1.20 0.40
heap update_of_key 19.00 +1.04% 0.20
within norms 19.00 20.00 19.20 0.40
heap update_of_key_big 17.00 +6.08% 1.10
within norms 16.00 20.00 18.10 1.22
heap update_of_primary_key_many_keys 900.00 -9.69% -79.50
outside norms 782.00 900.00 820.50 32.01
heap update_rollback 2.00 -42.86% -0.60
outside norms 1.00 2.00 1.40 0.49
heap update_with_key 91.00 +1.09% 1.00
outside norms 91.00 93.00 92.00 0.89
heap update_with_key_prefix 36.00 -1.12% -0.40
within norms 35.00 36.00 35.60 0.49
heap wisc_benchmark 3.00 -11.11% -0.30
within norms 2.00 3.00 2.70 0.46
=========================================================================================================================
TRENDING OVER ALL runs
Engine Test Time % Diff from Avg Diff
Norm? Min Max Avg STD
=========================================================================================================================
heap alter_table_add 12.00 +0.83% 0.10
within norms 11.00 14.00 12.10 0.77
heap alter_table_drop 11.00 +2.22% 0.25
within norms 10.00 13.00 11.25 0.99
heap connect 1.00 +41.18% 0.70
outside norms 1.00 2.00 1.70 0.46
heap connect+select_1_row 2.00 +11.11% 0.25
within norms 2.00 3.00 2.25 0.43
heap connect+select_simple 2.00 -2.56% -0.05
within norms 1.00 2.00 1.95 0.22
heap count 13.00 +14.19% 2.15
outside norms 13.00 17.00 15.15 1.71
heap count_distinct 6.00 -0.84% -0.05
within norms 5.00 8.00 5.95 0.86
heap count_distinct_2 11.00 +6.38% 0.75
within norms 11.00 16.00 11.75 1.13
heap count_distinct_big 20.00 +6.98% 1.50
within norms 18.00 25.00 21.50 1.94
heap count_distinct_group 13.00 -1.96% -0.25
within norms 11.00 14.00 12.75 0.83
heap count_distinct_group_on_key 10.00 -12.99% -1.15
outside norms 8.00 11.00 8.85 1.11
heap count_distinct_group_on_key_parts 11.00 +7.56% 0.90
within norms 10.00 15.00 11.90 1.41
heap count_distinct_key_prefix 4.00 +13.98% 0.65
outside norms 4.00 6.00 4.65 0.57
heap count_group_on_key_parts 9.00 -13.92% -1.10
outside norms 7.00 10.00 7.90 0.70
heap count_on_key 78.00 -0.97% -0.75
within norms 73.00 83.00 77.25 2.51
heap create+drop 19.00 +2.06% 0.40
within norms 19.00 21.00 19.40 0.58
heap create_index 2.00 -2.56% -0.05
within norms 1.00 3.00 1.95 0.50
heap create_key+drop 23.00 -2.45% -0.55
within norms 21.00 23.00 22.45 0.59
heap create_MANY_tables 18.00 -0.28% -0.05
within norms 15.00 20.00 17.95 1.12
heap create_table 0.00 +100.00% 0.05
within norms 0.00 1.00 0.05 0.22
heap delete_all_many_keys 340.00 -11.86% -36.05
outside norms 273.00 345.00 303.95 18.05
heap delete_autocommit 3.00 -5.26% -0.15
within norms 2.00 3.00 2.85 0.36
heap delete_big 0.00 +100.00% 0.25
within norms 0.00 1.00 0.25 0.43
heap delete_big_many_keys 340.00 -11.92% -36.20
outside norms 273.00 345.00 303.80 18.08
heap delete_commit 1.00 +23.08% 0.30
within norms 1.00 2.00 1.30 0.46
heap delete_key 2.00 +21.57% 0.55
outside norms 2.00 3.00 2.55 0.50
heap delete_range 8.00 -14.29% -1.00
outside norms 6.00 8.00 7.00 0.55
heap delete_rollback 1.00 +25.93% 0.35
within norms 1.00 2.00 1.35 0.48
heap drop_index 2.00 -5.26% -0.10
within norms 1.00 2.00 1.90 0.30
heap drop_table 0.00 NULL 0.00
within norms 0.00 0.00 0.00 0.00
heap drop_table_when_MANY_tables 14.00 -2.19% -0.30
within norms 13.00 15.00 13.70 0.56
heap insert 90.00 +0.77% 0.70
within norms 88.00 93.00 90.70 1.35
heap insert_autocommit 3.00 -15.38% -0.40
within norms 2.00 3.00 2.60 0.49
heap insert_commit 1.00 +9.09% 0.10
within norms 1.00 2.00 1.10 0.30
heap insert_duplicates 12.00 +6.25% 0.80
outside norms 12.00 14.00 12.80 0.60
heap insert_key 316.00 -3.83% -11.65
within norms 253.00 345.00 304.35 19.32
heap insert_many_fields 4.00 +2.44% 0.10
within norms 3.00 5.00 4.10 0.44
heap insert_rollback 1.00 +28.57% 0.40
within norms 1.00 2.00 1.40 0.49
heap insert_select_1_key 3.00 +14.29% 0.50
within norms 3.00 4.00 3.50 0.50
heap insert_select_2_keys 6.00 -15.38% -0.80
outside norms 4.00 6.00 5.20 0.51
heap min_max 6.00 +21.05% 1.60
outside norms 6.00 9.00 7.60 1.02
heap min_max_on_key 16.00 +6.43% 1.10
within norms 15.00 20.00 17.10 1.18
heap multiple_value_insert 5.00 -8.70% -0.40
within norms 4.00 5.00 4.60 0.49
heap once_prepared_select 21.00 -0.24% -0.05
within norms 20.00 22.00 20.95 0.67
heap order_by_big 15.00 -6.76% -0.95
within norms 12.00 15.00 14.05 0.97
heap order_by_big_key 11.00 +9.84% 1.20
outside norms 11.00 14.00 12.20 1.08
heap order_by_big_key2 10.00 +13.04% 1.50
outside norms 10.00 13.00 11.50 1.02
heap order_by_big_key_desc 12.00 +6.61% 0.85
within norms 12.00 14.00 12.85 0.91
heap order_by_big_key_diff 11.00 +4.76% 0.55
within norms 10.00 13.00 11.55 0.92
heap order_by_big_key_prefix 12.00 -0.42% -0.05
within norms 11.00 13.00 11.95 0.80
heap order_by_key2_diff 1.00 +16.67% 0.20
within norms 1.00 2.00 1.20 0.40
heap order_by_key_prefix 1.00 -66.67% -0.40
within norms 0.00 1.00 0.60 0.49
heap order_by_range 1.00 -25.00% -0.20
within norms 0.00 1.00 0.80 0.40
heap outer_join 16.00 +9.35% 1.65
within norms 15.00 21.00 17.65 2.26
heap outer_join_found 15.00 +12.79% 2.20
within norms 14.00 21.00 17.20 2.27
heap outer_join_not_found 14.00 +7.59% 1.15
within norms 13.00 17.00 15.15 1.56
heap outer_join_on_key 12.00 +1.23% 0.15
within norms 10.00 15.00 12.15 1.56
heap prepared_select 28.00 -7.49% -1.95
within norms 22.00 29.00 26.05 2.18
heap select_1_row 3.00 -20.00% -0.50
within norms 2.00 3.00 2.50 0.50
heap select_1_row_cache 2.00 +4.76% 0.10
within norms 2.00 3.00 2.10 0.30
heap select_2_rows 2.00 +9.09% 0.20
within norms 2.00 3.00 2.20 0.40
heap select_big 11.00 +5.17% 0.60
within norms 10.00 13.00 11.60 0.97
heap select_cache 54.00 +6.49% 3.75
within norms 51.00 71.00 57.75 5.43
heap select_cache2 58.00 -1.31% -0.75
within norms 51.00 68.00 57.25 4.69
heap select_column+column 3.00 -15.38% -0.40
within norms 2.00 3.00 2.60 0.49
heap select_diff_key 0.00 +100.00% 0.15
within norms 0.00 1.00 0.15 0.36
heap select_distinct 4.00 -2.56% -0.10
within norms 3.00 5.00 3.90 0.44
heap select_group 14.00 +6.67% 1.00
within norms 13.00 18.00 15.00 1.48
heap select_group_when_MANY_tables 4.00 -0.00% 0.00
within norms 3.00 5.00 4.00 0.32
heap select_join 1.00 -185.71% -0.65
outside norms 0.00 1.00 0.35 0.48
heap select_key 50.00 -12.36% -5.50
outside norms 40.00 50.00 44.50 2.52
heap select_key2 49.00 +0.91% 0.45
within norms 46.00 54.00 49.45 2.62
heap select_key2_return_key 44.00 +5.68% 2.65
outside norms 43.00 51.00 46.65 2.33
heap select_key2_return_prim 50.00 -3.95% -1.90
within norms 43.00 53.00 48.10 2.53
heap select_key_prefix 51.00 +0.10% 0.05
within norms 45.00 57.00 51.05 3.61
heap select_key_prefix_join 4.00 +5.88% 0.25
within norms 4.00 5.00 4.25 0.43
heap select_key_return_key 46.00 -6.73% -2.90
outside norms 39.00 47.00 43.10 2.34
heap select_many_fields 17.00 -3.34% -0.55
within norms 15.00 17.00 16.45 0.67
heap select_range 49.00 +0.10% 0.05
within norms 48.00 57.00 49.05 1.91
heap select_range_key2 7.00 +2.10% 0.15
within norms 6.00 8.00 7.15 0.57
heap select_range_prefix 8.00 -11.89% -0.85
outside norms 6.00 8.00 7.15 0.65
heap select_simple 2.00 -33.33% -0.50
within norms 1.00 2.00 1.50 0.50
heap select_simple_cache 1.00 +13.04% 0.15
within norms 1.00 2.00 1.15 0.36
heap select_simple_join 1.00 -17.65% -0.15
within norms 0.00 1.00 0.85 0.36
heap update_autocommit 3.00 -7.14% -0.20
within norms 2.00 3.00 2.80 0.40
heap update_big 36.00 +1.23% 0.45
within norms 32.00 40.00 36.45 2.50
heap update_commit 1.00 +25.93% 0.35
within norms 1.00 2.00 1.35 0.48
heap update_of_key 19.00 +0.78% 0.15
within norms 19.00 20.00 19.15 0.36
heap update_of_key_big 17.00 +7.86% 1.45
outside norms 16.00 20.00 18.45 1.07
heap update_of_primary_key_many_keys 900.00 -7.83% -65.35
outside norms 782.00 947.00 834.65 43.45
heap update_rollback 2.00 -42.86% -0.60
outside norms 1.00 2.00 1.40 0.49
heap update_with_key 91.00 +1.03% 0.95
outside norms 91.00 93.00 91.95 0.86
heap update_with_key_prefix 36.00 -1.84% -0.65
outside norms 34.00 36.00 35.35 0.57
heap wisc_benchmark 3.00 -22.45% -0.55
outside norms 2.00 3.00 2.45 0.50
=========================================================================================================================
FULL REVISION COMMENTARY:
1235.1.4: Brian Aker 2009-12-01 [merge] Merge of identifier work.
1235.2.1: Brian Aker 2009-12-01 More identifier work.
1235.1.3: Brian Aker 2009-12-01 Remove the need for trans/non-trans temp t...
1235.1.2: Brian Aker 2009-12-01 Added engine flag so that an engine can sk...
1235.1.1: Brian Aker 2009-12-01 [merge] Merge Monty.
1233.2.1: Monty Taylor 2009-12-01 Renamed instances of HEAP engine to MEMO...
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
