ldas-dev Database dev_1 Insertion Rates
| Test Period | October 16 2003 18:09:03 | |
|---|---|---|
| Input data | Ilwd with dimensions 1,10,100,1000 | |
| Platform | SunOS ldas-dev 5.9 Generic_112233-07 sun4u sparc SUNW,Sun-Fire-280R Solaris Memory: 8192M real, 6982M free, 147M swap in use, 6284M swap free |
|
| LDAS software | ldas-0.7.149, IBM DB2 7.2 |
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.012 | 81.387 | process | 10 | 0.000 | 0.002 | 5991.432 | process | 100 | 0.000 | 0.007 | 13852.181 | process | 1000 | 0.000 | 0.133 | 7525.360 | runlist | 1 | 0.000 | 0.002 | 430.849 | runlist | 10 | 0.000 | 0.001 | 8097.887 | runlist | 100 | 0.000 | 0.015 | 6585.013 | runlist | 1000 | 0.000 | 0.057 | 17586.128 | calib_info | 1 | 0.000 | 0.003 | 322.788 | calib_info | 10 | 0.000 | 0.004 | 2357.345 | calib_info | 100 | 0.000 | 0.050 | 2015.926 | calib_info | 1000 | 0.000 | 1.477 | 676.915 | sim_type | 1 | 0.000 | 0.026 | 38.503 | sim_type | 10 | 0.000 | 0.004 | 2848.232 | sim_type | 100 | 0.000 | 0.045 | 2214.496 | sim_type | 1000 | 0.000 | 0.344 | 2909.548 | process_params | 1 | 0.000 | 0.004 | 257.264 | process_params | 10 | 0.000 | 0.001 | 7757.892 | process_params | 100 | 0.000 | 0.006 | 16363.854 | process_params | 1000 | 0.000 | 0.155 | 6461.075 | frameset_chanlist | 1 | 0.000 | 0.004 | 276.322 | frameset_chanlist | 10 | 0.000 | 0.001 | 7491.142 | frameset_chanlist | 100 | 0.000 | 0.005 | 20601.735 | frameset_chanlist | 1000 | 0.000 | 0.050 | 19885.104 | frameset_writer | 1 | 0.000 | 0.005 | 189.680 | frameset_writer | 10 | 0.000 | 0.001 | 6720.566 | frameset_writer | 100 | 0.000 | 0.015 | 6689.411 | frameset_writer | 1000 | 0.000 | 0.109 | 9187.208 | segment_definer | 1 | 0.000 | 0.005 | 214.636 | segment_definer | 10 | 0.000 | 0.002 | 4679.567 | segment_definer | 100 | 0.000 | 0.018 | 5683.465 | segment_definer | 1000 | 0.000 | 0.315 | 3174.825 | filter | 1 | 0.000 | 0.004 | 269.765 | filter | 10 | 0.000 | 0.001 | 7087.373 | filter | 100 | 0.000 | 0.007 | 14166.353 | filter | 1000 | 0.000 | 0.074 | 13527.590 | search_summary | 1 | 0.000 | 0.004 | 244.916 | search_summary | 10 | 0.000 | 0.002 | 5136.291 | search_summary | 100 | 0.000 | 0.014 | 7180.864 | search_summary | 1000 | 0.000 | 0.358 | 2789.844 | sim_inst | 1 | 0.000 | 0.004 | 260.217 | sim_inst | 10 | 0.000 | 0.001 | 7163.016 | sim_inst | 100 | 0.000 | 0.005 | 19821.841 | sim_inst | 1000 | 0.000 | 0.047 | 21119.324 | sim_type_params | 1 | 0.000 | 0.003 | 298.325 | sim_type_params | 10 | 0.000 | 0.001 | 8525.876 | sim_type_params | 100 | 0.000 | 0.010 | 9619.084 | sim_type_params | 1000 | 0.000 | 0.083 | 11986.671 | frameset | 1 | 0.000 | 0.005 | 210.790 | frameset | 10 | 0.000 | 0.004 | 2788.584 | frameset | 100 | 0.000 | 0.009 | 11030.235 | frameset | 1000 | 0.000 | 0.075 | 13373.454 | segment | 1 | 0.000 | 0.004 | 265.253 | segment | 10 | 0.000 | 0.002 | 4566.231 | segment | 100 | 0.000 | 0.016 | 6427.561 | segment | 1000 | 0.000 | 0.265 | 3774.482 | filter_params | 1 | 0.000 | 0.004 | 243.190 | filter_params | 10 | 0.000 | 0.002 | 6535.734 | filter_params | 100 | 0.000 | 0.008 | 12003.274 | filter_params | 1000 | 0.000 | 0.135 | 7429.586 | gds_trigger | 1 | 0.000 | 0.005 | 196.773 | gds_trigger | 10 | 0.000 | 0.002 | 4239.030 | gds_trigger | 100 | 0.000 | 0.017 | 5941.771 | gds_trigger | 1000 | 0.000 | 0.349 | 2865.149 | sngl_inspiral | 1 | 0.000 | 0.005 | 183.317 | sngl_inspiral | 10 | 0.000 | 0.002 | 4703.448 | sngl_inspiral | 100 | 0.000 | 0.019 | 5275.402 | sngl_inspiral | 1000 | 0.000 | 0.477 | 2098.402 | sngl_burst | 1 | 0.000 | 0.005 | 206.652 | sngl_burst | 10 | 0.000 | 0.003 | 3505.033 | sngl_burst | 100 | 0.000 | 0.009 | 11145.725 | sngl_burst | 1000 | 0.000 | 0.299 | 3340.025 | sngl_block | 1 | 0.000 | 0.005 | 206.398 | sngl_block | 10 | 0.000 | 0.002 | 5367.687 | sngl_block | 100 | 0.000 | 0.011 | 9279.881 | sngl_block | 1000 | 0.000 | 0.310 | 3221.359 | sngl_ringdown | 1 | 0.000 | 0.005 | 221.044 | sngl_ringdown | 10 | 0.000 | 0.002 | 5482.396 | sngl_ringdown | 100 | 0.000 | 0.009 | 10746.910 | sngl_ringdown | 1000 | 0.000 | 0.131 | 7654.038 | sngl_unmodeled | 1 | 0.000 | 0.005 | 201.732 | sngl_unmodeled | 10 | 0.000 | 0.002 | 5101.937 | sngl_unmodeled | 100 | 0.000 | 0.014 | 7244.802 | sngl_unmodeled | 1000 | 0.000 | 0.421 | 2372.547 | sngl_dperiodic | 1 | 0.000 | 0.005 | 209.203 | sngl_dperiodic | 10 | 0.000 | 0.002 | 4101.605 | sngl_dperiodic | 100 | 0.000 | 0.011 | 8773.392 | sngl_dperiodic | 1000 | 0.000 | 0.266 | 3762.072 | multi_inspiral | 1 | 0.000 | 0.005 | 185.458 | multi_inspiral | 10 | 0.000 | 0.002 | 4128.853 | multi_inspiral | 100 | 0.000 | 0.016 | 6123.699 | multi_inspiral | 1000 | 0.000 | 0.337 | 2970.418 | multi_burst | 1 | 0.000 | 0.005 | 215.612 | multi_burst | 10 | 0.000 | 0.002 | 4750.594 | multi_burst | 100 | 0.000 | 0.015 | 6686.280 | multi_burst | 1000 | 0.000 | 0.143 | 6999.909 | exttrig_search | 1 | 0.000 | 0.004 | 230.519 | exttrig_search | 10 | 0.000 | 0.002 | 4553.838 | exttrig_search | 100 | 0.000 | 0.009 | 11165.749 | exttrig_search | 1000 | 0.000 | 0.084 | 11902.211 | sim_inst_params | 1 | 0.000 | 0.010 | 97.570 | sim_inst_params | 10 | 0.000 | 0.001 | 8756.414 | sim_inst_params | 100 | 0.000 | 0.004 | 28168.617 | sim_inst_params | 1000 | 0.000 | 0.066 | 15126.076 | waveburst | 1 | 0.000 | 0.007 | 148.258 | waveburst | 10 | 0.000 | 0.004 | 2750.275 | waveburst | 100 | 0.000 | 0.024 | 4223.348 | waveburst | 1000 | 0.000 | 0.198 | 5044.136 | frameset_loc | 1 | 0.000 | 0.004 | 280.744 | frameset_loc | 10 | 0.000 | 0.001 | 6973.063 | frameset_loc | 100 | 0.000 | 0.016 | 6121.824 | frameset_loc | 1000 | 0.000 | 0.236 | 4243.654 | summ_value | 1 | 0.000 | 0.006 | 173.222 | summ_value | 10 | 0.000 | 0.002 | 4923.756 | summ_value | 100 | 0.000 | 0.010 | 10228.139 | summ_value | 1000 | 0.000 | 0.378 | 2644.146 | summ_statistics | 1 | 0.000 | 0.007 | 145.623 | summ_statistics | 10 | 0.000 | 0.003 | 3797.978 | summ_statistics | 100 | 0.000 | 0.020 | 5085.461 | summ_statistics | 1000 | 0.000 | 0.233 | 4300.040 | summ_spectrum | 1 | 0.000 | 0.015 | 68.241 | summ_spectrum | 10 | 0.000 | 0.028 | 361.768 | summ_spectrum | 100 | 0.000 | 0.346 | 289.137 | summ_spectrum | 1000 | 0.000 | 1.707 | 585.871 | summ_comment | 1 | 0.000 | 0.005 | 203.958 | summ_comment | 10 | 0.000 | 0.002 | 4955.475 | summ_comment | 100 | 0.000 | 0.010 | 10342.256 | summ_comment | 1000 | 0.000 | 0.143 | 6998.048 | summ_csd | 1 | 0.000 | 0.020 | 50.340 | summ_csd | 10 | 0.000 | 0.033 | 304.915 | summ_csd | 100 | 0.000 | 0.336 | 297.209 | summ_csd | 1000 | 0.000 | 1.890 | 529.151 | summ_mime | 1 | 0.000 | 0.020 | 50.551 | summ_mime | 10 | 0.000 | 0.023 | 442.519 | summ_mime | 100 | 0.000 | 0.329 | 303.805 | summ_mime | 1000 | 0.000 | 1.667 | 599.830 | sngl_unmodeled_v | 1 | 0.000 | 0.006 | 164.283 | sngl_unmodeled_v | 10 | 0.000 | 0.002 | 6481.175 | sngl_unmodeled_v | 100 | 0.000 | 0.007 | 13946.846 | sngl_unmodeled_v | 1000 | 0.000 | 0.119 | 8377.946 | coinc_sngl | 1 | 0.000 | 0.021 | 47.079 | coinc_sngl | 10 | 0.000 | 0.004 | 2284.169 | coinc_sngl | 100 | 0.000 | 0.040 | 2484.225 | coinc_sngl | 1000 | 0.000 | 0.293 | 3409.141 | search_summvars | 1 | 0.000 | 0.005 | 215.701 | search_summvars | 10 | 0.000 | 0.002 | 4564.230 | search_summvars | 100 | 0.000 | 0.007 | 13424.567 | search_summvars | 1000 | 0.000 | 0.122 | 8178.956 | waveburst_mime | 1 | 0.000 | 0.012 | 81.235 | waveburst_mime | 10 | 0.000 | 0.043 | 230.510 | waveburst_mime | 100 | 0.000 | 0.641 | 155.970 | waveburst_mime | 1000 | 0.000 | 2.985 | 335.026 | sngl_transdata | 1 | 0.000 | 0.005 | 189.714 | sngl_transdata | 10 | 0.000 | 0.029 | 342.465 | sngl_transdata | 100 | 0.000 | 0.322 | 310.424 | sngl_transdata | 1000 | 0.000 | 1.600 | 625.035 | sngl_mime | 1 | 0.000 | 0.019 | 52.386 | sngl_mime | 10 | 0.000 | 0.029 | 343.147 | sngl_mime | 100 | 0.000 | 0.337 | 296.730 | sngl_mime | 1000 | 0.000 | 1.580 | 632.843 | sngl_datasource | 1 | 0.000 | 0.004 | 265.463 | sngl_datasource | 10 | 0.000 | 0.002 | 6544.417 | sngl_datasource | 100 | 0.000 | 0.008 | 12168.514 | sngl_datasource | 1000 | 0.000 | 0.075 | 13335.627 |
|---|
Summary: