ldas-dev Database dev_1 Insertion Rates
| Test Period | June 02 2003 17:30:13 | |
|---|---|---|
| Input data | Ilwd with dimensions 1,10,100,1000 | |
| Platform | SunOS metaserver 5.9 Generic_112233-04 sun4u sparc SUNW,Ultra-4 Memory: 4096M real, 3316M free, 853M swap in use, 19G swap free |
|
| LDAS software | ldas-0.6.111, IBM DB2 7.1 |
Results are displayed in the order inserted.
| Table | #rows per block insert | CPU time (secs) | Wall Time (secs) | Rate (#rows/sec) | process | 1 | 0.000 | 0.029 | 34.945 | process | 10 | 0.000 | 1.046 | 9.560 | process | 100 | 0.000 | 0.897 | 111.437 | process | 1000 | 0.000 | 2.008 | 498.008 | runlist | 1 | 0.000 | 0.023 | 42.719 | runlist | 10 | 0.000 | 0.027 | 374.756 | runlist | 100 | 0.000 | 0.732 | 136.577 | runlist | 1000 | 0.000 | 1.050 | 952.381 | calib_info | 1 | 0.000 | 0.070 | 14.198 | calib_info | 10 | 0.000 | 0.718 | 13.930 | calib_info | 100 | 0.000 | 1.033 | 96.805 | calib_info | 1000 | 0.000 | 2.415 | 414.079 | sim_type | 1 | 0.000 | 0.174 | 5.762 | sim_type | 10 | 0.000 | 0.520 | 19.216 | sim_type | 100 | 0.000 | 0.434 | 230.573 | sim_type | 1000 | 0.000 | 2.935 | 340.716 | process_params | 1 | 0.000 | 0.024 | 41.317 | process_params | 10 | 0.000 | 0.519 | 19.258 | process_params | 100 | 0.000 | 0.084 | 1187.366 | process_params | 1000 | 0.000 | 1.081 | 925.069 | frameset_chanlist | 1 | 0.000 | 0.046 | 21.883 | frameset_chanlist | 10 | 0.000 | 0.464 | 21.560 | frameset_chanlist | 100 | 0.000 | 0.592 | 168.868 | frameset_chanlist | 1000 | 0.000 | 1.759 | 568.505 | frameset_writer | 1 | 0.000 | 0.046 | 21.560 | frameset_writer | 10 | 0.000 | 0.714 | 14.009 | frameset_writer | 100 | 0.000 | 0.372 | 268.610 | frameset_writer | 1000 | 0.000 | 0.669 | 1493.980 | segment_definer | 1 | 0.000 | 0.038 | 26.201 | segment_definer | 10 | 0.000 | 0.735 | 13.600 | segment_definer | 100 | 0.000 | 0.683 | 146.377 | segment_definer | 1000 | 0.000 | 1.081 | 925.069 | filter | 1 | 0.000 | 0.050 | 20.174 | filter | 10 | 0.000 | 0.892 | 11.206 | filter | 100 | 0.000 | 0.711 | 140.716 | filter | 1000 | 0.000 | 1.925 | 519.481 | search_summary | 1 | 0.000 | 0.039 | 25.487 | search_summary | 10 | 0.000 | 0.457 | 21.863 | search_summary | 100 | 0.000 | 0.771 | 129.633 | search_summary | 1000 | 0.000 | 1.271 | 786.782 | sim_inst | 1 | 0.000 | 0.043 | 23.294 | sim_inst | 10 | 0.000 | 1.044 | 9.579 | sim_inst | 100 | 0.000 | 0.463 | 215.888 | sim_inst | 1000 | 0.000 | 1.292 | 773.994 | sim_type_params | 1 | 0.000 | 0.023 | 43.516 | sim_type_params | 10 | 0.000 | 0.902 | 11.083 | sim_type_params | 100 | 0.000 | 0.534 | 187.261 | sim_type_params | 1000 | 0.000 | 0.382 | 2616.062 | frameset | 1 | 0.000 | 0.055 | 18.230 | frameset | 10 | 0.000 | 0.717 | 13.949 | frameset | 100 | 0.000 | 0.251 | 398.283 | frameset | 1000 | 0.000 | 1.424 | 702.247 | segment | 1 | 0.000 | 0.041 | 24.637 | segment | 10 | 0.000 | 0.900 | 11.107 | segment | 100 | 0.000 | 0.542 | 184.555 | segment | 1000 | 0.000 | 1.518 | 658.762 | filter_params | 1 | 0.000 | 0.048 | 21.032 | filter_params | 10 | 0.000 | 0.902 | 11.090 | filter_params | 100 | 0.000 | 0.444 | 225.044 | filter_params | 1000 | 0.000 | 1.461 | 684.463 | gds_trigger | 1 | 0.000 | 0.075 | 13.420 | gds_trigger | 10 | 0.000 | 1.065 | 9.390 | gds_trigger | 100 | 0.000 | 1.142 | 87.566 | gds_trigger | 1000 | 0.000 | 1.986 | 503.525 | sngl_inspiral | 1 | 0.000 | 1.100 | 0.909 | sngl_inspiral | 10 | 0.000 | 0.904 | 11.068 | sngl_inspiral | 100 | 0.000 | 0.530 | 188.542 | sngl_inspiral | 1000 | 0.000 | 2.012 | 497.018 | sngl_burst | 1 | 0.000 | 1.083 | 0.923 | sngl_burst | 10 | 0.000 | 0.072 | 138.962 | sngl_burst | 100 | 0.000 | 0.912 | 109.666 | sngl_burst | 1000 | 0.000 | 1.957 | 510.986 | sngl_ringdown | 1 | 0.000 | 0.119 | 8.421 | sngl_ringdown | 10 | 0.000 | 0.185 | 54.200 | sngl_ringdown | 100 | 0.000 | 1.164 | 85.911 | sngl_ringdown | 1000 | 0.000 | 1.960 | 510.204 | sngl_unmodeled | 1 | 0.000 | 0.901 | 1.110 | sngl_unmodeled | 10 | 0.000 | 0.972 | 10.293 | sngl_unmodeled | 100 | 0.000 | 1.194 | 83.752 | sngl_unmodeled | 1000 | 0.000 | 1.951 | 512.558 | sngl_dperiodic | 1 | 0.000 | 0.518 | 1.930 | sngl_dperiodic | 10 | 0.000 | 0.087 | 114.533 | sngl_dperiodic | 100 | 0.000 | 0.752 | 132.930 | sngl_dperiodic | 1000 | 0.000 | 2.012 | 497.018 | multi_inspiral | 1 | 0.000 | 0.475 | 2.105 | multi_inspiral | 10 | 0.000 | 1.071 | 9.337 | multi_inspiral | 100 | 0.000 | 0.513 | 195.063 | multi_inspiral | 1000 | 0.000 | 2.062 | 484.966 | multi_burst | 1 | 0.000 | 0.552 | 1.811 | multi_burst | 10 | 0.000 | 0.486 | 20.559 | multi_burst | 100 | 0.000 | 0.911 | 109.769 | multi_burst | 1000 | 0.000 | 1.960 | 510.204 | exttrig_search | 1 | 0.000 | 0.655 | 1.527 | exttrig_search | 10 | 0.000 | 0.970 | 10.310 | exttrig_search | 100 | 0.000 | 0.633 | 157.864 | exttrig_search | 1000 | 0.000 | 1.973 | 506.842 | sim_inst_params | 1 | 0.000 | 0.038 | 26.412 | sim_inst_params | 10 | 0.000 | 0.025 | 392.341 | sim_inst_params | 100 | 0.000 | 1.032 | 96.899 | sim_inst_params | 1000 | 0.000 | 0.764 | 1309.032 | waveburst | 1 | 0.000 | 0.288 | 3.475 | waveburst | 10 | 0.000 | 0.680 | 14.709 | waveburst | 100 | 0.000 | 0.404 | 247.380 | waveburst | 1000 | 0.000 | 2.072 | 482.625 | frameset_loc | 1 | 0.000 | 1.051 | 0.951 | frameset_loc | 10 | 0.000 | 0.900 | 11.106 | frameset_loc | 100 | 0.000 | 0.914 | 109.469 | frameset_loc | 1000 | 0.000 | 1.172 | 853.242 | summ_value | 1 | 0.000 | 0.422 | 2.371 | summ_value | 10 | 0.000 | 1.042 | 9.597 | summ_value | 100 | 0.000 | 0.683 | 146.370 | summ_value | 1000 | 0.000 | 0.701 | 1427.285 | summ_statistics | 1 | 0.000 | 1.075 | 0.930 | summ_statistics | 10 | 0.000 | 0.180 | 55.540 | summ_statistics | 100 | 0.000 | 0.221 | 451.843 | summ_statistics | 1000 | 0.000 | 1.030 | 970.874 | summ_spectrum | 1 | 0.000 | 0.125 | 8.005 | summ_spectrum | 10 | 0.000 | 0.239 | 41.824 | summ_spectrum | 100 | 0.000 | 1.054 | 94.877 | summ_spectrum | 1000 | 0.000 | 3.141 | 318.370 | summ_comment | 1 | 0.000 | 0.155 | 6.435 | summ_comment | 10 | 0.000 | 0.758 | 13.196 | summ_comment | 100 | 0.000 | 0.941 | 106.270 | summ_comment | 1000 | 0.000 | 1.952 | 512.295 | summ_csd | 1 | 0.000 | 0.215 | 4.642 | summ_csd | 10 | 0.000 | 0.910 | 10.984 | summ_csd | 100 | 0.000 | 1.112 | 89.928 | summ_csd | 1000 | 0.000 | 3.165 | 315.956 | summ_mime | 1 | 0.000 | 0.274 | 3.649 | summ_mime | 10 | 0.000 | 1.052 | 9.506 | summ_mime | 100 | 0.000 | 0.533 | 187.502 | summ_mime | 1000 | 0.000 | 4.051 | 246.853 | sngl_unmodeled_v | 1 | 0.000 | 0.416 | 2.402 | sngl_unmodeled_v | 10 | 0.000 | 0.192 | 52.161 | sngl_unmodeled_v | 100 | 0.000 | 0.250 | 400.269 | sngl_unmodeled_v | 1000 | 0.000 | 1.322 | 756.430 | coinc_sngl | 1 | 0.000 | 1.208 | 0.828 | coinc_sngl | 10 | 0.000 | 1.122 | 8.913 | coinc_sngl | 100 | 0.000 | 0.641 | 156.098 | coinc_sngl | 1000 | 0.000 | 4.718 | 211.954 | search_summvars | 1 | 0.000 | 0.022 | 46.432 | search_summvars | 10 | 0.000 | 0.533 | 18.778 | search_summvars | 100 | 0.000 | 0.532 | 188.030 | search_summvars | 1000 | 0.000 | 0.437 | 2290.122 | waveburst_mime | 1 | 0.000 | 0.102 | 9.798 | waveburst_mime | 10 | 0.000 | 0.195 | 51.283 | waveburst_mime | 100 | 0.000 | 0.941 | 106.248 | waveburst_mime | 1000 | 0.000 | 4.183 | 239.063 | sngl_transdata | 1 | 0.000 | 1.095 | 0.913 | sngl_transdata | 10 | 0.000 | 0.540 | 18.503 | sngl_transdata | 100 | 0.000 | 0.718 | 139.249 | sngl_transdata | 1000 | 0.000 | 5.768 | 173.370 | sngl_mime | 1 | 0.000 | 0.904 | 1.106 | sngl_mime | 10 | 0.000 | 0.543 | 18.428 | sngl_mime | 100 | 0.000 | 0.623 | 160.554 | sngl_mime | 1000 | 0.000 | 7.126 | 140.331 | sngl_datasource | 1 | 0.000 | 0.527 | 1.897 | sngl_datasource | 10 | 0.000 | 0.583 | 17.143 | sngl_datasource | 100 | 0.000 | 1.044 | 95.785 | sngl_datasource | 1000 | 0.000 | 1.505 | 664.452 |
|---|
Summary: