ldas-dev Database dev_1 Insertion Rates
| Test Period | May 14 2004 12:36:24 | |
|---|---|---|
| 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.1.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 | 222.462 | process | 10 | 0.000 | 0.001 | 7283.056 | process | 100 | 0.000 | 0.052 | 1933.858 | process | 1000 | 0.000 | 0.516 | 1938.368 | runlist | 1 | 0.000 | 0.004 | 285.152 | runlist | 10 | 0.000 | 0.001 | 11557.741 | runlist | 100 | 0.000 | 0.008 | 12362.361 | runlist | 1000 | 0.000 | 0.193 | 5175.796 | calib_info | 1 | 0.000 | 0.020 | 48.845 | calib_info | 10 | 0.000 | 0.002 | 4562.002 | calib_info | 100 | 0.000 | 0.062 | 1623.616 | calib_info | 1000 | 0.000 | 0.494 | 2024.205 | sim_type | 1 | 0.000 | 0.055 | 18.274 | sim_type | 10 | 0.000 | 0.021 | 479.272 | sim_type | 100 | 0.000 | 0.034 | 2926.201 | sim_type | 1000 | 0.000 | 0.318 | 3148.169 | process_params | 1 | 0.000 | 0.006 | 178.314 | process_params | 10 | 0.000 | 0.002 | 5896.678 | process_params | 100 | 0.000 | 0.031 | 3200.707 | process_params | 1000 | 0.000 | 0.246 | 4067.752 | frameset_chanlist | 1 | 0.000 | 0.005 | 201.485 | frameset_chanlist | 10 | 0.000 | 0.001 | 11311.501 | frameset_chanlist | 100 | 0.000 | 0.017 | 5721.478 | frameset_chanlist | 1000 | 0.000 | 0.189 | 5283.178 | frameset_writer | 1 | 0.000 | 0.007 | 139.489 | frameset_writer | 10 | 0.000 | 0.001 | 7430.138 | frameset_writer | 100 | 0.000 | 0.045 | 2226.676 | frameset_writer | 1000 | 0.000 | 0.322 | 3106.352 | segment_definer | 1 | 0.000 | 0.004 | 226.047 | segment_definer | 10 | 0.000 | 0.001 | 9312.374 | segment_definer | 100 | 0.000 | 0.046 | 2182.405 | segment_definer | 1000 | 0.000 | 0.353 | 2831.297 | filter | 1 | 0.000 | 0.004 | 226.658 | filter | 10 | 0.000 | 0.001 | 8353.521 | filter | 100 | 0.000 | 0.039 | 2563.458 | filter | 1000 | 0.000 | 0.392 | 2551.958 | search_summary | 1 | 0.000 | 0.005 | 198.650 | search_summary | 10 | 0.000 | 0.001 | 7266.650 | search_summary | 100 | 0.000 | 0.036 | 2751.334 | search_summary | 1000 | 0.000 | 0.498 | 2006.090 | sim_inst | 1 | 0.000 | 0.005 | 196.537 | sim_inst | 10 | 0.000 | 0.001 | 9950.942 | sim_inst | 100 | 0.000 | 0.013 | 7904.513 | sim_inst | 1000 | 0.000 | 0.192 | 5200.127 | sim_type_params | 1 | 0.000 | 0.004 | 271.072 | sim_type_params | 10 | 0.000 | 0.001 | 12104.779 | sim_type_params | 100 | 0.000 | 0.009 | 11752.041 | sim_type_params | 1000 | 0.000 | 0.141 | 7109.392 | frameset | 1 | 0.000 | 0.006 | 164.663 | frameset | 10 | 0.000 | 0.001 | 8826.359 | frameset | 100 | 0.000 | 0.037 | 2715.554 | frameset | 1000 | 0.000 | 0.424 | 2358.346 | segment | 1 | 0.000 | 0.005 | 202.350 | segment | 10 | 0.000 | 0.001 | 9337.243 | segment | 100 | 0.000 | 0.036 | 2804.656 | segment | 1000 | 0.000 | 0.350 | 2855.332 | filter_params | 1 | 0.000 | 0.005 | 183.518 | filter_params | 10 | 0.000 | 0.001 | 7385.633 | filter_params | 100 | 0.000 | 0.042 | 2368.153 | filter_params | 1000 | 0.000 | 0.485 | 2061.036 | gds_trigger | 1 | 0.000 | 0.008 | 118.443 | gds_trigger | 10 | 0.000 | 0.002 | 6583.452 | gds_trigger | 100 | 0.000 | 0.064 | 1563.575 | gds_trigger | 1000 | 0.000 | 0.614 | 1629.193 | sngl_inspiral | 1 | 0.000 | 0.007 | 135.191 | sngl_inspiral | 10 | 0.000 | 0.002 | 5744.056 | sngl_inspiral | 100 | 0.000 | 0.048 | 2067.230 | sngl_inspiral | 1000 | 0.000 | 0.742 | 1348.269 | sngl_burst | 1 | 0.000 | 0.006 | 168.690 | sngl_burst | 10 | 0.000 | 0.001 | 7331.432 | sngl_burst | 100 | 0.000 | 0.035 | 2848.094 | sngl_burst | 1000 | 0.000 | 0.367 | 2726.259 | sngl_block | 1 | 0.000 | 0.006 | 156.884 | sngl_block | 10 | 0.000 | 0.007 | 1416.611 | sngl_block | 100 | 0.000 | 0.035 | 2870.585 | sngl_block | 1000 | 0.000 | 0.546 | 1830.925 | sngl_ringdown | 1 | 0.000 | 0.006 | 173.821 | sngl_ringdown | 10 | 0.000 | 0.006 | 1574.558 | sngl_ringdown | 100 | 0.000 | 0.026 | 3795.513 | sngl_ringdown | 1000 | 0.000 | 0.395 | 2533.069 | sngl_unmodeled | 1 | 0.000 | 0.010 | 99.079 | sngl_unmodeled | 10 | 0.000 | 0.007 | 1503.120 | sngl_unmodeled | 100 | 0.000 | 0.046 | 2165.909 | sngl_unmodeled | 1000 | 0.000 | 0.506 | 1974.384 | sngl_dperiodic | 1 | 0.000 | 0.007 | 139.550 | sngl_dperiodic | 10 | 0.000 | 0.008 | 1291.828 | sngl_dperiodic | 100 | 0.000 | 0.049 | 2027.665 | sngl_dperiodic | 1000 | 0.000 | 0.529 | 1890.820 | multi_inspiral | 1 | 0.000 | 0.007 | 143.429 | multi_inspiral | 10 | 0.000 | 0.008 | 1309.247 | multi_inspiral | 100 | 0.000 | 0.054 | 1851.543 | multi_inspiral | 1000 | 0.000 | 0.566 | 1766.541 | multi_burst | 1 | 0.000 | 0.006 | 170.327 | multi_burst | 10 | 0.000 | 0.007 | 1347.351 | multi_burst | 100 | 0.000 | 0.033 | 2985.805 | multi_burst | 1000 | 0.000 | 0.460 | 2174.154 | exttrig_search | 1 | 0.000 | 0.008 | 121.433 | exttrig_search | 10 | 0.000 | 0.006 | 1658.680 | exttrig_search | 100 | 0.000 | 0.028 | 3572.449 | exttrig_search | 1000 | 0.000 | 0.457 | 2188.337 | sim_inst_params | 1 | 0.000 | 0.004 | 245.224 | sim_inst_params | 10 | 0.000 | 0.004 | 2241.625 | sim_inst_params | 100 | 0.000 | 0.012 | 8590.327 | sim_inst_params | 1000 | 0.000 | 0.139 | 7203.210 | waveburst | 1 | 0.000 | 0.009 | 105.252 | waveburst | 10 | 0.000 | 0.012 | 833.695 | waveburst | 100 | 0.000 | 0.036 | 2764.485 | waveburst | 1000 | 0.000 | 0.457 | 2186.199 | frameset_loc | 1 | 0.000 | 0.004 | 244.551 | frameset_loc | 10 | 0.000 | 0.004 | 2346.856 | frameset_loc | 100 | 0.000 | 0.031 | 3247.164 | frameset_loc | 1000 | 0.000 | 0.347 | 2883.839 | summ_value | 1 | 0.000 | 0.009 | 113.843 | summ_value | 10 | 0.000 | 0.009 | 1150.353 | summ_value | 100 | 0.000 | 0.049 | 2053.384 | summ_value | 1000 | 0.000 | 0.474 | 2108.766 | summ_statistics | 1 | 0.000 | 0.009 | 115.890 | summ_statistics | 10 | 0.000 | 0.012 | 863.774 | summ_statistics | 100 | 0.000 | 0.075 | 1330.106 | summ_statistics | 1000 | 0.000 | 0.564 | 1773.150 | summ_spectrum | 1 | 0.000 | 0.033 | 30.201 | summ_spectrum | 10 | 0.000 | 0.018 | 548.992 | summ_spectrum | 100 | 0.000 | 0.099 | 1015.218 | summ_spectrum | 1000 | 0.000 | 1.043 | 958.479 | summ_comment | 1 | 0.000 | 0.008 | 123.504 | summ_comment | 10 | 0.000 | 0.013 | 753.585 | summ_comment | 100 | 0.000 | 0.052 | 1923.817 | summ_comment | 1000 | 0.000 | 0.463 | 2157.800 | summ_csd | 1 | 0.000 | 0.032 | 31.679 | summ_csd | 10 | 0.000 | 0.013 | 764.339 | summ_csd | 100 | 0.000 | 0.101 | 994.085 | summ_csd | 1000 | 0.000 | 1.034 | 966.809 | summ_mime | 1 | 0.000 | 0.022 | 44.910 | summ_mime | 10 | 0.000 | 0.013 | 766.225 | summ_mime | 100 | 0.000 | 0.123 | 815.993 | summ_mime | 1000 | 0.000 | 1.329 | 752.570 | sngl_unmodeled_v | 1 | 0.000 | 0.006 | 180.021 | sngl_unmodeled_v | 10 | 0.000 | 0.006 | 1636.929 | sngl_unmodeled_v | 100 | 0.000 | 0.036 | 2815.799 | sngl_unmodeled_v | 1000 | 0.000 | 0.634 | 1576.449 | coinc_sngl | 1 | 0.000 | 0.057 | 17.655 | coinc_sngl | 10 | 0.000 | 0.060 | 166.625 | coinc_sngl | 100 | 0.000 | 0.147 | 680.318 | coinc_sngl | 1000 | 0.000 | 1.061 | 942.214 | search_summvars | 1 | 0.000 | 0.005 | 214.773 | search_summvars | 10 | 0.000 | 0.005 | 2051.307 | search_summvars | 100 | 0.000 | 0.031 | 3218.642 | search_summvars | 1000 | 0.000 | 0.307 | 3255.113 | waveburst_mime | 1 | 0.000 | 0.018 | 54.561 | waveburst_mime | 10 | 0.000 | 0.006 | 1732.181 | waveburst_mime | 100 | 0.000 | 0.071 | 1405.485 | waveburst_mime | 1000 | 0.000 | 0.647 | 1545.457 | sngl_transdata | 1 | 0.000 | 0.019 | 51.427 | sngl_transdata | 10 | 0.000 | 0.010 | 1020.934 | sngl_transdata | 100 | 0.000 | 0.075 | 1339.709 | sngl_transdata | 1000 | 0.000 | 0.760 | 1315.250 | sngl_mime | 1 | 0.000 | 0.023 | 42.746 | sngl_mime | 10 | 0.000 | 0.009 | 1096.264 | sngl_mime | 100 | 0.000 | 0.084 | 1186.830 | sngl_mime | 1000 | 0.000 | 0.811 | 1233.755 | sngl_datasource | 1 | 0.000 | 0.004 | 237.476 | sngl_datasource | 10 | 0.000 | 0.005 | 2025.452 | sngl_datasource | 100 | 0.000 | 0.030 | 3376.679 | sngl_datasource | 1000 | 0.000 | 0.305 | 3279.914 |
|---|
Summary: