ldas-dev Database dev_1 Insertion Rates
| Test Period | October 31 2005 15:14:18 | |
|---|---|---|
| Input data | Ilwd with dimensions 1,10,100,1000 | |
| Platform | Linux metaserver 2.6.12-1.1447_FC4smp #1 SMP Fri Aug 26 20:57:13 EDT 2005 i686 i686 i386 GNU/Linux No memory info |
|
| LDAS software | ldas-1.8.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 | 195.311 | process | 10 | 0.000 | 0.001 | 6939.625 | process | 100 | 0.000 | 0.008 | 12853.338 | process | 1000 | 0.000 | 0.078 | 12785.762 | runlist | 1 | 0.000 | 0.004 | 265.613 | runlist | 10 | 0.000 | 0.001 | 8258.116 | runlist | 100 | 0.000 | 0.005 | 18388.809 | runlist | 1000 | 0.000 | 0.045 | 22350.414 | calib_info | 1 | 0.000 | 0.021 | 48.737 | calib_info | 10 | 0.000 | 0.003 | 3703.909 | calib_info | 100 | 0.000 | 0.043 | 2309.207 | calib_info | 1000 | 0.000 | 0.159 | 6270.536 | sim_type | 1 | 0.000 | 0.051 | 19.490 | sim_type | 10 | 0.000 | 0.004 | 2319.088 | sim_type | 100 | 0.000 | 0.035 | 2865.412 | sim_type | 1000 | 0.000 | 0.342 | 2921.312 | process_params | 1 | 0.000 | 0.004 | 232.616 | process_params | 10 | 0.000 | 0.001 | 7341.659 | process_params | 100 | 0.000 | 0.007 | 13917.923 | process_params | 1000 | 0.000 | 0.076 | 13156.873 | frameset_chanlist | 1 | 0.000 | 0.004 | 245.410 | frameset_chanlist | 10 | 0.000 | 0.002 | 6671.381 | frameset_chanlist | 100 | 0.000 | 0.006 | 16331.677 | frameset_chanlist | 1000 | 0.000 | 0.060 | 16650.876 | frameset_writer | 1 | 0.000 | 0.004 | 236.405 | frameset_writer | 10 | 0.000 | 0.001 | 6803.415 | frameset_writer | 100 | 0.000 | 0.011 | 9133.338 | frameset_writer | 1000 | 0.000 | 0.177 | 5658.573 | segment_definer | 1 | 0.000 | 0.004 | 252.791 | segment_definer | 10 | 0.000 | 0.001 | 6848.940 | segment_definer | 100 | 0.000 | 0.011 | 9215.825 | segment_definer | 1000 | 0.000 | 0.100 | 10001.010 | filter | 1 | 0.000 | 0.004 | 226.805 | filter | 10 | 0.000 | 0.002 | 6325.311 | filter | 100 | 0.000 | 0.009 | 11749.404 | filter | 1000 | 0.000 | 0.075 | 13270.343 | search_summary | 1 | 0.000 | 0.006 | 159.261 | search_summary | 10 | 0.000 | 0.002 | 4695.299 | search_summary | 100 | 0.000 | 0.013 | 7718.372 | search_summary | 1000 | 0.000 | 0.130 | 7683.501 | sim_inst | 1 | 0.000 | 0.004 | 235.172 | sim_inst | 10 | 0.000 | 0.001 | 8305.579 | sim_inst | 100 | 0.000 | 0.008 | 12978.636 | sim_inst | 1000 | 0.000 | 0.070 | 14194.061 | sim_type_params | 1 | 0.000 | 0.003 | 306.377 | sim_type_params | 10 | 0.000 | 0.001 | 12076.886 | sim_type_params | 100 | 0.000 | 0.005 | 19538.386 | sim_type_params | 1000 | 0.000 | 0.045 | 22079.491 | frameset | 1 | 0.000 | 0.005 | 194.622 | frameset | 10 | 0.000 | 0.001 | 7424.842 | frameset | 100 | 0.000 | 0.010 | 10360.654 | frameset | 1000 | 0.000 | 0.093 | 10754.874 | segment | 1 | 0.000 | 0.005 | 213.310 | segment | 10 | 0.000 | 0.002 | 4460.124 | segment | 100 | 0.000 | 0.010 | 9604.303 | segment | 1000 | 0.000 | 0.108 | 9226.114 | filter_params | 1 | 0.000 | 0.005 | 181.690 | filter_params | 10 | 0.000 | 0.002 | 5951.885 | filter_params | 100 | 0.000 | 0.011 | 9469.697 | filter_params | 1000 | 0.000 | 0.099 | 10070.504 | gds_trigger | 1 | 0.000 | 0.007 | 147.864 | gds_trigger | 10 | 0.000 | 0.003 | 3117.285 | gds_trigger | 100 | 0.000 | 0.022 | 4541.099 | gds_trigger | 1000 | 0.000 | 0.165 | 6061.929 | sngl_inspiral | 1 | 0.000 | 0.007 | 148.961 | sngl_inspiral | 10 | 0.000 | 0.003 | 3281.927 | sngl_inspiral | 100 | 0.000 | 0.023 | 4273.888 | sngl_inspiral | 1000 | 0.000 | 0.198 | 5055.228 | sngl_burst | 1 | 0.000 | 0.008 | 119.431 | sngl_burst | 10 | 0.000 | 0.003 | 3247.618 | sngl_burst | 100 | 0.000 | 0.020 | 4896.920 | sngl_burst | 1000 | 0.000 | 0.122 | 8199.813 | sngl_block | 1 | 0.000 | 0.007 | 146.562 | sngl_block | 10 | 0.000 | 0.002 | 5123.135 | sngl_block | 100 | 0.000 | 0.018 | 5708.707 | sngl_block | 1000 | 0.000 | 0.135 | 7411.909 | sngl_ringdown | 1 | 0.000 | 0.006 | 169.837 | sngl_ringdown | 10 | 0.000 | 0.002 | 5271.203 | sngl_ringdown | 100 | 0.000 | 0.016 | 6248.867 | sngl_ringdown | 1000 | 0.000 | 0.122 | 8217.197 | sngl_unmodeled | 1 | 0.000 | 0.006 | 177.747 | sngl_unmodeled | 10 | 0.000 | 0.002 | 4217.932 | sngl_unmodeled | 100 | 0.000 | 0.017 | 5781.349 | sngl_unmodeled | 1000 | 0.000 | 0.162 | 6158.508 | sngl_dperiodic | 1 | 0.000 | 0.007 | 151.419 | sngl_dperiodic | 10 | 0.000 | 0.002 | 4273.358 | sngl_dperiodic | 100 | 0.000 | 0.020 | 4899.535 | sngl_dperiodic | 1000 | 0.000 | 0.133 | 7515.971 | multi_inspiral | 1 | 0.000 | 0.007 | 137.532 | multi_inspiral | 10 | 0.000 | 0.003 | 3412.783 | multi_inspiral | 100 | 0.000 | 0.022 | 4477.498 | multi_inspiral | 1000 | 0.000 | 0.152 | 6572.850 | multi_burst | 1 | 0.000 | 0.006 | 168.095 | multi_burst | 10 | 0.000 | 0.002 | 4597.511 | multi_burst | 100 | 0.000 | 0.023 | 4378.284 | multi_burst | 1000 | 0.000 | 0.112 | 8959.289 | exttrig_search | 1 | 0.000 | 0.005 | 193.688 | exttrig_search | 10 | 0.000 | 0.002 | 5055.203 | exttrig_search | 100 | 0.000 | 0.013 | 7418.288 | exttrig_search | 1000 | 0.000 | 0.092 | 10897.270 | sim_inst_params | 1 | 0.000 | 0.004 | 266.593 | sim_inst_params | 10 | 0.000 | 0.001 | 8312.137 | sim_inst_params | 100 | 0.000 | 0.009 | 11367.602 | sim_inst_params | 1000 | 0.000 | 0.043 | 23062.252 | waveburst | 1 | 0.000 | 0.007 | 144.095 | waveburst | 10 | 0.000 | 0.002 | 4137.206 | waveburst | 100 | 0.000 | 0.023 | 4273.541 | waveburst | 1000 | 0.000 | 0.174 | 5737.103 | frameset_loc | 1 | 0.000 | 0.004 | 250.556 | frameset_loc | 10 | 0.000 | 0.002 | 6312.932 | frameset_loc | 100 | 0.000 | 0.014 | 6936.304 | frameset_loc | 1000 | 0.000 | 0.104 | 9612.797 | summ_value | 1 | 0.000 | 0.006 | 158.329 | summ_value | 10 | 0.000 | 0.002 | 4444.069 | summ_value | 100 | 0.000 | 0.019 | 5338.715 | summ_value | 1000 | 0.000 | 0.142 | 7028.345 | summ_statistics | 1 | 0.000 | 0.008 | 123.090 | summ_statistics | 10 | 0.000 | 0.002 | 4235.386 | summ_statistics | 100 | 0.000 | 0.021 | 4739.808 | summ_statistics | 1000 | 0.000 | 0.134 | 7469.487 | summ_spectrum | 1 | 0.000 | 0.034 | 29.343 | summ_spectrum | 10 | 0.000 | 0.006 | 1696.382 | summ_spectrum | 100 | 0.000 | 0.085 | 1177.910 | summ_spectrum | 1000 | 0.000 | 0.362 | 2760.288 | summ_comment | 1 | 0.000 | 0.006 | 156.761 | summ_comment | 10 | 0.000 | 0.002 | 4171.777 | summ_comment | 100 | 0.000 | 0.022 | 4526.300 | summ_comment | 1000 | 0.000 | 0.115 | 8697.316 | summ_csd | 1 | 0.000 | 0.037 | 27.072 | summ_csd | 10 | 0.000 | 0.006 | 1710.843 | summ_csd | 100 | 0.000 | 0.077 | 1304.463 | summ_csd | 1000 | 0.000 | 0.416 | 2405.396 | summ_mime | 1 | 0.000 | 0.035 | 28.624 | summ_mime | 10 | 0.000 | 0.004 | 2234.577 | summ_mime | 100 | 0.000 | 0.070 | 1436.656 | summ_mime | 1000 | 0.000 | 0.507 | 1970.781 | sngl_unmodeled_v | 1 | 0.000 | 0.005 | 187.262 | sngl_unmodeled_v | 10 | 0.000 | 0.003 | 3799.190 | sngl_unmodeled_v | 100 | 0.000 | 0.018 | 5644.328 | sngl_unmodeled_v | 1000 | 0.000 | 0.087 | 11536.314 | coinc_sngl | 1 | 0.000 | 0.021 | 47.540 | coinc_sngl | 10 | 0.000 | 0.005 | 2055.930 | coinc_sngl | 100 | 0.000 | 0.046 | 2169.663 | coinc_sngl | 1000 | 0.000 | 0.370 | 2701.607 | search_summvars | 1 | 0.000 | 0.004 | 253.233 | search_summvars | 10 | 0.000 | 0.002 | 6116.807 | search_summvars | 100 | 0.000 | 0.012 | 8553.515 | search_summvars | 1000 | 0.000 | 0.095 | 10478.446 | waveburst_mime | 1 | 0.000 | 0.035 | 28.431 | waveburst_mime | 10 | 0.000 | 0.005 | 2051.707 | waveburst_mime | 100 | 0.000 | 0.060 | 1679.602 | waveburst_mime | 1000 | 0.000 | 0.230 | 4356.767 | sngl_transdata | 1 | 0.000 | 0.029 | 34.956 | sngl_transdata | 10 | 0.000 | 0.004 | 2341.356 | sngl_transdata | 100 | 0.000 | 0.069 | 1443.481 | sngl_transdata | 1000 | 0.000 | 0.263 | 3804.364 | sngl_mime | 1 | 0.000 | 0.030 | 33.527 | sngl_mime | 10 | 0.000 | 0.007 | 1372.842 | sngl_mime | 100 | 0.000 | 0.070 | 1437.833 | sngl_mime | 1000 | 0.000 | 0.321 | 3111.794 | sngl_datasource | 1 | 0.000 | 0.005 | 212.176 | sngl_datasource | 10 | 0.000 | 0.002 | 5640.540 | sngl_datasource | 100 | 0.000 | 0.012 | 8036.001 | sngl_datasource | 1000 | 0.000 | 0.075 | 13301.746 |
|---|
Summary: