ldas-dev Database dev_1 Insertion Rates
| Test Period | February 04 2004 15:32:43 | |
|---|---|---|
| Input data | Ilwd with dimensions 1,10,100,1000 | |
| Platform | SunOS ldas-dev 5.9 Generic_112233-07 sun4u sparc SUNW,Sun-Fire-280R Solaris Memory: 8192M real, 6978M free, 148M swap in use, 6282M swap free |
|
| LDAS software | ldas-0.9.97, IBM DB2 7.2 |
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 | 290.948 | process | 10 | 0.000 | 0.001 | 6948.836 | process | 100 | 0.000 | 0.008 | 13039.561 | process | 1000 | 0.000 | 0.116 | 8614.748 | runlist | 1 | 0.000 | 0.003 | 316.958 | runlist | 10 | 0.000 | 0.001 | 9098.270 | runlist | 100 | 0.000 | 0.018 | 5554.630 | runlist | 1000 | 0.000 | 0.040 | 25256.990 | calib_info | 1 | 0.000 | 0.013 | 76.395 | calib_info | 10 | 0.000 | 0.027 | 374.295 | calib_info | 100 | 0.000 | 0.327 | 305.434 | calib_info | 1000 | 0.000 | 1.463 | 683.536 | sim_type | 1 | 0.000 | 0.031 | 32.367 | sim_type | 10 | 0.000 | 0.004 | 2457.697 | sim_type | 100 | 0.000 | 0.905 | 110.437 | sim_type | 1000 | 0.000 | 0.536 | 1866.790 | process_params | 1 | 0.000 | 0.004 | 252.836 | process_params | 10 | 0.000 | 0.001 | 7257.842 | process_params | 100 | 0.000 | 0.006 | 17081.958 | process_params | 1000 | 0.000 | 0.096 | 10424.463 | frameset_chanlist | 1 | 0.000 | 0.004 | 276.943 | frameset_chanlist | 10 | 0.000 | 0.001 | 7892.909 | frameset_chanlist | 100 | 0.000 | 0.006 | 17733.389 | frameset_chanlist | 1000 | 0.000 | 0.050 | 19910.007 | frameset_writer | 1 | 0.000 | 0.004 | 234.358 | frameset_writer | 10 | 0.000 | 0.001 | 6993.985 | frameset_writer | 100 | 0.000 | 0.024 | 4254.414 | frameset_writer | 1000 | 0.000 | 0.116 | 8598.822 | segment_definer | 1 | 0.000 | 0.004 | 248.684 | segment_definer | 10 | 0.000 | 0.002 | 5959.511 | segment_definer | 100 | 0.000 | 0.031 | 3205.745 | segment_definer | 1000 | 0.000 | 0.113 | 8867.213 | filter | 1 | 0.000 | 0.004 | 247.087 | filter | 10 | 0.000 | 0.001 | 7507.282 | filter | 100 | 0.000 | 0.008 | 12561.189 | filter | 1000 | 0.000 | 0.086 | 11583.056 | search_summary | 1 | 0.000 | 0.004 | 233.640 | search_summary | 10 | 0.000 | 0.002 | 5820.586 | search_summary | 100 | 0.000 | 0.028 | 3570.294 | search_summary | 1000 | 0.000 | 0.268 | 3736.781 | sim_inst | 1 | 0.000 | 0.004 | 265.395 | sim_inst | 10 | 0.000 | 0.001 | 7309.674 | sim_inst | 100 | 0.000 | 0.006 | 17485.727 | sim_inst | 1000 | 0.000 | 0.053 | 18917.216 | sim_type_params | 1 | 0.000 | 0.004 | 258.318 | sim_type_params | 10 | 0.000 | 0.001 | 7842.768 | sim_type_params | 100 | 0.000 | 0.004 | 26420.847 | sim_type_params | 1000 | 0.000 | 0.043 | 23195.398 | frameset | 1 | 0.000 | 0.005 | 206.403 | frameset | 10 | 0.000 | 0.002 | 4887.323 | frameset | 100 | 0.000 | 0.008 | 11969.024 | frameset | 1000 | 0.000 | 0.078 | 12745.202 | segment | 1 | 0.000 | 0.006 | 164.444 | segment | 10 | 0.000 | 0.002 | 6574.147 | segment | 100 | 0.000 | 0.012 | 8492.713 | segment | 1000 | 0.000 | 0.119 | 8388.980 | filter_params | 1 | 0.000 | 0.004 | 243.557 | filter_params | 10 | 0.000 | 0.002 | 5473.454 | filter_params | 100 | 0.000 | 0.016 | 6433.392 | filter_params | 1000 | 0.000 | 0.075 | 13333.529 | gds_trigger | 1 | 0.000 | 0.005 | 199.160 | gds_trigger | 10 | 0.000 | 0.003 | 3841.987 | gds_trigger | 100 | 0.000 | 0.016 | 6337.537 | gds_trigger | 1000 | 0.000 | 0.169 | 5926.066 | sngl_inspiral | 1 | 0.000 | 0.013 | 79.346 | sngl_inspiral | 10 | 0.000 | 0.003 | 3403.641 | sngl_inspiral | 100 | 0.000 | 0.029 | 3472.222 | sngl_inspiral | 1000 | 0.000 | 0.196 | 5107.539 | sngl_burst | 1 | 0.000 | 0.005 | 207.639 | sngl_burst | 10 | 0.000 | 0.002 | 4450.180 | sngl_burst | 100 | 0.000 | 0.010 | 9653.441 | sngl_burst | 1000 | 0.000 | 0.098 | 10193.160 | sngl_block | 1 | 0.000 | 0.007 | 136.126 | sngl_block | 10 | 0.000 | 0.003 | 3960.255 | sngl_block | 100 | 0.000 | 0.014 | 7079.095 | sngl_block | 1000 | 0.000 | 0.105 | 9508.325 | sngl_ringdown | 1 | 0.000 | 0.005 | 211.641 | sngl_ringdown | 10 | 0.000 | 0.002 | 5065.574 | sngl_ringdown | 100 | 0.000 | 0.015 | 6530.442 | sngl_ringdown | 1000 | 0.000 | 0.092 | 10885.278 | sngl_unmodeled | 1 | 0.000 | 0.006 | 163.317 | sngl_unmodeled | 10 | 0.000 | 0.002 | 4387.812 | sngl_unmodeled | 100 | 0.000 | 0.015 | 6523.115 | sngl_unmodeled | 1000 | 0.000 | 0.164 | 6086.390 | sngl_dperiodic | 1 | 0.000 | 0.005 | 205.513 | sngl_dperiodic | 10 | 0.000 | 0.011 | 883.775 | sngl_dperiodic | 100 | 0.000 | 0.011 | 8824.568 | sngl_dperiodic | 1000 | 0.000 | 0.191 | 5235.684 | multi_inspiral | 1 | 0.000 | 0.006 | 169.262 | multi_inspiral | 10 | 0.000 | 0.003 | 3606.450 | multi_inspiral | 100 | 0.000 | 0.014 | 7244.277 | multi_inspiral | 1000 | 0.000 | 0.156 | 6405.329 | multi_burst | 1 | 0.000 | 0.007 | 153.396 | multi_burst | 10 | 0.000 | 0.002 | 4324.923 | multi_burst | 100 | 0.000 | 0.009 | 10565.263 | multi_burst | 1000 | 0.000 | 0.300 | 3332.467 | exttrig_search | 1 | 0.000 | 0.005 | 207.906 | exttrig_search | 10 | 0.000 | 0.002 | 4391.936 | exttrig_search | 100 | 0.000 | 0.008 | 12333.650 | exttrig_search | 1000 | 0.000 | 0.301 | 3323.153 | sim_inst_params | 1 | 0.000 | 0.003 | 286.868 | sim_inst_params | 10 | 0.000 | 0.001 | 8937.349 | sim_inst_params | 100 | 0.000 | 0.004 | 26157.194 | sim_inst_params | 1000 | 0.000 | 0.042 | 23622.289 | waveburst | 1 | 0.000 | 0.006 | 173.154 | waveburst | 10 | 0.000 | 0.004 | 2484.336 | waveburst | 100 | 0.000 | 0.020 | 4950.250 | waveburst | 1000 | 0.000 | 0.210 | 4766.899 | frameset_loc | 1 | 0.000 | 0.012 | 83.507 | frameset_loc | 10 | 0.000 | 0.002 | 6575.184 | frameset_loc | 100 | 0.000 | 0.015 | 6871.860 | frameset_loc | 1000 | 0.000 | 0.257 | 3884.898 | summ_value | 1 | 0.000 | 0.005 | 183.422 | summ_value | 10 | 0.000 | 0.002 | 4220.887 | summ_value | 100 | 0.000 | 0.012 | 8128.165 | summ_value | 1000 | 0.000 | 0.379 | 2641.457 | summ_statistics | 1 | 0.000 | 0.006 | 173.490 | summ_statistics | 10 | 0.000 | 0.003 | 2942.960 | summ_statistics | 100 | 0.000 | 0.016 | 6110.229 | summ_statistics | 1000 | 0.000 | 0.283 | 3539.121 | summ_spectrum | 1 | 0.000 | 0.024 | 42.411 | summ_spectrum | 10 | 0.000 | 0.028 | 356.468 | summ_spectrum | 100 | 0.000 | 0.327 | 306.101 | summ_spectrum | 1000 | 0.000 | 1.740 | 574.637 | summ_comment | 1 | 0.000 | 0.006 | 179.820 | summ_comment | 10 | 0.000 | 0.003 | 3673.742 | summ_comment | 100 | 0.000 | 0.011 | 9489.377 | summ_comment | 1000 | 0.000 | 0.108 | 9238.643 | summ_csd | 1 | 0.000 | 0.018 | 54.183 | summ_csd | 10 | 0.000 | 0.029 | 348.529 | summ_csd | 100 | 0.000 | 0.362 | 275.896 | summ_csd | 1000 | 0.000 | 1.629 | 613.817 | summ_mime | 1 | 0.000 | 0.016 | 62.088 | summ_mime | 10 | 0.000 | 0.023 | 428.945 | summ_mime | 100 | 0.000 | 0.329 | 303.980 | summ_mime | 1000 | 0.000 | 1.631 | 613.162 | sngl_unmodeled_v | 1 | 0.000 | 0.006 | 173.426 | sngl_unmodeled_v | 10 | 0.000 | 0.002 | 6013.338 | sngl_unmodeled_v | 100 | 0.000 | 0.009 | 11530.102 | sngl_unmodeled_v | 1000 | 0.000 | 0.155 | 6450.115 | coinc_sngl | 1 | 0.000 | 0.013 | 76.260 | coinc_sngl | 10 | 0.000 | 0.004 | 2294.604 | coinc_sngl | 100 | 0.000 | 0.046 | 2163.004 | coinc_sngl | 1000 | 0.000 | 0.452 | 2212.130 | search_summvars | 1 | 0.000 | 0.004 | 237.921 | search_summvars | 10 | 0.000 | 0.001 | 7057.561 | search_summvars | 100 | 0.000 | 0.013 | 7964.447 | search_summvars | 1000 | 0.000 | 0.058 | 17283.993 | waveburst_mime | 1 | 0.000 | 0.012 | 84.105 | waveburst_mime | 10 | 0.000 | 0.041 | 244.010 | waveburst_mime | 100 | 0.000 | 0.642 | 155.804 | waveburst_mime | 1000 | 0.000 | 2.896 | 345.284 | sngl_transdata | 1 | 0.000 | 0.020 | 49.161 | sngl_transdata | 10 | 0.000 | 0.022 | 448.853 | sngl_transdata | 100 | 0.000 | 0.346 | 289.421 | sngl_transdata | 1000 | 0.000 | 1.584 | 631.433 | sngl_mime | 1 | 0.000 | 0.011 | 90.057 | sngl_mime | 10 | 0.000 | 0.027 | 369.848 | sngl_mime | 100 | 0.000 | 0.351 | 284.968 | sngl_mime | 1000 | 0.000 | 1.505 | 664.302 | sngl_datasource | 1 | 0.000 | 0.004 | 253.800 | sngl_datasource | 10 | 0.000 | 0.002 | 5851.444 | sngl_datasource | 100 | 0.000 | 0.031 | 3181.046 | sngl_datasource | 1000 | 0.000 | 0.078 | 12745.510 |
|---|
Summary: