ldas-dev Database dev_1 Insertion Rates
| Test Period | February 15 2005 12:54:26 | |
|---|---|---|
| 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.5.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.034 | 29.462 | process | 10 | 0.000 | 0.004 | 2478.905 | process | 100 | 0.000 | 0.011 | 8904.006 | process | 1000 | 0.000 | 0.173 | 5786.803 | runlist | 1 | 0.000 | 0.003 | 336.379 | runlist | 10 | 0.000 | 0.003 | 2996.784 | runlist | 100 | 0.000 | 0.005 | 21724.254 | runlist | 1000 | 0.000 | 0.069 | 14554.558 | calib_info | 1 | 0.000 | 0.015 | 65.942 | calib_info | 10 | 0.000 | 0.005 | 2006.747 | calib_info | 100 | 0.000 | 0.022 | 4490.547 | calib_info | 1000 | 0.000 | 0.132 | 7574.610 | sim_type | 1 | 0.000 | 0.004 | 252.153 | sim_type | 10 | 0.000 | 0.006 | 1552.525 | sim_type | 100 | 0.000 | 0.031 | 3229.348 | sim_type | 1000 | 0.000 | 0.341 | 2936.288 | process_params | 1 | 0.000 | 0.005 | 191.784 | process_params | 10 | 0.000 | 0.006 | 1736.413 | process_params | 100 | 0.000 | 0.009 | 11263.811 | process_params | 1000 | 0.000 | 0.114 | 8774.085 | frameset_chanlist | 1 | 0.000 | 0.005 | 199.843 | frameset_chanlist | 10 | 0.000 | 0.005 | 1828.859 | frameset_chanlist | 100 | 0.000 | 0.006 | 18011.365 | frameset_chanlist | 1000 | 0.000 | 0.070 | 14219.512 | frameset_writer | 1 | 0.000 | 0.005 | 191.093 | frameset_writer | 10 | 0.000 | 0.006 | 1718.272 | frameset_writer | 100 | 0.000 | 0.027 | 3728.839 | frameset_writer | 1000 | 0.000 | 0.226 | 4421.766 | segment_definer | 1 | 0.000 | 0.005 | 202.918 | segment_definer | 10 | 0.000 | 0.006 | 1766.098 | segment_definer | 100 | 0.000 | 0.018 | 5529.444 | segment_definer | 1000 | 0.000 | 0.266 | 3758.551 | filter | 1 | 0.000 | 0.005 | 202.018 | filter | 10 | 0.000 | 0.006 | 1756.849 | filter | 100 | 0.000 | 0.015 | 6612.794 | filter | 1000 | 0.000 | 0.102 | 9839.614 | search_summary | 1 | 0.000 | 0.006 | 168.520 | search_summary | 10 | 0.000 | 0.007 | 1492.794 | search_summary | 100 | 0.000 | 0.019 | 5248.793 | search_summary | 1000 | 0.000 | 0.281 | 3558.491 | sim_inst | 1 | 0.000 | 0.006 | 170.854 | sim_inst | 10 | 0.000 | 0.007 | 1446.362 | sim_inst | 100 | 0.000 | 0.007 | 14361.605 | sim_inst | 1000 | 0.000 | 0.077 | 13013.022 | sim_type_params | 1 | 0.000 | 0.004 | 232.668 | sim_type_params | 10 | 0.000 | 0.004 | 2300.014 | sim_type_params | 100 | 0.000 | 0.004 | 25458.573 | sim_type_params | 1000 | 0.000 | 0.054 | 18370.534 | frameset | 1 | 0.000 | 0.008 | 125.454 | frameset | 10 | 0.000 | 0.007 | 1400.343 | frameset | 100 | 0.000 | 0.013 | 7783.252 | frameset | 1000 | 0.000 | 0.114 | 8751.356 | segment | 1 | 0.000 | 0.006 | 175.656 | segment | 10 | 0.000 | 0.007 | 1533.006 | segment | 100 | 0.000 | 0.018 | 5525.503 | segment | 1000 | 0.000 | 0.163 | 6123.286 | filter_params | 1 | 0.000 | 0.007 | 148.020 | filter_params | 10 | 0.000 | 0.008 | 1179.799 | filter_params | 100 | 0.000 | 0.012 | 8490.478 | filter_params | 1000 | 0.000 | 0.117 | 8561.790 | gds_trigger | 1 | 0.000 | 0.010 | 103.994 | gds_trigger | 10 | 0.000 | 0.011 | 882.940 | gds_trigger | 100 | 0.000 | 0.033 | 3045.531 | gds_trigger | 1000 | 0.000 | 0.310 | 3222.875 | sngl_inspiral | 1 | 0.000 | 0.009 | 110.012 | sngl_inspiral | 10 | 0.000 | 0.010 | 1042.866 | sngl_inspiral | 100 | 0.000 | 0.026 | 3813.170 | sngl_inspiral | 1000 | 0.000 | 0.363 | 2757.533 | sngl_burst | 1 | 0.000 | 0.009 | 105.252 | sngl_burst | 10 | 0.000 | 0.010 | 997.815 | sngl_burst | 100 | 0.000 | 0.049 | 2047.590 | sngl_burst | 1000 | 0.000 | 0.272 | 3677.579 | sngl_block | 1 | 0.000 | 0.007 | 137.042 | sngl_block | 10 | 0.000 | 0.008 | 1301.729 | sngl_block | 100 | 0.000 | 0.013 | 7813.660 | sngl_block | 1000 | 0.000 | 0.147 | 6779.983 | sngl_ringdown | 1 | 0.000 | 0.007 | 137.024 | sngl_ringdown | 10 | 0.000 | 0.008 | 1319.420 | sngl_ringdown | 100 | 0.000 | 0.013 | 7725.468 | sngl_ringdown | 1000 | 0.000 | 0.146 | 6828.083 | sngl_unmodeled | 1 | 0.000 | 0.007 | 146.286 | sngl_unmodeled | 10 | 0.000 | 0.010 | 955.374 | sngl_unmodeled | 100 | 0.000 | 0.025 | 4043.328 | sngl_unmodeled | 1000 | 0.000 | 0.258 | 3881.988 | sngl_dperiodic | 1 | 0.000 | 0.008 | 131.285 | sngl_dperiodic | 10 | 0.000 | 0.008 | 1242.242 | sngl_dperiodic | 100 | 0.000 | 0.017 | 5940.359 | sngl_dperiodic | 1000 | 0.000 | 0.188 | 5310.646 | multi_inspiral | 1 | 0.000 | 0.008 | 117.950 | multi_inspiral | 10 | 0.000 | 0.009 | 1118.064 | multi_inspiral | 100 | 0.000 | 0.027 | 3742.515 | multi_inspiral | 1000 | 0.000 | 0.213 | 4705.107 | multi_burst | 1 | 0.000 | 0.007 | 141.080 | multi_burst | 10 | 0.000 | 0.012 | 864.536 | multi_burst | 100 | 0.000 | 0.013 | 7991.561 | multi_burst | 1000 | 0.000 | 0.139 | 7199.994 | exttrig_search | 1 | 0.000 | 0.006 | 166.579 | exttrig_search | 10 | 0.000 | 0.007 | 1487.183 | exttrig_search | 100 | 0.000 | 0.011 | 8863.520 | exttrig_search | 1000 | 0.000 | 0.122 | 8185.249 | sim_inst_params | 1 | 0.000 | 0.005 | 211.236 | sim_inst_params | 10 | 0.000 | 0.005 | 2082.058 | sim_inst_params | 100 | 0.000 | 0.004 | 22774.115 | sim_inst_params | 1000 | 0.000 | 0.048 | 20779.609 | waveburst | 1 | 0.000 | 0.011 | 94.216 | waveburst | 10 | 0.000 | 0.011 | 893.264 | waveburst | 100 | 0.000 | 0.023 | 4358.438 | waveburst | 1000 | 0.000 | 0.315 | 3175.863 | frameset_loc | 1 | 0.000 | 0.005 | 209.025 | frameset_loc | 10 | 0.000 | 0.005 | 1839.930 | frameset_loc | 100 | 0.000 | 0.020 | 5068.963 | frameset_loc | 1000 | 0.000 | 0.124 | 8079.437 | summ_value | 1 | 0.000 | 0.009 | 109.002 | summ_value | 10 | 0.000 | 0.010 | 1010.700 | summ_value | 100 | 0.000 | 0.018 | 5405.113 | summ_value | 1000 | 0.000 | 0.176 | 5695.669 | summ_statistics | 1 | 0.000 | 0.010 | 102.585 | summ_statistics | 10 | 0.000 | 0.011 | 894.134 | summ_statistics | 100 | 0.000 | 0.020 | 5092.142 | summ_statistics | 1000 | 0.000 | 0.185 | 5412.661 | summ_spectrum | 1 | 0.000 | 0.020 | 50.502 | summ_spectrum | 10 | 0.000 | 0.013 | 784.012 | summ_spectrum | 100 | 0.000 | 0.061 | 1650.813 | summ_spectrum | 1000 | 0.000 | 0.506 | 1976.039 | summ_comment | 1 | 0.000 | 0.009 | 112.171 | summ_comment | 10 | 0.000 | 0.010 | 1006.649 | summ_comment | 100 | 0.000 | 0.017 | 5951.991 | summ_comment | 1000 | 0.000 | 0.153 | 6542.362 | summ_csd | 1 | 0.000 | 0.019 | 51.934 | summ_csd | 10 | 0.000 | 0.013 | 769.527 | summ_csd | 100 | 0.000 | 0.056 | 1791.916 | summ_csd | 1000 | 0.000 | 0.506 | 1976.171 | summ_mime | 1 | 0.000 | 0.020 | 51.115 | summ_mime | 10 | 0.000 | 0.013 | 771.849 | summ_mime | 100 | 0.000 | 0.040 | 2519.844 | summ_mime | 1000 | 0.000 | 0.470 | 2129.386 | sngl_unmodeled_v | 1 | 0.000 | 0.010 | 105.041 | sngl_unmodeled_v | 10 | 0.000 | 0.007 | 1362.804 | sngl_unmodeled_v | 100 | 0.000 | 0.012 | 8407.600 | sngl_unmodeled_v | 1000 | 0.000 | 0.127 | 7880.159 | coinc_sngl | 1 | 0.000 | 0.059 | 17.061 | coinc_sngl | 10 | 0.000 | 0.067 | 148.335 | coinc_sngl | 100 | 0.000 | 0.033 | 3026.167 | coinc_sngl | 1000 | 0.000 | 0.472 | 2116.438 | search_summvars | 1 | 0.000 | 0.005 | 204.840 | search_summvars | 10 | 0.000 | 0.006 | 1661.637 | search_summvars | 100 | 0.000 | 0.007 | 14593.960 | search_summvars | 1000 | 0.000 | 0.134 | 7473.562 | waveburst_mime | 1 | 0.000 | 0.023 | 43.611 | waveburst_mime | 10 | 0.000 | 0.007 | 1348.434 | waveburst_mime | 100 | 0.000 | 0.025 | 3982.319 | waveburst_mime | 1000 | 0.000 | 0.178 | 5605.255 | sngl_transdata | 1 | 0.000 | 0.018 | 56.944 | sngl_transdata | 10 | 0.000 | 0.014 | 693.914 | sngl_transdata | 100 | 0.000 | 0.047 | 2125.001 | sngl_transdata | 1000 | 0.000 | 0.345 | 2897.434 | sngl_mime | 1 | 0.000 | 0.016 | 62.069 | sngl_mime | 10 | 0.000 | 0.012 | 843.313 | sngl_mime | 100 | 0.000 | 0.040 | 2515.654 | sngl_mime | 1000 | 0.000 | 0.318 | 3147.287 | sngl_datasource | 1 | 0.000 | 0.005 | 188.677 | sngl_datasource | 10 | 0.000 | 0.007 | 1424.501 | sngl_datasource | 100 | 0.000 | 0.024 | 4234.399 | sngl_datasource | 1000 | 0.000 | 0.191 | 5237.165 |
|---|
Summary: