ldas-dev Database dev_1 Insertion Rates
| Test Period | August 31 2004 13:46:49 | |
|---|---|---|
| Input data | Ilwd with dimensions 1,10,100,1000 | |
| Platform | Linux metaserver 2.4.20-28.9smp #1 SMP Thu Dec 18 13:37:36 EST 2003 i686 i686 i386 GNU/Linux No memory info |
|
| LDAS software | ldas-1.2.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 | 237.033 | process | 10 | 0.000 | 0.001 | 8439.246 | process | 100 | 0.000 | 0.016 | 6098.677 | process | 1000 | 0.000 | 0.406 | 2464.305 | runlist | 1 | 0.000 | 0.003 | 381.543 | runlist | 10 | 0.000 | 0.001 | 10172.940 | runlist | 100 | 0.000 | 0.004 | 26420.847 | runlist | 1000 | 0.000 | 0.180 | 5569.572 | calib_info | 1 | 0.000 | 0.019 | 52.634 | calib_info | 10 | 0.000 | 0.002 | 4043.475 | calib_info | 100 | 0.000 | 0.029 | 3503.486 | calib_info | 1000 | 0.000 | 0.410 | 2438.638 | sim_type | 1 | 0.000 | 0.169 | 5.903 | sim_type | 10 | 0.000 | 0.004 | 2786.913 | sim_type | 100 | 0.000 | 0.029 | 3476.822 | sim_type | 1000 | 0.000 | 0.292 | 3428.520 | process_params | 1 | 0.000 | 0.005 | 219.689 | process_params | 10 | 0.000 | 0.001 | 8150.624 | process_params | 100 | 0.000 | 0.023 | 4369.484 | process_params | 1000 | 0.000 | 0.261 | 3833.900 | frameset_chanlist | 1 | 0.000 | 0.005 | 216.503 | frameset_chanlist | 10 | 0.000 | 0.001 | 11084.312 | frameset_chanlist | 100 | 0.000 | 0.005 | 21079.036 | frameset_chanlist | 1000 | 0.000 | 0.182 | 5504.274 | frameset_writer | 1 | 0.000 | 0.004 | 231.640 | frameset_writer | 10 | 0.000 | 0.001 | 8183.976 | frameset_writer | 100 | 0.000 | 0.029 | 3435.246 | frameset_writer | 1000 | 0.000 | 0.468 | 2138.356 | segment_definer | 1 | 0.000 | 0.005 | 213.082 | segment_definer | 10 | 0.000 | 0.001 | 8196.789 | segment_definer | 100 | 0.000 | 0.032 | 3161.056 | segment_definer | 1000 | 0.000 | 0.341 | 2934.694 | filter | 1 | 0.000 | 0.004 | 222.074 | filter | 10 | 0.000 | 0.001 | 8525.004 | filter | 100 | 0.000 | 0.018 | 5481.254 | filter | 1000 | 0.000 | 0.283 | 3530.026 | search_summary | 1 | 0.000 | 0.005 | 193.197 | search_summary | 10 | 0.000 | 0.002 | 4566.481 | search_summary | 100 | 0.000 | 0.027 | 3725.227 | search_summary | 1000 | 0.000 | 0.456 | 2191.147 | sim_inst | 1 | 0.000 | 0.006 | 171.028 | sim_inst | 10 | 0.000 | 0.001 | 9920.340 | sim_inst | 100 | 0.000 | 0.006 | 17905.231 | sim_inst | 1000 | 0.000 | 0.134 | 7478.984 | sim_type_params | 1 | 0.000 | 0.004 | 267.938 | sim_type_params | 10 | 0.000 | 0.001 | 13260.524 | sim_type_params | 100 | 0.000 | 0.004 | 27084.490 | sim_type_params | 1000 | 0.000 | 0.124 | 8089.175 | frameset | 1 | 0.000 | 0.006 | 158.605 | frameset | 10 | 0.000 | 0.001 | 6969.612 | frameset | 100 | 0.000 | 0.022 | 4470.053 | frameset | 1000 | 0.000 | 0.275 | 3641.024 | segment | 1 | 0.000 | 0.005 | 217.682 | segment | 10 | 0.000 | 0.002 | 4672.788 | segment | 100 | 0.000 | 0.021 | 4783.751 | segment | 1000 | 0.000 | 0.334 | 2990.404 | filter_params | 1 | 0.000 | 0.006 | 170.507 | filter_params | 10 | 0.000 | 0.001 | 7199.269 | filter_params | 100 | 0.000 | 0.025 | 3951.632 | filter_params | 1000 | 0.000 | 0.368 | 2719.128 | gds_trigger | 1 | 0.000 | 0.008 | 121.111 | gds_trigger | 10 | 0.000 | 0.002 | 5913.311 | gds_trigger | 100 | 0.000 | 0.046 | 2155.414 | gds_trigger | 1000 | 0.000 | 0.672 | 1488.494 | sngl_inspiral | 1 | 0.000 | 0.008 | 131.183 | sngl_inspiral | 10 | 0.000 | 0.002 | 5210.966 | sngl_inspiral | 100 | 0.000 | 0.050 | 1983.261 | sngl_inspiral | 1000 | 0.000 | 0.594 | 1682.519 | sngl_burst | 1 | 0.000 | 0.009 | 116.331 | sngl_burst | 10 | 0.000 | 0.002 | 5865.343 | sngl_burst | 100 | 0.000 | 0.047 | 2111.308 | sngl_burst | 1000 | 0.000 | 0.561 | 1783.679 | sngl_block | 1 | 0.000 | 0.007 | 150.533 | sngl_block | 10 | 0.000 | 0.003 | 3577.536 | sngl_block | 100 | 0.000 | 0.028 | 3576.410 | sngl_block | 1000 | 0.000 | 0.363 | 2755.481 | sngl_ringdown | 1 | 0.000 | 0.019 | 53.588 | sngl_ringdown | 10 | 0.000 | 0.001 | 6978.854 | sngl_ringdown | 100 | 0.000 | 0.027 | 3673.769 | sngl_ringdown | 1000 | 0.000 | 0.341 | 2932.027 | sngl_unmodeled | 1 | 0.000 | 0.006 | 161.109 | sngl_unmodeled | 10 | 0.000 | 0.002 | 5875.199 | sngl_unmodeled | 100 | 0.000 | 0.046 | 2193.752 | sngl_unmodeled | 1000 | 0.000 | 0.544 | 1837.303 | sngl_dperiodic | 1 | 0.000 | 0.007 | 138.312 | sngl_dperiodic | 10 | 0.000 | 0.002 | 5770.141 | sngl_dperiodic | 100 | 0.000 | 0.045 | 2216.371 | sngl_dperiodic | 1000 | 0.000 | 0.493 | 2028.982 | multi_inspiral | 1 | 0.000 | 0.008 | 132.589 | multi_inspiral | 10 | 0.000 | 0.003 | 3437.667 | multi_inspiral | 100 | 0.000 | 0.049 | 2052.760 | multi_inspiral | 1000 | 0.000 | 0.525 | 1903.507 | multi_burst | 1 | 0.000 | 0.006 | 160.979 | multi_burst | 10 | 0.000 | 0.003 | 3058.852 | multi_burst | 100 | 0.000 | 0.029 | 3469.957 | multi_burst | 1000 | 0.000 | 0.341 | 2929.519 | exttrig_search | 1 | 0.000 | 0.006 | 168.345 | exttrig_search | 10 | 0.000 | 0.001 | 7002.164 | exttrig_search | 100 | 0.000 | 0.030 | 3350.533 | exttrig_search | 1000 | 0.000 | 0.334 | 2997.350 | sim_inst_params | 1 | 0.000 | 0.004 | 245.224 | sim_inst_params | 10 | 0.000 | 0.001 | 13298.367 | sim_inst_params | 100 | 0.000 | 0.003 | 29249.003 | sim_inst_params | 1000 | 0.000 | 0.094 | 10626.180 | waveburst | 1 | 0.000 | 0.010 | 97.228 | waveburst | 10 | 0.000 | 0.002 | 6113.254 | waveburst | 100 | 0.000 | 0.031 | 3179.236 | waveburst | 1000 | 0.000 | 0.421 | 2373.775 | frameset_loc | 1 | 0.000 | 0.005 | 218.249 | frameset_loc | 10 | 0.000 | 0.001 | 7632.947 | frameset_loc | 100 | 0.000 | 0.037 | 2732.464 | frameset_loc | 1000 | 0.000 | 0.310 | 3229.599 | summ_value | 1 | 0.000 | 0.009 | 114.131 | summ_value | 10 | 0.000 | 0.002 | 5800.464 | summ_value | 100 | 0.000 | 0.044 | 2248.798 | summ_value | 1000 | 0.000 | 0.526 | 1900.349 | summ_statistics | 1 | 0.000 | 0.009 | 111.708 | summ_statistics | 10 | 0.000 | 0.002 | 5567.898 | summ_statistics | 100 | 0.000 | 0.048 | 2072.028 | summ_statistics | 1000 | 0.000 | 0.540 | 1852.143 | summ_spectrum | 1 | 0.000 | 0.041 | 24.489 | summ_spectrum | 10 | 0.000 | 0.019 | 535.877 | summ_spectrum | 100 | 0.000 | 0.148 | 674.878 | summ_spectrum | 1000 | 0.000 | 1.453 | 688.454 | summ_comment | 1 | 0.000 | 0.008 | 121.286 | summ_comment | 10 | 0.000 | 0.002 | 5596.127 | summ_comment | 100 | 0.000 | 0.032 | 3150.986 | summ_comment | 1000 | 0.000 | 0.375 | 2669.015 | summ_csd | 1 | 0.000 | 0.047 | 21.177 | summ_csd | 10 | 0.000 | 0.024 | 409.989 | summ_csd | 100 | 0.000 | 0.138 | 722.637 | summ_csd | 1000 | 0.000 | 1.289 | 775.729 | summ_mime | 1 | 0.000 | 0.039 | 25.473 | summ_mime | 10 | 0.000 | 0.025 | 403.109 | summ_mime | 100 | 0.000 | 0.105 | 956.892 | summ_mime | 1000 | 0.000 | 1.095 | 913.651 | sngl_unmodeled_v | 1 | 0.000 | 0.006 | 169.344 | sngl_unmodeled_v | 10 | 0.000 | 0.001 | 7823.747 | sngl_unmodeled_v | 100 | 0.000 | 0.024 | 4160.599 | sngl_unmodeled_v | 1000 | 0.000 | 0.289 | 3456.536 | coinc_sngl | 1 | 0.000 | 0.055 | 18.166 | coinc_sngl | 10 | 0.000 | 0.004 | 2550.968 | coinc_sngl | 100 | 0.000 | 0.069 | 1447.955 | coinc_sngl | 1000 | 0.000 | 0.661 | 1512.898 | search_summvars | 1 | 0.000 | 0.007 | 144.194 | search_summvars | 10 | 0.000 | 0.001 | 7879.600 | search_summvars | 100 | 0.000 | 0.006 | 18030.721 | search_summvars | 1000 | 0.000 | 0.230 | 4346.447 | waveburst_mime | 1 | 0.000 | 0.030 | 33.087 | waveburst_mime | 10 | 0.000 | 0.019 | 524.604 | waveburst_mime | 100 | 0.000 | 0.068 | 1469.938 | waveburst_mime | 1000 | 0.000 | 0.392 | 2549.057 | sngl_transdata | 1 | 0.000 | 0.033 | 30.318 | sngl_transdata | 10 | 0.000 | 0.020 | 494.682 | sngl_transdata | 100 | 0.000 | 0.094 | 1062.258 | sngl_transdata | 1000 | 0.000 | 0.941 | 1062.775 | sngl_mime | 1 | 0.000 | 0.040 | 25.088 | sngl_mime | 10 | 0.000 | 0.153 | 65.351 | sngl_mime | 100 | 0.000 | 0.089 | 1119.093 | sngl_mime | 1000 | 0.000 | 1.001 | 998.861 | sngl_datasource | 1 | 0.000 | 0.005 | 210.970 | sngl_datasource | 10 | 0.000 | 0.003 | 3445.864 | sngl_datasource | 100 | 0.000 | 0.038 | 2616.418 | sngl_datasource | 1000 | 0.000 | 0.346 | 2892.431 |
|---|
Summary: