Database ldas_tst Insertion Rates
| Test Period | October 18 2001 09:58:06 | |
|---|---|---|
| Input data | Ilwd with dimensions 1,10,100,1000 | |
| Platform | SunOS metaserver 5.8 Generic_108528-07 sun4u sparc SUNW,Ultra-4 Memory: 4096M real, 3232M free, 212M swap in use, 3129M swap free |
|
| LDAS software | ldas-0.0.21, 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.020 | 0.019 | 52.244 | process | 10 | 0.010 | 0.026 | 380.662 | process | 100 | 0.040 | 0.072 | 1381.521 | process | 1000 | 0.280 | 0.791 | 1264.223 | runlist | 1 | 0.010 | 0.009 | 107.619 | runlist | 10 | 0.010 | 0.014 | 733.460 | runlist | 100 | 0.010 | 0.086 | 1160.604 | runlist | 1000 | 0.060 | 0.213 | 4690.432 | process_params | 1 | 0.020 | 0.041 | 24.298 | process_params | 10 | 0.010 | 0.017 | 593.437 | process_params | 100 | 0.020 | 0.042 | 2379.253 | process_params | 1000 | 0.080 | 0.359 | 2784.344 | frameset_chanlist | 1 | 0.000 | 0.029 | 34.382 | frameset_chanlist | 10 | 0.010 | 0.022 | 446.947 | frameset_chanlist | 100 | 0.020 | 0.080 | 1248.065 | frameset_chanlist | 1000 | 0.170 | 0.422 | 2369.887 | frameset_writer | 1 | 0.010 | 0.024 | 41.069 | frameset_writer | 10 | 0.010 | 0.017 | 595.203 | frameset_writer | 100 | 0.020 | 0.062 | 1613.580 | frameset_writer | 1000 | 0.100 | 0.470 | 2128.013 | segment_definer | 1 | 0.010 | 0.024 | 41.360 | segment_definer | 10 | 0.000 | 0.018 | 545.881 | segment_definer | 100 | 0.020 | 0.057 | 1750.424 | segment_definer | 1000 | 0.090 | 0.443 | 2256.700 | filter | 1 | 0.010 | 0.029 | 35.066 | filter | 10 | 0.020 | 0.023 | 438.212 | filter | 100 | 0.040 | 0.063 | 1589.421 | filter | 1000 | 0.180 | 0.513 | 1948.725 | frameset | 1 | 0.010 | 0.033 | 29.948 | frameset | 10 | 0.020 | 0.023 | 434.160 | frameset | 100 | 0.020 | 0.061 | 1651.119 | frameset | 1000 | 0.120 | 0.440 | 2272.763 | segment | 1 | 0.010 | 0.025 | 39.970 | segment | 10 | 0.010 | 0.018 | 543.863 | segment | 100 | 0.020 | 0.061 | 1633.587 | segment | 1000 | 0.060 | 0.456 | 2192.540 | filter_params | 1 | 0.010 | 0.030 | 33.875 | filter_params | 10 | 0.010 | 0.022 | 464.188 | filter_params | 100 | 0.020 | 0.057 | 1764.727 | filter_params | 1000 | 0.120 | 0.440 | 2274.531 | gds_trigger | 1 | 0.020 | 0.041 | 24.107 | gds_trigger | 10 | 0.020 | 0.032 | 309.272 | gds_trigger | 100 | 0.040 | 0.102 | 976.620 | gds_trigger | 1000 | 0.290 | 0.919 | 1087.853 | sngl_inspiral | 1 | 0.030 | 0.050 | 20.182 | sngl_inspiral | 10 | 0.040 | 0.055 | 183.268 | sngl_inspiral | 100 | 0.040 | 0.120 | 835.541 | sngl_inspiral | 1000 | 0.300 | 1.053 | 949.668 | sngl_burst | 1 | 0.020 | 0.038 | 26.625 | sngl_burst | 10 | 0.020 | 0.030 | 338.719 | sngl_burst | 100 | 0.030 | 0.080 | 1253.856 | sngl_burst | 1000 | 0.250 | 0.698 | 1433.135 | sngl_ringdown | 1 | 0.010 | 0.038 | 26.643 | sngl_ringdown | 10 | 0.020 | 0.031 | 319.397 | sngl_ringdown | 100 | 0.040 | 0.080 | 1252.772 | sngl_ringdown | 1000 | 0.220 | 0.663 | 1508.107 | sngl_unmodeled | 1 | 0.020 | 0.041 | 24.181 | sngl_unmodeled | 10 | 0.020 | 0.029 | 341.542 | sngl_unmodeled | 100 | 0.040 | 0.102 | 983.932 | sngl_unmodeled | 1000 | 0.230 | 0.880 | 1136.560 | sngl_dperiodic | 1 | 0.020 | 0.041 | 24.202 | sngl_dperiodic | 10 | 0.000 | 0.033 | 304.776 | sngl_dperiodic | 100 | 0.040 | 0.089 | 1127.726 | sngl_dperiodic | 1000 | 0.260 | 0.739 | 1352.369 | multi_inspiral | 1 | 0.020 | 0.052 | 19.172 | multi_inspiral | 10 | 0.030 | 0.040 | 248.626 | multi_inspiral | 100 | 0.040 | 0.119 | 841.616 | multi_inspiral | 1000 | 0.320 | 1.016 | 984.252 | multi_burst | 1 | 0.030 | 0.040 | 24.717 | multi_burst | 10 | 0.020 | 0.031 | 323.488 | multi_burst | 100 | 0.040 | 0.083 | 1199.559 | multi_burst | 1000 | 0.210 | 0.727 | 1374.680 | frameset_loc | 1 | 0.010 | 0.024 | 42.256 | frameset_loc | 10 | 0.010 | 0.016 | 634.196 | frameset_loc | 100 | 0.020 | 0.056 | 1773.396 | frameset_loc | 1000 | 0.110 | 0.471 | 2122.714 | summ_value | 1 | 0.020 | 0.038 | 26.583 | summ_value | 10 | 0.010 | 0.027 | 364.073 | summ_value | 100 | 0.030 | 0.088 | 1130.301 | summ_value | 1000 | 0.160 | 0.735 | 1359.743 | summ_statistics | 1 | 0.020 | 0.044 | 22.597 | summ_statistics | 10 | 0.010 | 0.029 | 345.578 | summ_statistics | 100 | 0.030 | 0.093 | 1074.991 | summ_statistics | 1000 | 0.160 | 0.687 | 1454.821 | summ_spectrum | 1 | 0.010 | 0.048 | 21.003 | summ_spectrum | 10 | 0.010 | 0.049 | 205.491 | summ_spectrum | 100 | 0.040 | 0.374 | 267.242 | summ_spectrum | 1000 | 0.350 | 3.265 | 306.279 | summ_comment | 1 | 0.010 | 0.040 | 25.296 | summ_comment | 10 | 0.020 | 0.029 | 345.077 | summ_comment | 100 | 0.040 | 0.090 | 1105.375 | summ_comment | 1000 | 0.240 | 0.832 | 1201.998 | summ_csd | 1 | 0.010 | 0.044 | 22.912 | summ_csd | 10 | 0.010 | 0.046 | 215.443 | summ_csd | 100 | 0.030 | 0.340 | 294.283 | summ_csd | 1000 | 0.280 | 2.983 | 335.233 | summ_mime | 1 | 0.010 | 0.049 | 20.261 | summ_mime | 10 | 0.020 | 0.049 | 204.859 | summ_mime | 100 | 0.050 | 0.361 | 277.345 | summ_mime | 1000 | 0.360 | 3.256 | 307.125 | sngl_transdata | 1 | 0.010 | 0.038 | 26.303 | sngl_transdata | 10 | 0.020 | 0.044 | 227.822 | sngl_transdata | 100 | 0.040 | 0.314 | 318.227 | sngl_transdata | 1000 | 0.280 | 2.681 | 372.995 | sngl_unmodeled_v | 1 | 0.010 | 0.029 | 34.447 | sngl_unmodeled_v | 10 | 0.010 | 0.021 | 487.662 | sngl_unmodeled_v | 100 | 0.020 | 0.052 | 1914.169 | sngl_unmodeled_v | 1000 | 0.080 | 0.430 | 2326.079 | sngl_mime | 1 | 0.020 | 0.038 | 26.012 | sngl_mime | 10 | 0.010 | 0.048 | 208.260 | sngl_mime | 100 | 0.050 | 0.345 | 290.072 | sngl_mime | 1000 | 0.360 | 2.955 | 338.409 | coinc_sngl | 1 | 0.070 | 0.137 | 7.275 | coinc_sngl | 10 | 0.060 | 0.073 | 137.382 | coinc_sngl | 100 | 0.100 | 0.236 | 423.340 | coinc_sngl | 1000 | 0.670 | 2.002 | 499.500 | sngl_datasource | 1 | 0.030 | 0.041 | 24.539 | sngl_datasource | 10 | 0.030 | 0.037 | 268.053 | sngl_datasource | 100 | 0.030 | 0.071 | 1406.984 | sngl_datasource | 1000 | 0.150 | 0.427 | 2343.177 |
|---|
Summary: