ldas-dev Database dev_1 Insertion Rates
| Test Period | January 14 2005 14:58:41 | |
|---|---|---|
| Input data | Ilwd with dimensions 1,10,100,1000 | |
| Platform | Linux metaserver 2.6.9-1.667smp #1 SMP Tue Nov 2 14:59:52 EST 2004 i686 i686 i386 GNU/Linux No memory info |
|
| LDAS software | ldas-1.4.0, 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.028 | 36.166 | process | 10 | 0.000 | 0.006 | 1712.939 | process | 100 | 0.000 | 0.014 | 7180.297 | process | 1000 | 0.000 | 0.204 | 4892.081 | runlist | 1 | 0.000 | 0.004 | 257.083 | runlist | 10 | 0.000 | 0.004 | 2449.228 | runlist | 100 | 0.000 | 0.007 | 14216.541 | runlist | 1000 | 0.000 | 0.084 | 11870.408 | calib_info | 1 | 0.000 | 0.029 | 34.072 | calib_info | 10 | 0.000 | 0.007 | 1530.711 | calib_info | 100 | 0.000 | 0.105 | 949.307 | calib_info | 1000 | 0.000 | 0.543 | 1841.519 | sim_type | 1 | 0.000 | 0.082 | 12.150 | sim_type | 10 | 0.000 | 0.065 | 154.564 | sim_type | 100 | 0.000 | 0.046 | 2195.534 | sim_type | 1000 | 0.000 | 0.639 | 1564.443 | process_params | 1 | 0.000 | 0.006 | 169.865 | process_params | 10 | 0.000 | 0.008 | 1216.834 | process_params | 100 | 0.000 | 0.009 | 10961.198 | process_params | 1000 | 0.000 | 0.190 | 5250.281 | frameset_chanlist | 1 | 0.000 | 0.007 | 152.348 | frameset_chanlist | 10 | 0.000 | 0.005 | 1979.473 | frameset_chanlist | 100 | 0.000 | 0.009 | 11510.169 | frameset_chanlist | 1000 | 0.000 | 0.086 | 11645.511 | frameset_writer | 1 | 0.000 | 0.007 | 149.253 | frameset_writer | 10 | 0.000 | 0.005 | 1827.823 | frameset_writer | 100 | 0.000 | 0.055 | 1816.464 | frameset_writer | 1000 | 0.000 | 0.290 | 3451.465 | segment_definer | 1 | 0.000 | 0.007 | 153.094 | segment_definer | 10 | 0.000 | 0.008 | 1275.679 | segment_definer | 100 | 0.000 | 0.023 | 4349.490 | segment_definer | 1000 | 0.000 | 0.305 | 3275.520 | filter | 1 | 0.000 | 0.007 | 147.210 | filter | 10 | 0.000 | 0.007 | 1342.823 | filter | 100 | 0.000 | 0.013 | 7512.640 | filter | 1000 | 0.000 | 0.140 | 7132.769 | search_summary | 1 | 0.000 | 0.008 | 130.737 | search_summary | 10 | 0.000 | 0.010 | 988.220 | search_summary | 100 | 0.000 | 0.022 | 4494.968 | search_summary | 1000 | 0.000 | 0.358 | 2791.347 | sim_inst | 1 | 0.000 | 0.008 | 132.979 | sim_inst | 10 | 0.000 | 0.007 | 1344.802 | sim_inst | 100 | 0.000 | 0.009 | 10897.971 | sim_inst | 1000 | 0.000 | 0.111 | 8983.999 | sim_type_params | 1 | 0.000 | 0.005 | 186.182 | sim_type_params | 10 | 0.000 | 0.004 | 2248.717 | sim_type_params | 100 | 0.000 | 0.006 | 17446.466 | sim_type_params | 1000 | 0.000 | 0.087 | 11547.878 | frameset | 1 | 0.000 | 0.009 | 110.095 | frameset | 10 | 0.000 | 0.009 | 1114.350 | frameset | 100 | 0.000 | 0.015 | 6456.153 | frameset | 1000 | 0.000 | 0.204 | 4912.725 | segment | 1 | 0.000 | 0.006 | 159.334 | segment | 10 | 0.000 | 0.007 | 1332.795 | segment | 100 | 0.000 | 0.021 | 4830.195 | segment | 1000 | 0.000 | 0.276 | 3621.811 | filter_params | 1 | 0.000 | 0.008 | 129.032 | filter_params | 10 | 0.000 | 0.009 | 1053.528 | filter_params | 100 | 0.000 | 0.018 | 5636.979 | filter_params | 1000 | 0.000 | 0.225 | 4448.280 | gds_trigger | 1 | 0.000 | 0.014 | 73.105 | gds_trigger | 10 | 0.000 | 0.013 | 759.532 | gds_trigger | 100 | 0.000 | 0.033 | 3062.787 | gds_trigger | 1000 | 0.000 | 0.510 | 1960.411 | sngl_inspiral | 1 | 0.000 | 0.012 | 82.555 | sngl_inspiral | 10 | 0.000 | 0.016 | 638.235 | sngl_inspiral | 100 | 0.000 | 0.041 | 2452.423 | sngl_inspiral | 1000 | 0.000 | 0.398 | 2515.552 | sngl_burst | 1 | 0.000 | 0.009 | 108.898 | sngl_burst | 10 | 0.000 | 0.014 | 711.187 | sngl_burst | 100 | 0.000 | 0.024 | 4148.878 | sngl_burst | 1000 | 0.000 | 0.297 | 3366.131 | sngl_block | 1 | 0.000 | 0.009 | 107.770 | sngl_block | 10 | 0.000 | 0.012 | 866.626 | sngl_block | 100 | 0.000 | 0.018 | 5595.032 | sngl_block | 1000 | 0.000 | 0.300 | 3337.561 | sngl_ringdown | 1 | 0.000 | 0.010 | 104.659 | sngl_ringdown | 10 | 0.000 | 0.011 | 886.517 | sngl_ringdown | 100 | 0.000 | 0.018 | 5697.714 | sngl_ringdown | 1000 | 0.000 | 0.251 | 3976.396 | sngl_unmodeled | 1 | 0.000 | 0.010 | 100.624 | sngl_unmodeled | 10 | 0.000 | 0.011 | 872.760 | sngl_unmodeled | 100 | 0.000 | 0.029 | 3420.324 | sngl_unmodeled | 1000 | 0.000 | 0.331 | 3017.256 | sngl_dperiodic | 1 | 0.000 | 0.010 | 97.106 | sngl_dperiodic | 10 | 0.000 | 0.012 | 858.664 | sngl_dperiodic | 100 | 0.000 | 0.035 | 2882.767 | sngl_dperiodic | 1000 | 0.000 | 0.407 | 2458.930 | multi_inspiral | 1 | 0.000 | 0.011 | 88.106 | multi_inspiral | 10 | 0.000 | 0.013 | 796.172 | multi_inspiral | 100 | 0.000 | 0.028 | 3522.379 | multi_inspiral | 1000 | 0.000 | 0.270 | 3700.209 | multi_burst | 1 | 0.000 | 0.009 | 106.452 | multi_burst | 10 | 0.000 | 0.011 | 879.345 | multi_burst | 100 | 0.000 | 0.021 | 4715.669 | multi_burst | 1000 | 0.000 | 0.236 | 4232.589 | exttrig_search | 1 | 0.000 | 0.009 | 105.242 | exttrig_search | 10 | 0.000 | 0.009 | 1132.004 | exttrig_search | 100 | 0.000 | 0.015 | 6523.625 | exttrig_search | 1000 | 0.000 | 0.200 | 4997.551 | sim_inst_params | 1 | 0.000 | 0.006 | 154.851 | sim_inst_params | 10 | 0.000 | 0.005 | 1976.300 | sim_inst_params | 100 | 0.000 | 0.008 | 12312.284 | sim_inst_params | 1000 | 0.000 | 0.052 | 19073.777 | waveburst | 1 | 0.000 | 0.015 | 66.484 | waveburst | 10 | 0.000 | 0.011 | 881.213 | waveburst | 100 | 0.000 | 0.026 | 3808.813 | waveburst | 1000 | 0.000 | 0.336 | 2972.996 | frameset_loc | 1 | 0.000 | 0.006 | 154.989 | frameset_loc | 10 | 0.000 | 0.008 | 1196.151 | frameset_loc | 100 | 0.000 | 0.028 | 3513.321 | frameset_loc | 1000 | 0.000 | 0.304 | 3284.558 | summ_value | 1 | 0.000 | 0.013 | 77.658 | summ_value | 10 | 0.000 | 0.017 | 577.434 | summ_value | 100 | 0.000 | 0.024 | 4083.483 | summ_value | 1000 | 0.000 | 0.348 | 2876.489 | summ_statistics | 1 | 0.000 | 0.014 | 70.953 | summ_statistics | 10 | 0.000 | 0.017 | 604.741 | summ_statistics | 100 | 0.000 | 0.034 | 2975.234 | summ_statistics | 1000 | 0.000 | 0.312 | 3207.452 | summ_spectrum | 1 | 0.000 | 0.046 | 21.645 | summ_spectrum | 10 | 0.000 | 0.020 | 492.948 | summ_spectrum | 100 | 0.000 | 0.152 | 657.151 | summ_spectrum | 1000 | 0.000 | 1.309 | 763.714 | summ_comment | 1 | 0.000 | 0.013 | 79.974 | summ_comment | 10 | 0.000 | 0.014 | 710.480 | summ_comment | 100 | 0.000 | 0.018 | 5408.300 | summ_comment | 1000 | 0.000 | 0.178 | 5632.914 | summ_csd | 1 | 0.000 | 0.046 | 21.556 | summ_csd | 10 | 0.000 | 0.020 | 503.071 | summ_csd | 100 | 0.000 | 0.136 | 735.413 | summ_csd | 1000 | 0.000 | 1.160 | 861.950 | summ_mime | 1 | 0.000 | 0.089 | 11.191 | summ_mime | 10 | 0.000 | 0.017 | 596.410 | summ_mime | 100 | 0.000 | 0.093 | 1072.341 | summ_mime | 1000 | 0.000 | 0.772 | 1296.091 | sngl_unmodeled_v | 1 | 0.000 | 0.009 | 112.270 | sngl_unmodeled_v | 10 | 0.000 | 0.010 | 1046.901 | sngl_unmodeled_v | 100 | 0.000 | 0.015 | 6473.791 | sngl_unmodeled_v | 1000 | 0.000 | 0.204 | 4897.160 | coinc_sngl | 1 | 0.000 | 0.089 | 11.256 | coinc_sngl | 10 | 0.000 | 0.093 | 107.150 | coinc_sngl | 100 | 0.000 | 0.050 | 1989.218 | coinc_sngl | 1000 | 0.000 | 0.558 | 1793.362 | search_summvars | 1 | 0.000 | 0.006 | 156.393 | search_summvars | 10 | 0.000 | 0.007 | 1374.911 | search_summvars | 100 | 0.000 | 0.010 | 10295.300 | search_summvars | 1000 | 0.000 | 0.496 | 2016.662 | waveburst_mime | 1 | 0.000 | 0.043 | 23.070 | waveburst_mime | 10 | 0.000 | 0.007 | 1473.650 | waveburst_mime | 100 | 0.000 | 0.103 | 971.978 | waveburst_mime | 1000 | 0.000 | 0.491 | 2036.262 | sngl_transdata | 1 | 0.000 | 0.038 | 26.177 | sngl_transdata | 10 | 0.000 | 0.017 | 584.686 | sngl_transdata | 100 | 0.000 | 0.111 | 901.469 | sngl_transdata | 1000 | 0.000 | 0.858 | 1164.966 | sngl_mime | 1 | 0.000 | 0.140 | 7.153 | sngl_mime | 10 | 0.000 | 0.009 | 1062.925 | sngl_mime | 100 | 0.000 | 0.122 | 822.727 | sngl_mime | 1000 | 0.000 | 0.887 | 1127.589 | sngl_datasource | 1 | 0.000 | 0.006 | 170.071 | sngl_datasource | 10 | 0.000 | 0.003 | 3212.304 | sngl_datasource | 100 | 0.000 | 0.044 | 2278.065 | sngl_datasource | 1000 | 0.000 | 0.307 | 3254.054 |
|---|
Summary: