OSDB-results
application/x-java-applet
Filename: OSDB-results
Type: application/x-java-applet
Part: 0
Message:
Re: FUNC_MAX_ARGS benchmarks
*********************************************************************************
NAMEDATALEN = 32, FUNC_MAX_ARGS = 32
$ osdb-pg --datadir /opt/src/osdb/data --postgresql=no_hash_index
"osdb"
"Invoked: osdb-pg --datadir /opt/src/osdb/data --postgresql=no_hash_index"
Ignore message if "drobdb" fails
create_tables() 0.04 seconds return value = 0
load() 22.48 seconds return value = 0
create_idx_uniques_key_bt() 5.80 seconds return value = 0
create_idx_updates_key_bt() 5.96 seconds return value = 0
create_idx_hundred_key_bt() 5.56 seconds return value = 0
create_idx_tenpct_key_bt() 5.29 seconds return value = 0
create_idx_tenpct_key_code_bt() 0.89 seconds return value = 0
create_idx_tiny_key_bt() 0.01 seconds return value = 0
create_idx_tenpct_int_bt() 0.65 seconds return value = 0
create_idx_tenpct_signed_bt() 0.90 seconds return value = 0
create_idx_uniques_code_h() 1.42 seconds return value = 0
create_idx_tenpct_double_bt() 1.06 seconds return value = 0
create_idx_updates_decim_bt() 2.27 seconds return value = 0
create_idx_tenpct_float_bt() 1.09 seconds return value = 0
create_idx_updates_int_bt() 0.60 seconds return value = 0
create_idx_tenpct_decim_bt() 2.12 seconds return value = 0
create_idx_hundred_code_h() 1.36 seconds return value = 0
create_idx_tenpct_name_h() 1.39 seconds return value = 0
create_idx_updates_code_h() 1.27 seconds return value = 0
create_idx_tenpct_code_h() 1.28 seconds return value = 0
create_idx_updates_double_bt() 1.09 seconds return value = 0
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
create_idx_hundred_foreign() 11.46 seconds return value = 0
populateDataBase() 73.99 seconds return value = 0
"Logical database size 40MB"
sel_1_cl() 0.01 seconds return value = 1
join_3_cl() 0.01 seconds return value = 0
sel_100_ncl() 0.22 seconds return value = 100
table_scan() 0.16 seconds return value = 0
agg_func() 4.46 seconds return value = 100
agg_scal() 0.23 seconds return value = 0
sel_100_cl() 0.22 seconds return value = 100
join_3_ncl() 6.63 seconds return value = 1
sel_10pct_ncl() 7.61 seconds return value = 10000
agg_simple_report() 63.87 seconds return value = 990009900
agg_info_retrieval() 0.07 seconds return value = 0
agg_create_view() 0.01 seconds return value = 0
agg_subtotal_report() 12.88 seconds return value = 1000
agg_total_report() 3.13 seconds return value = 932849
join_2_cl() 0.01 seconds return value = 0
join_2() 1.77 seconds return value = 1000
sel_variable_select_low() 0.15 seconds return value = 0
sel_variable_select_high() 28.50 seconds return value = 25000
join_4_cl() 0.01 seconds return value = 0
proj_100() 124.30 seconds return value = 10000
join_4_ncl() 10.18 seconds return value = 1
proj_10pct() 1641.35 seconds return value = 100000
sel_1_ncl() 0.01 seconds return value = 1
join_2_ncl() 3.46 seconds return value = 1
integrity_test() 0.33 seconds return value = 0
drop_updates_keys() 0.03 seconds return value = 0
bulk_save() 0.04 seconds return value = 0
bulk_modify() 146.34 seconds return value = 0
upd_append_duplicate() 0.03 seconds return value = 0
upd_remove_duplicate() 0.00 seconds return value = 0
upd_app_t_mid() 0.01 seconds return value = 1
upd_mod_t_mid() 0.15 seconds return value = 0
upd_del_t_mid() 0.15 seconds return value = 0
upd_app_t_end() 0.00 seconds return value = 1
upd_mod_t_end() 0.15 seconds return value = 0
upd_del_t_end() 0.15 seconds return value = 0
create_idx_updates_code_h() 1.34 seconds return value = 0
upd_app_t_mid() 0.01 seconds return value = 1
upd_mod_t_cod() 0.00 seconds return value = 0
upd_del_t_mid() 0.16 seconds return value = 0
create_idx_updates_int_bt() 0.61 seconds return value = 0
upd_app_t_mid() 0.01 seconds return value = 1
upd_mod_t_int() 0.00 seconds return value = 0
upd_del_t_mid() 0.15 seconds return value = 0
bulk_append() 0.30 seconds return value = 0
bulk_delete() 146.66 seconds return value = 0
"Single User Test" 2205.89 seconds (0:36:45.89)
Starting multi-user test
"Executing multi-user tests with 10 user tasks"
warming up: 1 minute to go
Proceeding with 5 minute test
Mixed IR (tup/sec) 26.84 returned in 5.02 minutes
sel_1_ncl() 0.00 seconds return value = 1
agg_simple_report() 756.01 seconds return value = 990009900
mu_sel_100_seq() 6.22 seconds return value = 0
mu_sel_100_rand() 7.01 seconds return value = 0
mu_mod_100_seq_abort() 0.03 seconds return value = 0
mu_mod_100_rand() 3.37 seconds return value = 0
mu_unmod_100_seq() 0.24 seconds return value = 0
mu_unmod_100_rand() 0.02 seconds return value = 0
crossSectionTests(Mixed IR) 772.90
mu_checkmod_100_seq() 0.02 seconds return value = 100
mu_checkmod_100_rand() 1.82 seconds return value = 100
warming up: 1 minute to go
Proceeding with 5 minute test
Mixed OLTP (tup/sec) 83.55 returned in 5.00 minutes
sel_1_ncl() 0.14 seconds return value = 1
agg_simple_report() 192.83 seconds return value = 990009900
mu_sel_100_seq() 0.36 seconds return value = 0
mu_sel_100_rand() 0.36 seconds return value = 0
mu_mod_100_seq_abort() 1.57 seconds return value = 0
mu_mod_100_rand() 0.50 seconds return value = 0
mu_unmod_100_seq() 0.14 seconds return value = 0
mu_unmod_100_rand() 0.31 seconds return value = 0
crossSectionTests(Mixed OLTP) 196.21
mu_checkmod_100_seq() 0.34 seconds return value = 100
mu_checkmod_100_rand() 5.51 seconds return value = 100
"Multi-User Test" 3403.84 seconds (0:56:43.84)
*********************************************************************************
NAMEDATALEN = 128, FUNC_MAX_ARGS = 32
$ osdb-pg --datadir /opt/src/osdb/data --postgresql=no_hash_index
"osdb"
"Invoked: osdb-pg --datadir /opt/src/osdb/data --postgresql=no_hash_index"
Ignore message if "drobdb" fails
create_tables() 0.06 seconds return value = 0
load() 25.55 seconds return value = 0
create_idx_uniques_key_bt() 7.54 seconds return value = 0
create_idx_updates_key_bt() 6.74 seconds return value = 0
create_idx_hundred_key_bt() 6.53 seconds return value = 0
create_idx_tenpct_key_bt() 5.74 seconds return value = 0
create_idx_tenpct_key_code_bt() 1.01 seconds return value = 0
create_idx_tiny_key_bt() 0.01 seconds return value = 0
create_idx_tenpct_int_bt() 0.61 seconds return value = 0
create_idx_tenpct_signed_bt() 0.93 seconds return value = 0
create_idx_uniques_code_h() 1.43 seconds return value = 0
create_idx_tenpct_double_bt() 1.20 seconds return value = 0
create_idx_updates_decim_bt() 2.49 seconds return value = 0
create_idx_tenpct_float_bt() 1.23 seconds return value = 0
create_idx_updates_int_bt() 0.61 seconds return value = 0
create_idx_tenpct_decim_bt() 2.29 seconds return value = 0
create_idx_hundred_code_h() 1.39 seconds return value = 0
create_idx_tenpct_name_h() 1.45 seconds return value = 0
create_idx_updates_code_h() 1.28 seconds return value = 0
create_idx_tenpct_code_h() 1.47 seconds return value = 0
create_idx_updates_double_bt() 1.18 seconds return value = 0
NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
create_idx_hundred_foreign() 11.64 seconds return value = 0
populateDataBase() 82.38 seconds return value = 0
"Logical database size 40MB"
sel_1_cl() 0.02 seconds return value = 1
join_3_cl() 0.01 seconds return value = 0
sel_100_ncl() 0.24 seconds return value = 100
table_scan() 0.16 seconds return value = 0
agg_func() 4.59 seconds return value = 100
agg_scal() 0.25 seconds return value = 0
sel_100_cl() 0.23 seconds return value = 100
join_3_ncl() 7.17 seconds return value = 1
sel_10pct_ncl() 8.21 seconds return value = 10000
agg_simple_report() 64.77 seconds return value = 990009900
agg_info_retrieval() 0.09 seconds return value = 0
agg_create_view() 0.03 seconds return value = 0
agg_subtotal_report() 13.07 seconds return value = 1000
agg_total_report() 3.02 seconds return value = 932849
join_2_cl() 0.01 seconds return value = 0
join_2() 1.84 seconds return value = 1000
sel_variable_select_low() 0.14 seconds return value = 0
sel_variable_select_high() 29.73 seconds return value = 25000
join_4_cl() 0.01 seconds return value = 0
proj_100() 126.96 seconds return value = 10000
join_4_ncl() 13.95 seconds return value = 1
proj_10pct() 1680.25 seconds return value = 100000
sel_1_ncl() 0.01 seconds return value = 1
join_2_ncl() 3.48 seconds return value = 1
integrity_test() 0.30 seconds return value = 0
drop_updates_keys() 0.03 seconds return value = 0
bulk_save() 0.04 seconds return value = 0
bulk_modify() 147.22 seconds return value = 0
upd_append_duplicate() 0.08 seconds return value = 0
upd_remove_duplicate() 0.00 seconds return value = 0
upd_app_t_mid() 0.01 seconds return value = 1
upd_mod_t_mid() 0.15 seconds return value = 0
upd_del_t_mid() 0.15 seconds return value = 0
upd_app_t_end() 0.01 seconds return value = 1
upd_mod_t_end() 0.15 seconds return value = 0
upd_del_t_end() 0.15 seconds return value = 0
create_idx_updates_code_h() 1.47 seconds return value = 0
upd_app_t_mid() 0.01 seconds return value = 1
upd_mod_t_cod() 0.01 seconds return value = 0
upd_del_t_mid() 0.16 seconds return value = 0
create_idx_updates_int_bt() 0.61 seconds return value = 0
upd_app_t_mid() 0.01 seconds return value = 1
upd_mod_t_int() 0.01 seconds return value = 0
upd_del_t_mid() 0.15 seconds return value = 0
bulk_append() 0.33 seconds return value = 0
bulk_delete() 146.86 seconds return value = 0
"Single User Test" 2256.16 seconds (0:37:36.16)
Starting multi-user test
"Executing multi-user tests with 10 user tasks"
warming up: 1 minute to go
Proceeding with 5 minute test
Mixed IR (tup/sec) 27.29 returned in 5.02 minutes
sel_1_ncl() 0.00 seconds return value = 1
agg_simple_report() 778.25 seconds return value = 990009900
mu_sel_100_seq() 8.02 seconds return value = 0
mu_sel_100_rand() 0.19 seconds return value = 0
mu_mod_100_seq_abort() 0.11 seconds return value = 0
mu_mod_100_rand() 1.08 seconds return value = 0
mu_unmod_100_seq() 0.39 seconds return value = 0
mu_unmod_100_rand() 0.02 seconds return value = 0
crossSectionTests(Mixed IR) 788.06
mu_checkmod_100_seq() 0.02 seconds return value = 100
mu_checkmod_100_rand() 1.73 seconds return value = 100
warming up: 1 minute to go
Proceeding with 5 minute test
Mixed OLTP (tup/sec) 81.50 returned in 5.00 minutes
sel_1_ncl() 0.09 seconds return value = 1
agg_simple_report() 187.54 seconds return value = 990009900
mu_sel_100_seq() 2.18 seconds return value = 0
mu_sel_100_rand() 0.15 seconds return value = 0
mu_mod_100_seq_abort() 0.08 seconds return value = 0
mu_mod_100_rand() 0.05 seconds return value = 0
mu_unmod_100_seq() 0.15 seconds return value = 0
mu_unmod_100_rand() 0.07 seconds return value = 0
crossSectionTests(Mixed OLTP) 190.31
mu_checkmod_100_seq() 0.04 seconds return value = 100
mu_checkmod_100_rand() 4.25 seconds return value = 100
"Multi-User Test" 3412.18 seconds (0:56:52.18)