ldas-dev Database dev_1 Insertion Rates
| Test Period | October 27 2003 15:40:33 | |
|---|---|---|
| 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, 6981M free, 147M swap in use, 6282M swap free |
|
| LDAS software | ldas-0.8.8, 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.004 | 234.903 | process | 10 | 0.000 | 0.001 | 6811.711 | process | 100 | 0.000 | 0.022 | 4591.600 | process | 1000 | 0.000 | 0.060 | 16805.310 | runlist | 1 | 0.000 | 0.002 | 404.699 | runlist | 10 | 0.000 | 0.001 | 7413.063 | runlist | 100 | 0.000 | 0.017 | 5735.918 | runlist | 1000 | 0.000 | 0.034 | 29442.073 | calib_info | 1 | 0.000 | 0.015 | 68.648 | calib_info | 10 | 0.000 | 0.034 | 292.415 | calib_info | 100 | 0.000 | 0.317 | 315.954 | calib_info | 1000 | 0.000 | 1.577 | 634.284 | sim_type | 1 | 0.000 | 0.067 | 14.991 | sim_type | 10 | 0.000 | 0.004 | 2359.598 | sim_type | 100 | 0.000 | 0.044 | 2298.269 | sim_type | 1000 | 0.000 | 1.578 | 633.669 | process_params | 1 | 0.000 | 0.004 | 274.802 | process_params | 10 | 0.000 | 0.001 | 7722.187 | process_params | 100 | 0.000 | 0.009 | 11495.653 | process_params | 1000 | 0.000 | 0.209 | 4781.966 | frameset_chanlist | 1 | 0.000 | 0.004 | 232.719 | frameset_chanlist | 10 | 0.000 | 0.001 | 7473.786 | frameset_chanlist | 100 | 0.000 | 0.005 | 21546.802 | frameset_chanlist | 1000 | 0.000 | 0.065 | 15281.851 | frameset_writer | 1 | 0.000 | 0.006 | 177.996 | frameset_writer | 10 | 0.000 | 0.001 | 6944.782 | frameset_writer | 100 | 0.000 | 0.021 | 4696.820 | frameset_writer | 1000 | 0.000 | 0.107 | 9309.947 | segment_definer | 1 | 0.000 | 0.004 | 285.142 | segment_definer | 10 | 0.000 | 0.002 | 6097.710 | segment_definer | 100 | 0.000 | 0.035 | 2855.185 | segment_definer | 1000 | 0.000 | 0.107 | 9329.838 | filter | 1 | 0.000 | 0.004 | 234.083 | filter | 10 | 0.000 | 0.002 | 4066.611 | filter | 100 | 0.000 | 0.007 | 14496.851 | filter | 1000 | 0.000 | 0.073 | 13650.573 | search_summary | 1 | 0.000 | 0.004 | 240.327 | search_summary | 10 | 0.000 | 0.002 | 5684.887 | search_summary | 100 | 0.000 | 0.035 | 2873.142 | search_summary | 1000 | 0.000 | 0.173 | 5767.412 | sim_inst | 1 | 0.000 | 0.004 | 283.370 | sim_inst | 10 | 0.000 | 0.002 | 4407.170 | sim_inst | 100 | 0.000 | 0.007 | 14192.490 | sim_inst | 1000 | 0.000 | 0.050 | 19834.540 | sim_type_params | 1 | 0.000 | 0.003 | 299.668 | sim_type_params | 10 | 0.000 | 0.001 | 8976.580 | sim_type_params | 100 | 0.000 | 0.004 | 24390.422 | sim_type_params | 1000 | 0.000 | 0.049 | 20381.542 | frameset | 1 | 0.000 | 0.005 | 207.341 | frameset | 10 | 0.000 | 0.002 | 6064.208 | frameset | 100 | 0.000 | 0.009 | 11508.738 | frameset | 1000 | 0.000 | 0.092 | 10821.820 | segment | 1 | 0.000 | 0.004 | 249.438 | segment | 10 | 0.000 | 0.002 | 5042.737 | segment | 100 | 0.000 | 0.307 | 326.058 | segment | 1000 | 0.000 | 0.100 | 9964.129 | filter_params | 1 | 0.000 | 0.004 | 256.541 | filter_params | 10 | 0.000 | 0.002 | 6684.671 | filter_params | 100 | 0.000 | 0.369 | 271.256 | filter_params | 1000 | 0.000 | 0.141 | 7067.188 | gds_trigger | 1 | 0.000 | 0.005 | 206.058 | gds_trigger | 10 | 0.000 | 0.002 | 4050.321 | gds_trigger | 100 | 0.000 | 2.498 | 40.032 | gds_trigger | 1000 | 0.000 | 0.279 | 3586.582 | sngl_inspiral | 1 | 0.000 | 0.005 | 191.350 | sngl_inspiral | 10 | 0.000 | 0.002 | 4478.220 | sngl_inspiral | 100 | 0.000 | 0.030 | 3353.904 | sngl_inspiral | 1000 | 0.000 | 0.484 | 2067.803 | sngl_burst | 1 | 0.000 | 0.004 | 227.741 | sngl_burst | 10 | 0.000 | 0.002 | 5827.438 | sngl_burst | 100 | 0.000 | 0.009 | 10554.101 | sngl_burst | 1000 | 0.000 | 0.110 | 9110.206 | sngl_block | 1 | 0.000 | 0.005 | 202.467 | sngl_block | 10 | 0.000 | 0.002 | 4409.249 | sngl_block | 100 | 0.000 | 0.036 | 2800.571 | sngl_block | 1000 | 0.000 | 0.121 | 8269.520 | sngl_ringdown | 1 | 0.000 | 0.004 | 222.421 | sngl_ringdown | 10 | 0.000 | 0.002 | 5675.659 | sngl_ringdown | 100 | 0.000 | 0.012 | 8455.230 | sngl_ringdown | 1000 | 0.000 | 0.258 | 3882.907 | sngl_unmodeled | 1 | 0.000 | 0.007 | 153.705 | sngl_unmodeled | 10 | 0.000 | 0.002 | 4492.363 | sngl_unmodeled | 100 | 0.000 | 0.018 | 5603.214 | sngl_unmodeled | 1000 | 0.000 | 0.161 | 6197.246 | sngl_dperiodic | 1 | 0.000 | 0.005 | 211.817 | sngl_dperiodic | 10 | 0.000 | 0.002 | 4061.887 | sngl_dperiodic | 100 | 0.000 | 0.018 | 5700.604 | sngl_dperiodic | 1000 | 0.000 | 0.205 | 4867.033 | multi_inspiral | 1 | 0.000 | 0.005 | 188.644 | multi_inspiral | 10 | 0.000 | 0.002 | 4492.363 | multi_inspiral | 100 | 0.000 | 0.082 | 1225.535 | multi_inspiral | 1000 | 0.000 | 0.479 | 2087.949 | multi_burst | 1 | 0.000 | 0.005 | 210.262 | multi_burst | 10 | 0.000 | 0.002 | 4672.788 | multi_burst | 100 | 0.000 | 0.028 | 3575.259 | multi_burst | 1000 | 0.000 | 0.145 | 6878.383 | exttrig_search | 1 | 0.000 | 0.006 | 172.890 | exttrig_search | 10 | 0.000 | 0.002 | 5429.176 | exttrig_search | 100 | 0.000 | 0.024 | 4089.996 | exttrig_search | 1000 | 0.000 | 0.280 | 3576.691 | sim_inst_params | 1 | 0.000 | 0.003 | 300.753 | sim_inst_params | 10 | 0.000 | 0.001 | 10559.673 | sim_inst_params | 100 | 0.000 | 0.003 | 29568.565 | sim_inst_params | 1000 | 0.000 | 0.031 | 31771.348 | waveburst | 1 | 0.000 | 0.006 | 172.712 | waveburst | 10 | 0.000 | 0.002 | 5146.707 | waveburst | 100 | 0.000 | 0.118 | 844.160 | waveburst | 1000 | 0.000 | 0.218 | 4585.852 | frameset_loc | 1 | 0.000 | 0.009 | 116.958 | frameset_loc | 10 | 0.000 | 0.002 | 6527.074 | frameset_loc | 100 | 0.000 | 0.084 | 1194.685 | frameset_loc | 1000 | 0.000 | 0.091 | 10970.446 | summ_value | 1 | 0.000 | 0.005 | 196.037 | summ_value | 10 | 0.000 | 0.010 | 1041.339 | summ_value | 100 | 0.000 | 0.039 | 2569.050 | summ_value | 1000 | 0.000 | 0.389 | 2573.936 | summ_statistics | 1 | 0.000 | 0.006 | 176.863 | summ_statistics | 10 | 0.000 | 0.002 | 4108.430 | summ_statistics | 100 | 0.000 | 0.093 | 1076.809 | summ_statistics | 1000 | 0.000 | 0.461 | 2167.218 | summ_spectrum | 1 | 0.000 | 0.017 | 59.421 | summ_spectrum | 10 | 0.000 | 0.025 | 400.721 | summ_spectrum | 100 | 0.000 | 2.568 | 38.943 | summ_spectrum | 1000 | 0.000 | 1.723 | 580.427 | summ_comment | 1 | 0.000 | 0.005 | 197.082 | summ_comment | 10 | 0.000 | 0.002 | 5580.513 | summ_comment | 100 | 0.000 | 0.063 | 1583.083 | summ_comment | 1000 | 0.000 | 0.162 | 6162.569 | summ_csd | 1 | 0.000 | 0.013 | 79.157 | summ_csd | 10 | 0.000 | 0.031 | 322.904 | summ_csd | 100 | 0.000 | 2.344 | 42.658 | summ_csd | 1000 | 0.000 | 1.862 | 536.950 | summ_mime | 1 | 0.000 | 0.015 | 65.509 | summ_mime | 10 | 0.000 | 0.027 | 372.717 | summ_mime | 100 | 0.000 | 3.153 | 31.720 | summ_mime | 1000 | 0.000 | 2.040 | 490.220 | sngl_unmodeled_v | 1 | 0.000 | 0.004 | 233.920 | sngl_unmodeled_v | 10 | 0.000 | 0.002 | 6226.689 | sngl_unmodeled_v | 100 | 0.000 | 0.039 | 2559.902 | sngl_unmodeled_v | 1000 | 0.000 | 0.254 | 3929.613 | coinc_sngl | 1 | 0.000 | 0.013 | 75.540 | coinc_sngl | 10 | 0.000 | 0.005 | 2027.164 | coinc_sngl | 100 | 0.000 | 0.066 | 1524.578 | coinc_sngl | 1000 | 0.000 | 0.319 | 3135.769 | search_summvars | 1 | 0.000 | 0.005 | 206.271 | search_summvars | 10 | 0.000 | 0.001 | 8038.908 | search_summvars | 100 | 0.000 | 0.007 | 14624.245 | search_summvars | 1000 | 0.000 | 0.046 | 21771.788 | waveburst_mime | 1 | 0.000 | 0.014 | 70.711 | waveburst_mime | 10 | 0.000 | 0.041 | 243.220 | waveburst_mime | 100 | 0.000 | 5.097 | 19.619 | waveburst_mime | 1000 | 0.000 | 3.174 | 315.054 | sngl_transdata | 1 | 0.000 | 0.006 | 174.001 | sngl_transdata | 10 | 0.000 | 0.033 | 299.410 | sngl_transdata | 100 | 0.000 | 0.329 | 303.854 | sngl_transdata | 1000 | 0.000 | 1.566 | 638.688 | sngl_mime | 1 | 0.000 | 0.009 | 114.442 | sngl_mime | 10 | 0.000 | 0.028 | 357.231 | sngl_mime | 100 | 0.000 | 0.323 | 309.573 | sngl_mime | 1000 | 0.000 | 1.520 | 657.968 | sngl_datasource | 1 | 0.000 | 0.004 | 257.794 | sngl_datasource | 10 | 0.000 | 0.002 | 6565.902 | sngl_datasource | 100 | 0.000 | 0.009 | 11392.143 | sngl_datasource | 1000 | 0.000 | 0.068 | 14675.022 |
|---|
Summary: