ldas-dev Database dev_1 Insertion Rates
| Test Period | November 12 2004 17:12:02 | |
|---|---|---|
| Input data | Ilwd with dimensions 1,10,100,1000 | |
| Platform | Linux metaserver 2.4.20-31.9smp #1 SMP Tue Apr 13 17:40:10 EDT 2004 i686 i686 i386 GNU/Linux No memory info |
|
| LDAS software | ldas-1.3.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.005 | 182.116 | process | 10 | 0.000 | 0.005 | 2050.903 | process | 100 | 0.000 | 0.028 | 3578.086 | process | 1000 | 0.000 | 0.412 | 2425.424 | runlist | 1 | 0.000 | 0.002 | 433.475 | runlist | 10 | 0.000 | 0.004 | 2414.823 | runlist | 100 | 0.000 | 0.015 | 6578.082 | runlist | 1000 | 0.000 | 0.180 | 5568.735 | calib_info | 1 | 0.000 | 0.012 | 82.562 | calib_info | 10 | 0.000 | 0.006 | 1543.670 | calib_info | 100 | 0.000 | 0.069 | 1445.879 | calib_info | 1000 | 0.000 | 0.341 | 2929.613 | sim_type | 1 | 0.000 | 0.093 | 10.766 | sim_type | 10 | 0.000 | 0.006 | 1751.347 | sim_type | 100 | 0.000 | 0.026 | 3825.701 | sim_type | 1000 | 0.000 | 0.254 | 3930.092 | process_params | 1 | 0.000 | 0.004 | 222.959 | process_params | 10 | 0.000 | 0.005 | 2027.900 | process_params | 100 | 0.000 | 0.022 | 4446.796 | process_params | 1000 | 0.000 | 0.238 | 4205.568 | frameset_chanlist | 1 | 0.000 | 0.008 | 120.845 | frameset_chanlist | 10 | 0.000 | 0.008 | 1304.118 | frameset_chanlist | 100 | 0.000 | 0.005 | 20894.231 | frameset_chanlist | 1000 | 0.000 | 0.164 | 6082.947 | frameset_writer | 1 | 0.000 | 0.006 | 157.675 | frameset_writer | 10 | 0.000 | 0.005 | 2061.082 | frameset_writer | 100 | 0.000 | 0.026 | 3831.711 | frameset_writer | 1000 | 0.000 | 0.355 | 2815.149 | segment_definer | 1 | 0.000 | 0.005 | 221.090 | segment_definer | 10 | 0.000 | 0.019 | 518.320 | segment_definer | 100 | 0.000 | 0.030 | 3385.229 | segment_definer | 1000 | 0.000 | 0.441 | 2269.092 | filter | 1 | 0.000 | 0.005 | 219.539 | filter | 10 | 0.000 | 0.005 | 1886.775 | filter | 100 | 0.000 | 0.025 | 4073.834 | filter | 1000 | 0.000 | 0.268 | 3736.390 | search_summary | 1 | 0.000 | 0.006 | 172.293 | search_summary | 10 | 0.000 | 0.008 | 1207.272 | search_summary | 100 | 0.000 | 0.027 | 3726.046 | search_summary | 1000 | 0.000 | 0.548 | 1825.597 | sim_inst | 1 | 0.000 | 0.005 | 184.836 | sim_inst | 10 | 0.000 | 0.009 | 1085.286 | sim_inst | 100 | 0.000 | 0.011 | 9222.540 | sim_inst | 1000 | 0.000 | 0.125 | 7972.320 | sim_type_params | 1 | 0.000 | 0.004 | 276.232 | sim_type_params | 10 | 0.000 | 0.004 | 2508.252 | sim_type_params | 100 | 0.000 | 0.004 | 25407.731 | sim_type_params | 1000 | 0.000 | 0.124 | 8053.929 | frameset | 1 | 0.000 | 0.006 | 178.163 | frameset | 10 | 0.000 | 0.010 | 1026.280 | frameset | 100 | 0.000 | 0.024 | 4086.987 | frameset | 1000 | 0.000 | 0.266 | 3752.697 | segment | 1 | 0.000 | 0.005 | 218.340 | segment | 10 | 0.000 | 0.005 | 1921.964 | segment | 100 | 0.000 | 0.021 | 4783.110 | segment | 1000 | 0.000 | 0.325 | 3080.867 | filter_params | 1 | 0.000 | 0.006 | 176.773 | filter_params | 10 | 0.000 | 0.006 | 1583.772 | filter_params | 100 | 0.000 | 0.018 | 5452.325 | filter_params | 1000 | 0.000 | 0.317 | 3158.181 | gds_trigger | 1 | 0.000 | 0.009 | 111.137 | gds_trigger | 10 | 0.000 | 0.013 | 743.434 | gds_trigger | 100 | 0.000 | 0.044 | 2280.392 | gds_trigger | 1000 | 0.000 | 0.486 | 2055.587 | sngl_inspiral | 1 | 0.000 | 0.008 | 123.533 | sngl_inspiral | 10 | 0.000 | 0.013 | 779.800 | sngl_inspiral | 100 | 0.000 | 0.050 | 1988.783 | sngl_inspiral | 1000 | 0.000 | 0.552 | 1810.495 | sngl_burst | 1 | 0.000 | 0.008 | 119.861 | sngl_burst | 10 | 0.000 | 0.009 | 1091.953 | sngl_burst | 100 | 0.000 | 0.040 | 2472.500 | sngl_burst | 1000 | 0.000 | 0.512 | 1954.992 | sngl_block | 1 | 0.000 | 0.006 | 158.031 | sngl_block | 10 | 0.000 | 0.010 | 1028.797 | sngl_block | 100 | 0.000 | 0.020 | 4925.380 | sngl_block | 1000 | 0.000 | 0.354 | 2827.870 | sngl_ringdown | 1 | 0.000 | 0.006 | 158.581 | sngl_ringdown | 10 | 0.000 | 0.012 | 842.247 | sngl_ringdown | 100 | 0.000 | 0.025 | 4074.000 | sngl_ringdown | 1000 | 0.000 | 0.333 | 3007.356 | sngl_unmodeled | 1 | 0.000 | 0.006 | 169.433 | sngl_unmodeled | 10 | 0.000 | 0.007 | 1339.563 | sngl_unmodeled | 100 | 0.000 | 0.050 | 2008.996 | sngl_unmodeled | 1000 | 0.000 | 0.530 | 1887.854 | sngl_dperiodic | 1 | 0.000 | 0.006 | 153.773 | sngl_dperiodic | 10 | 0.000 | 0.012 | 802.246 | sngl_dperiodic | 100 | 0.000 | 0.048 | 2093.320 | sngl_dperiodic | 1000 | 0.000 | 0.492 | 2030.972 | multi_inspiral | 1 | 0.000 | 0.007 | 141.882 | multi_inspiral | 10 | 0.000 | 0.008 | 1181.328 | multi_inspiral | 100 | 0.000 | 0.045 | 2210.726 | multi_inspiral | 1000 | 0.000 | 2.323 | 430.465 | multi_burst | 1 | 0.000 | 0.007 | 152.999 | multi_burst | 10 | 0.000 | 0.008 | 1255.666 | multi_burst | 100 | 0.000 | 0.022 | 4619.172 | multi_burst | 1000 | 0.000 | 0.331 | 3019.661 | exttrig_search | 1 | 0.000 | 0.006 | 163.451 | exttrig_search | 10 | 0.000 | 0.009 | 1119.317 | exttrig_search | 100 | 0.000 | 0.026 | 3814.043 | exttrig_search | 1000 | 0.000 | 0.330 | 3030.983 | sim_inst_params | 1 | 0.000 | 0.004 | 226.903 | sim_inst_params | 10 | 0.000 | 0.004 | 2264.985 | sim_inst_params | 100 | 0.000 | 0.006 | 16960.392 | sim_inst_params | 1000 | 0.000 | 0.084 | 11853.973 | waveburst | 1 | 0.000 | 0.009 | 106.056 | waveburst | 10 | 0.000 | 0.011 | 932.479 | waveburst | 100 | 0.000 | 0.028 | 3575.886 | waveburst | 1000 | 0.000 | 0.444 | 2253.298 | frameset_loc | 1 | 0.000 | 0.004 | 248.331 | frameset_loc | 10 | 0.000 | 0.005 | 2084.228 | frameset_loc | 100 | 0.000 | 0.023 | 4307.541 | frameset_loc | 1000 | 0.000 | 0.332 | 3015.709 | summ_value | 1 | 0.000 | 0.008 | 121.549 | summ_value | 10 | 0.000 | 0.009 | 1087.311 | summ_value | 100 | 0.000 | 0.039 | 2560.813 | summ_value | 1000 | 0.000 | 0.431 | 2320.401 | summ_statistics | 1 | 0.000 | 0.009 | 114.837 | summ_statistics | 10 | 0.000 | 0.018 | 569.019 | summ_statistics | 100 | 0.000 | 0.038 | 2642.783 | summ_statistics | 1000 | 0.000 | 0.527 | 1897.209 | summ_spectrum | 1 | 0.000 | 0.033 | 30.082 | summ_spectrum | 10 | 0.000 | 0.025 | 403.652 | summ_spectrum | 100 | 0.000 | 0.156 | 640.964 | summ_spectrum | 1000 | 0.000 | 1.252 | 798.856 | summ_comment | 1 | 0.000 | 0.008 | 127.910 | summ_comment | 10 | 0.000 | 0.048 | 208.351 | summ_comment | 100 | 0.000 | 0.028 | 3627.947 | summ_comment | 1000 | 0.000 | 0.375 | 2665.757 | summ_csd | 1 | 0.000 | 0.037 | 27.327 | summ_csd | 10 | 0.000 | 0.031 | 322.341 | summ_csd | 100 | 0.000 | 0.146 | 687.139 | summ_csd | 1000 | 0.000 | 1.601 | 624.614 | summ_mime | 1 | 0.000 | 0.030 | 32.811 | summ_mime | 10 | 0.000 | 0.046 | 216.225 | summ_mime | 100 | 0.000 | 0.123 | 811.767 | summ_mime | 1000 | 0.000 | 0.940 | 1064.104 | sngl_unmodeled_v | 1 | 0.000 | 0.008 | 131.735 | sngl_unmodeled_v | 10 | 0.000 | 0.011 | 940.115 | sngl_unmodeled_v | 100 | 0.000 | 0.025 | 4037.794 | sngl_unmodeled_v | 1000 | 0.000 | 0.272 | 3670.398 | coinc_sngl | 1 | 0.000 | 0.056 | 17.877 | coinc_sngl | 10 | 0.000 | 0.065 | 152.707 | coinc_sngl | 100 | 0.000 | 0.063 | 1587.478 | coinc_sngl | 1000 | 0.000 | 0.531 | 1883.683 | search_summvars | 1 | 0.000 | 0.004 | 235.120 | search_summvars | 10 | 0.000 | 0.007 | 1341.920 | search_summvars | 100 | 0.000 | 0.005 | 18304.559 | search_summvars | 1000 | 0.000 | 0.212 | 4710.759 | waveburst_mime | 1 | 0.000 | 0.038 | 26.449 | waveburst_mime | 10 | 0.000 | 0.029 | 348.540 | waveburst_mime | 100 | 0.000 | 0.075 | 1328.109 | waveburst_mime | 1000 | 0.000 | 0.392 | 2552.889 | sngl_transdata | 1 | 0.000 | 0.028 | 36.181 | sngl_transdata | 10 | 0.000 | 0.023 | 440.180 | sngl_transdata | 100 | 0.000 | 0.122 | 816.687 | sngl_transdata | 1000 | 0.000 | 0.710 | 1408.112 | sngl_mime | 1 | 0.000 | 0.024 | 41.729 | sngl_mime | 10 | 0.000 | 0.030 | 328.126 | sngl_mime | 100 | 0.000 | 0.104 | 958.368 | sngl_mime | 1000 | 0.000 | 0.765 | 1306.904 | sngl_datasource | 1 | 0.000 | 0.005 | 219.299 | sngl_datasource | 10 | 0.000 | 0.006 | 1554.021 | sngl_datasource | 100 | 0.000 | 0.038 | 2631.634 | sngl_datasource | 1000 | 0.000 | 0.299 | 3342.693 |
|---|
Summary: