ldas-dev Database dev_1 Insertion Rates
| Test Period | July 27 2005 20:25:50 | |
|---|---|---|
| Input data | Ilwd with dimensions 1,10,100,1000 | |
| Platform | Linux metaserver 2.6.11-1.35_FC3smp #1 SMP Mon Jun 13 01:17:35 EDT 2005 i686 i686 i386 GNU/Linux No memory info |
|
| LDAS software | ldas-1.7.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.004 | 261.849 | process | 10 | 0.000 | 0.002 | 6578.255 | process | 100 | 0.000 | 0.006 | 16220.521 | process | 1000 | 0.000 | 0.051 | 19431.852 | runlist | 1 | 0.000 | 0.002 | 417.012 | runlist | 10 | 0.000 | 0.001 | 9795.183 | runlist | 100 | 0.000 | 0.004 | 23490.942 | runlist | 1000 | 0.000 | 0.031 | 32151.343 | calib_info | 1 | 0.000 | 0.025 | 40.484 | calib_info | 10 | 0.000 | 0.002 | 4599.520 | calib_info | 100 | 0.000 | 0.032 | 3100.968 | calib_info | 1000 | 0.000 | 0.131 | 7614.291 | sim_type | 1 | 0.000 | 0.048 | 21.022 | sim_type | 10 | 0.000 | 0.004 | 2387.199 | sim_type | 100 | 0.000 | 0.031 | 3214.494 | sim_type | 1000 | 0.000 | 0.297 | 3369.590 | process_params | 1 | 0.000 | 0.004 | 242.137 | process_params | 10 | 0.000 | 0.001 | 6949.946 | process_params | 100 | 0.000 | 0.009 | 11428.310 | process_params | 1000 | 0.000 | 0.046 | 21742.865 | frameset_chanlist | 1 | 0.000 | 0.005 | 211.194 | frameset_chanlist | 10 | 0.000 | 0.001 | 8497.404 | frameset_chanlist | 100 | 0.000 | 0.005 | 20132.999 | frameset_chanlist | 1000 | 0.000 | 0.045 | 22093.637 | frameset_writer | 1 | 0.000 | 0.004 | 260.694 | frameset_writer | 10 | 0.000 | 0.001 | 8005.956 | frameset_writer | 100 | 0.000 | 0.008 | 12036.345 | frameset_writer | 1000 | 0.000 | 0.131 | 7632.889 | segment_definer | 1 | 0.000 | 0.004 | 247.715 | segment_definer | 10 | 0.000 | 0.001 | 7570.940 | segment_definer | 100 | 0.000 | 0.008 | 12553.289 | segment_definer | 1000 | 0.000 | 0.071 | 14008.133 | filter | 1 | 0.000 | 0.004 | 270.129 | filter | 10 | 0.000 | 0.002 | 5586.436 | filter | 100 | 0.000 | 0.006 | 17306.817 | filter | 1000 | 0.000 | 0.059 | 16982.282 | search_summary | 1 | 0.000 | 0.005 | 207.290 | search_summary | 10 | 0.000 | 0.001 | 6716.278 | search_summary | 100 | 0.000 | 0.014 | 6939.144 | search_summary | 1000 | 0.000 | 0.083 | 12043.114 | sim_inst | 1 | 0.000 | 0.005 | 215.790 | sim_inst | 10 | 0.000 | 0.001 | 8673.102 | sim_inst | 100 | 0.000 | 0.005 | 20534.134 | sim_inst | 1000 | 0.000 | 0.046 | 21555.022 | sim_type_params | 1 | 0.000 | 0.003 | 327.654 | sim_type_params | 10 | 0.000 | 0.001 | 11990.580 | sim_type_params | 100 | 0.000 | 0.005 | 20550.254 | sim_type_params | 1000 | 0.000 | 0.027 | 36379.511 | frameset | 1 | 0.000 | 0.004 | 228.735 | frameset | 10 | 0.000 | 0.002 | 6557.678 | frameset | 100 | 0.000 | 0.007 | 13933.185 | frameset | 1000 | 0.000 | 0.070 | 14284.082 | segment | 1 | 0.000 | 0.004 | 251.321 | segment | 10 | 0.000 | 0.001 | 7535.568 | segment | 100 | 0.000 | 0.008 | 11886.592 | segment | 1000 | 0.000 | 0.081 | 12308.419 | filter_params | 1 | 0.000 | 0.005 | 214.960 | filter_params | 10 | 0.000 | 0.002 | 6618.747 | filter_params | 100 | 0.000 | 0.009 | 11768.860 | filter_params | 1000 | 0.000 | 0.067 | 14933.419 | gds_trigger | 1 | 0.000 | 0.006 | 164.399 | gds_trigger | 10 | 0.000 | 0.006 | 1603.880 | gds_trigger | 100 | 0.000 | 0.012 | 8202.705 | gds_trigger | 1000 | 0.000 | 0.132 | 7565.269 | sngl_inspiral | 1 | 0.000 | 0.006 | 164.231 | sngl_inspiral | 10 | 0.000 | 0.008 | 1245.488 | sngl_inspiral | 100 | 0.000 | 0.014 | 7261.742 | sngl_inspiral | 1000 | 0.000 | 0.228 | 4381.603 | sngl_burst | 1 | 0.000 | 0.007 | 143.287 | sngl_burst | 10 | 0.000 | 0.004 | 2307.859 | sngl_burst | 100 | 0.000 | 0.011 | 9390.553 | sngl_burst | 1000 | 0.000 | 0.117 | 8571.771 | sngl_block | 1 | 0.000 | 0.005 | 184.535 | sngl_block | 10 | 0.000 | 0.002 | 6211.026 | sngl_block | 100 | 0.000 | 0.009 | 10908.742 | sngl_block | 1000 | 0.000 | 0.082 | 12178.799 | sngl_ringdown | 1 | 0.000 | 0.005 | 200.483 | sngl_ringdown | 10 | 0.000 | 0.002 | 4563.980 | sngl_ringdown | 100 | 0.000 | 0.008 | 11999.155 | sngl_ringdown | 1000 | 0.000 | 0.077 | 12964.267 | sngl_unmodeled | 1 | 0.000 | 0.005 | 197.938 | sngl_unmodeled | 10 | 0.000 | 0.002 | 5167.932 | sngl_unmodeled | 100 | 0.000 | 0.011 | 9005.115 | sngl_unmodeled | 1000 | 0.000 | 0.108 | 9256.260 | sngl_dperiodic | 1 | 0.000 | 0.006 | 180.664 | sngl_dperiodic | 10 | 0.000 | 0.002 | 5576.778 | sngl_dperiodic | 100 | 0.000 | 0.010 | 10510.727 | sngl_dperiodic | 1000 | 0.000 | 0.094 | 10607.806 | multi_inspiral | 1 | 0.000 | 0.006 | 163.987 | multi_inspiral | 10 | 0.000 | 0.002 | 4852.273 | multi_inspiral | 100 | 0.000 | 0.011 | 8739.043 | multi_inspiral | 1000 | 0.000 | 0.110 | 9072.764 | multi_burst | 1 | 0.000 | 0.008 | 128.750 | multi_burst | 10 | 0.000 | 0.002 | 5443.599 | multi_burst | 100 | 0.000 | 0.009 | 11049.858 | multi_burst | 1000 | 0.000 | 0.089 | 11191.316 | exttrig_search | 1 | 0.000 | 0.007 | 142.571 | exttrig_search | 10 | 0.000 | 0.002 | 6325.311 | exttrig_search | 100 | 0.000 | 0.007 | 14988.212 | exttrig_search | 1000 | 0.000 | 0.056 | 17935.032 | sim_inst_params | 1 | 0.000 | 0.004 | 228.984 | sim_inst_params | 10 | 0.000 | 0.001 | 8019.696 | sim_inst_params | 100 | 0.000 | 0.004 | 23365.305 | sim_inst_params | 1000 | 0.000 | 0.032 | 31726.996 | waveburst | 1 | 0.000 | 0.006 | 161.004 | waveburst | 10 | 0.000 | 0.002 | 5488.504 | waveburst | 100 | 0.000 | 0.012 | 8264.463 | waveburst | 1000 | 0.000 | 0.123 | 8127.570 | frameset_loc | 1 | 0.000 | 0.005 | 212.801 | frameset_loc | 10 | 0.000 | 0.001 | 7022.127 | frameset_loc | 100 | 0.000 | 0.010 | 9978.148 | frameset_loc | 1000 | 0.000 | 0.059 | 17056.406 | summ_value | 1 | 0.000 | 0.006 | 164.206 | summ_value | 10 | 0.000 | 0.002 | 5224.606 | summ_value | 100 | 0.000 | 0.010 | 10170.726 | summ_value | 1000 | 0.000 | 0.089 | 11204.858 | summ_statistics | 1 | 0.000 | 0.007 | 136.859 | summ_statistics | 10 | 0.000 | 0.002 | 4291.735 | summ_statistics | 100 | 0.000 | 0.011 | 8795.152 | summ_statistics | 1000 | 0.000 | 0.115 | 8676.564 | summ_spectrum | 1 | 0.000 | 0.032 | 31.270 | summ_spectrum | 10 | 0.000 | 0.003 | 2980.599 | summ_spectrum | 100 | 0.000 | 0.100 | 995.808 | summ_spectrum | 1000 | 0.000 | 0.329 | 3043.640 | summ_comment | 1 | 0.000 | 0.006 | 176.841 | summ_comment | 10 | 0.000 | 0.002 | 5754.303 | summ_comment | 100 | 0.000 | 0.010 | 10176.895 | summ_comment | 1000 | 0.000 | 0.087 | 11559.491 | summ_csd | 1 | 0.000 | 0.036 | 27.523 | summ_csd | 10 | 0.000 | 0.004 | 2757.236 | summ_csd | 100 | 0.000 | 0.047 | 2106.949 | summ_csd | 1000 | 0.000 | 0.419 | 2385.229 | summ_mime | 1 | 0.000 | 0.032 | 31.635 | summ_mime | 10 | 0.000 | 0.004 | 2433.735 | summ_mime | 100 | 0.000 | 0.068 | 1461.817 | summ_mime | 1000 | 0.000 | 0.385 | 2595.057 | sngl_unmodeled_v | 1 | 0.000 | 0.004 | 225.016 | sngl_unmodeled_v | 10 | 0.000 | 0.001 | 6853.446 | sngl_unmodeled_v | 100 | 0.000 | 0.009 | 10972.095 | sngl_unmodeled_v | 1000 | 0.000 | 0.071 | 14101.349 | coinc_sngl | 1 | 0.000 | 0.016 | 63.926 | coinc_sngl | 10 | 0.000 | 0.004 | 2571.930 | coinc_sngl | 100 | 0.000 | 0.027 | 3654.557 | coinc_sngl | 1000 | 0.000 | 0.258 | 3882.364 | search_summvars | 1 | 0.000 | 0.004 | 256.345 | search_summvars | 10 | 0.000 | 0.001 | 6959.184 | search_summvars | 100 | 0.000 | 0.006 | 16503.911 | search_summvars | 1000 | 0.000 | 0.083 | 11995.859 | waveburst_mime | 1 | 0.000 | 0.028 | 35.594 | waveburst_mime | 10 | 0.000 | 0.002 | 4688.474 | waveburst_mime | 100 | 0.000 | 0.059 | 1697.329 | waveburst_mime | 1000 | 0.000 | 0.190 | 5264.377 | sngl_transdata | 1 | 0.000 | 0.030 | 33.697 | sngl_transdata | 10 | 0.000 | 0.003 | 3209.356 | sngl_transdata | 100 | 0.000 | 0.064 | 1552.744 | sngl_transdata | 1000 | 0.000 | 0.344 | 2905.347 | sngl_mime | 1 | 0.000 | 0.036 | 27.530 | sngl_mime | 10 | 0.000 | 0.003 | 3040.456 | sngl_mime | 100 | 0.000 | 0.043 | 2323.253 | sngl_mime | 1000 | 0.000 | 0.228 | 4388.486 | sngl_datasource | 1 | 0.000 | 0.004 | 272.996 | sngl_datasource | 10 | 0.000 | 0.001 | 6747.593 | sngl_datasource | 100 | 0.000 | 0.010 | 10198.920 | sngl_datasource | 1000 | 0.000 | 0.060 | 16801.075 |
|---|
Summary: