ldas-dev Database dev_1 Insertion Rates
| Test Period | May 24 2005 13:39:14 | |
|---|---|---|
| Input data | Ilwd with dimensions 1,10,100,1000 | |
| Platform | Linux metaserver 2.6.10-1.766_FC3smp #1 SMP Wed Feb 9 23:21:37 EST 2005 i686 i686 i386 GNU/Linux No memory info |
|
| LDAS software | ldas-1.6.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.003 | 335.894 | process | 10 | 0.000 | 0.001 | 7128.346 | process | 100 | 0.000 | 0.007 | 15321.092 | process | 1000 | 0.000 | 0.096 | 10418.718 | runlist | 1 | 0.000 | 0.003 | 371.736 | runlist | 10 | 0.000 | 0.001 | 8850.576 | runlist | 100 | 0.000 | 0.004 | 24142.635 | runlist | 1000 | 0.000 | 0.033 | 30703.007 | calib_info | 1 | 0.000 | 0.029 | 34.926 | calib_info | 10 | 0.000 | 0.002 | 4203.553 | calib_info | 100 | 0.000 | 0.093 | 1078.865 | calib_info | 1000 | 0.000 | 0.185 | 5398.023 | sim_type | 1 | 0.000 | 0.061 | 16.406 | sim_type | 10 | 0.000 | 0.004 | 2633.623 | sim_type | 100 | 0.000 | 0.031 | 3268.935 | sim_type | 1000 | 0.000 | 0.299 | 3342.570 | process_params | 1 | 0.000 | 0.004 | 266.525 | process_params | 10 | 0.000 | 0.001 | 8103.399 | process_params | 100 | 0.000 | 0.006 | 16392.959 | process_params | 1000 | 0.000 | 0.046 | 21523.475 | frameset_chanlist | 1 | 0.000 | 0.004 | 254.710 | frameset_chanlist | 10 | 0.000 | 0.001 | 9615.570 | frameset_chanlist | 100 | 0.000 | 0.005 | 19943.440 | frameset_chanlist | 1000 | 0.000 | 0.039 | 25415.544 | frameset_writer | 1 | 0.000 | 0.004 | 262.867 | frameset_writer | 10 | 0.000 | 0.001 | 7565.498 | frameset_writer | 100 | 0.000 | 0.009 | 11027.778 | frameset_writer | 1000 | 0.000 | 0.167 | 5987.056 | segment_definer | 1 | 0.000 | 0.004 | 258.604 | segment_definer | 10 | 0.000 | 0.001 | 7210.429 | segment_definer | 100 | 0.000 | 0.009 | 11763.253 | segment_definer | 1000 | 0.000 | 0.094 | 10614.922 | filter | 1 | 0.000 | 0.004 | 255.688 | filter | 10 | 0.000 | 0.001 | 7819.342 | filter | 100 | 0.000 | 0.006 | 16736.374 | filter | 1000 | 0.000 | 0.053 | 18746.567 | search_summary | 1 | 0.000 | 0.004 | 225.379 | search_summary | 10 | 0.000 | 0.002 | 5906.640 | search_summary | 100 | 0.000 | 0.008 | 11882.214 | search_summary | 1000 | 0.000 | 0.110 | 9081.415 | sim_inst | 1 | 0.000 | 0.004 | 229.310 | sim_inst | 10 | 0.000 | 0.001 | 9882.888 | sim_inst | 100 | 0.000 | 0.005 | 19972.877 | sim_inst | 1000 | 0.000 | 0.049 | 20265.847 | sim_type_params | 1 | 0.000 | 0.003 | 318.256 | sim_type_params | 10 | 0.000 | 0.001 | 12153.873 | sim_type_params | 100 | 0.000 | 0.003 | 29833.559 | sim_type_params | 1000 | 0.000 | 0.030 | 33687.274 | frameset | 1 | 0.000 | 0.005 | 199.919 | frameset | 10 | 0.000 | 0.001 | 7732.876 | frameset | 100 | 0.000 | 0.007 | 14581.277 | frameset | 1000 | 0.000 | 0.065 | 15368.538 | segment | 1 | 0.000 | 0.004 | 260.483 | segment | 10 | 0.000 | 0.001 | 7122.253 | segment | 100 | 0.000 | 0.009 | 11126.069 | segment | 1000 | 0.000 | 0.091 | 10977.900 | filter_params | 1 | 0.000 | 0.004 | 234.738 | filter_params | 10 | 0.000 | 0.002 | 6505.842 | filter_params | 100 | 0.000 | 0.008 | 12406.979 | filter_params | 1000 | 0.000 | 0.065 | 15282.808 | gds_trigger | 1 | 0.000 | 0.006 | 158.103 | gds_trigger | 10 | 0.000 | 0.002 | 4551.599 | gds_trigger | 100 | 0.000 | 0.016 | 6359.745 | gds_trigger | 1000 | 0.000 | 0.137 | 7319.090 | sngl_inspiral | 1 | 0.000 | 0.006 | 161.425 | sngl_inspiral | 10 | 0.000 | 0.002 | 4351.837 | sngl_inspiral | 100 | 0.000 | 0.017 | 5908.734 | sngl_inspiral | 1000 | 0.000 | 0.162 | 6154.111 | sngl_burst | 1 | 0.000 | 0.006 | 155.161 | sngl_burst | 10 | 0.000 | 0.002 | 4279.027 | sngl_burst | 100 | 0.000 | 0.010 | 10061.182 | sngl_burst | 1000 | 0.000 | 0.092 | 10823.893 | sngl_block | 1 | 0.000 | 0.005 | 203.706 | sngl_block | 10 | 0.000 | 0.002 | 5624.645 | sngl_block | 100 | 0.000 | 0.009 | 10770.094 | sngl_block | 1000 | 0.000 | 0.084 | 11854.381 | sngl_ringdown | 1 | 0.000 | 0.005 | 201.253 | sngl_ringdown | 10 | 0.000 | 0.002 | 5820.586 | sngl_ringdown | 100 | 0.000 | 0.009 | 11340.556 | sngl_ringdown | 1000 | 0.000 | 0.068 | 14619.904 | sngl_unmodeled | 1 | 0.000 | 0.005 | 208.682 | sngl_unmodeled | 10 | 0.000 | 0.002 | 4378.188 | sngl_unmodeled | 100 | 0.000 | 0.012 | 8628.128 | sngl_unmodeled | 1000 | 0.000 | 0.122 | 8164.465 | sngl_dperiodic | 1 | 0.000 | 0.007 | 142.267 | sngl_dperiodic | 10 | 0.000 | 0.002 | 4940.297 | sngl_dperiodic | 100 | 0.000 | 0.011 | 9488.746 | sngl_dperiodic | 1000 | 0.000 | 0.131 | 7661.250 | multi_inspiral | 1 | 0.000 | 0.005 | 182.353 | multi_inspiral | 10 | 0.000 | 0.002 | 4887.323 | multi_inspiral | 100 | 0.000 | 0.059 | 1684.406 | multi_inspiral | 1000 | 0.000 | 0.113 | 8833.376 | multi_burst | 1 | 0.000 | 0.006 | 165.567 | multi_burst | 10 | 0.000 | 0.002 | 5524.648 | multi_burst | 100 | 0.000 | 0.011 | 8950.148 | multi_burst | 1000 | 0.000 | 0.071 | 14114.685 | exttrig_search | 1 | 0.000 | 0.005 | 206.311 | exttrig_search | 10 | 0.000 | 0.001 | 7117.438 | exttrig_search | 100 | 0.000 | 0.007 | 13581.273 | exttrig_search | 1000 | 0.000 | 0.060 | 16725.513 | sim_inst_params | 1 | 0.000 | 0.003 | 312.309 | sim_inst_params | 10 | 0.000 | 0.001 | 10092.162 | sim_inst_params | 100 | 0.000 | 0.004 | 26420.847 | sim_inst_params | 1000 | 0.000 | 0.035 | 28736.375 | waveburst | 1 | 0.000 | 0.006 | 167.170 | waveburst | 10 | 0.000 | 0.002 | 5364.922 | waveburst | 100 | 0.000 | 0.012 | 8200.015 | waveburst | 1000 | 0.000 | 0.133 | 7503.789 | frameset_loc | 1 | 0.000 | 0.004 | 281.535 | frameset_loc | 10 | 0.000 | 0.001 | 6868.038 | frameset_loc | 100 | 0.000 | 0.010 | 9823.183 | frameset_loc | 1000 | 0.000 | 0.066 | 15259.441 | summ_value | 1 | 0.000 | 0.005 | 183.221 | summ_value | 10 | 0.000 | 0.002 | 5440.785 | summ_value | 100 | 0.000 | 0.010 | 9802.096 | summ_value | 1000 | 0.000 | 0.089 | 11260.513 | summ_statistics | 1 | 0.000 | 0.008 | 124.037 | summ_statistics | 10 | 0.000 | 0.002 | 4955.475 | summ_statistics | 100 | 0.000 | 0.014 | 7002.899 | summ_statistics | 1000 | 0.000 | 0.104 | 9578.361 | summ_spectrum | 1 | 0.000 | 0.033 | 30.054 | summ_spectrum | 10 | 0.000 | 0.004 | 2651.099 | summ_spectrum | 100 | 0.000 | 0.081 | 1238.573 | summ_spectrum | 1000 | 0.000 | 0.340 | 2938.627 | summ_comment | 1 | 0.000 | 0.006 | 170.799 | summ_comment | 10 | 0.000 | 0.002 | 5800.464 | summ_comment | 100 | 0.000 | 0.010 | 10447.105 | summ_comment | 1000 | 0.000 | 0.077 | 13055.836 | summ_csd | 1 | 0.000 | 0.031 | 31.954 | summ_csd | 10 | 0.000 | 0.003 | 2888.437 | summ_csd | 100 | 0.000 | 0.055 | 1816.732 | summ_csd | 1000 | 0.000 | 0.380 | 2631.427 | summ_mime | 1 | 0.000 | 0.032 | 31.552 | summ_mime | 10 | 0.000 | 0.003 | 2926.527 | summ_mime | 100 | 0.000 | 0.069 | 1458.706 | summ_mime | 1000 | 0.000 | 0.512 | 1954.816 | sngl_unmodeled_v | 1 | 0.000 | 0.004 | 236.299 | sngl_unmodeled_v | 10 | 0.000 | 0.002 | 4964.849 | sngl_unmodeled_v | 100 | 0.000 | 0.013 | 7577.365 | sngl_unmodeled_v | 1000 | 0.000 | 0.064 | 15644.091 | coinc_sngl | 1 | 0.000 | 0.015 | 65.964 | coinc_sngl | 10 | 0.000 | 0.004 | 2423.050 | coinc_sngl | 100 | 0.000 | 0.028 | 3626.473 | coinc_sngl | 1000 | 0.000 | 0.353 | 2833.760 | search_summvars | 1 | 0.000 | 0.004 | 280.499 | search_summvars | 10 | 0.000 | 0.001 | 6921.277 | search_summvars | 100 | 0.000 | 0.006 | 17668.406 | search_summvars | 1000 | 0.000 | 0.051 | 19803.117 | waveburst_mime | 1 | 0.000 | 0.033 | 30.741 | waveburst_mime | 10 | 0.000 | 0.002 | 4732.899 | waveburst_mime | 100 | 0.000 | 0.082 | 1221.508 | waveburst_mime | 1000 | 0.000 | 0.255 | 3920.339 | sngl_transdata | 1 | 0.000 | 0.063 | 15.837 | sngl_transdata | 10 | 0.000 | 0.005 | 1991.219 | sngl_transdata | 100 | 0.000 | 0.077 | 1299.967 | sngl_transdata | 1000 | 0.000 | 0.301 | 3320.637 | sngl_mime | 1 | 0.000 | 0.033 | 29.982 | sngl_mime | 10 | 0.000 | 0.004 | 2812.141 | sngl_mime | 100 | 0.000 | 0.071 | 1403.448 | sngl_mime | 1000 | 0.000 | 0.306 | 3265.168 | sngl_datasource | 1 | 0.000 | 0.004 | 277.548 | sngl_datasource | 10 | 0.000 | 0.001 | 7076.590 | sngl_datasource | 100 | 0.000 | 0.007 | 13609.034 | sngl_datasource | 1000 | 0.000 | 0.067 | 14882.015 |
|---|
Summary: