ldas-wa Database ldas_tst Insertion Rates
| Test Period | October 31 2001 14:21:32 | |
|---|---|---|
| Input data | Ilwd with dimensions 1,10,100,1000 | |
| Platform | SunOS ldas 5.8 Generic_108528-07 sun4u sparc SUNW,Ultra-4 Memory: 4096M real, 3189M free, 275M swap in use, 2704M 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.149 | 6.709 | process | 10 | 0.020 | 0.024 | 409.517 | process | 100 | 0.020 | 0.106 | 940.619 | process | 1000 | 0.280 | 0.661 | 1513.384 | runlist | 1 | 0.000 | 0.010 | 100.644 | runlist | 10 | 0.000 | 0.013 | 766.812 | runlist | 100 | 0.020 | 0.053 | 1890.788 | runlist | 1000 | 0.060 | 0.293 | 3411.863 | process_params | 1 | 0.020 | 0.026 | 39.015 | process_params | 10 | 0.020 | 0.030 | 337.393 | process_params | 100 | 0.010 | 0.051 | 1950.192 | process_params | 1000 | 0.090 | 0.369 | 2706.748 | frameset_chanlist | 1 | 0.020 | 0.015 | 67.227 | frameset_chanlist | 10 | 0.010 | 0.020 | 504.032 | frameset_chanlist | 100 | 0.030 | 0.056 | 1793.625 | frameset_chanlist | 1000 | 0.170 | 0.471 | 2121.273 | frameset_writer | 1 | 0.010 | 0.013 | 79.968 | frameset_writer | 10 | 0.010 | 0.018 | 564.493 | frameset_writer | 100 | 0.030 | 0.084 | 1193.930 | frameset_writer | 1000 | 0.100 | 0.525 | 1906.232 | segment_definer | 1 | 0.010 | 0.013 | 79.058 | segment_definer | 10 | 0.010 | 0.019 | 531.293 | segment_definer | 100 | 0.020 | 0.065 | 1535.768 | segment_definer | 1000 | 0.120 | 0.479 | 2086.080 | filter | 1 | 0.010 | 0.016 | 63.416 | filter | 10 | 0.010 | 0.023 | 431.220 | filter | 100 | 0.020 | 0.066 | 1506.024 | filter | 1000 | 0.180 | 0.535 | 1870.795 | frameset | 1 | 0.010 | 0.018 | 55.816 | frameset | 10 | 0.010 | 0.024 | 414.233 | frameset | 100 | 0.020 | 0.057 | 1754.571 | frameset | 1000 | 0.120 | 0.455 | 2195.833 | segment | 1 | 0.010 | 0.012 | 82.399 | segment | 10 | 0.010 | 0.019 | 540.249 | segment | 100 | 0.020 | 0.060 | 1656.260 | segment | 1000 | 0.060 | 0.449 | 2226.914 | filter_params | 1 | 0.010 | 0.015 | 67.372 | filter_params | 10 | 0.020 | 0.022 | 462.663 | filter_params | 100 | 0.020 | 0.054 | 1837.830 | filter_params | 1000 | 0.110 | 0.443 | 2256.684 | gds_trigger | 1 | 0.020 | 0.026 | 38.716 | gds_trigger | 10 | 0.020 | 0.032 | 310.135 | gds_trigger | 100 | 0.040 | 0.108 | 929.696 | gds_trigger | 1000 | 0.260 | 0.930 | 1074.771 | sngl_inspiral | 1 | 0.030 | 0.028 | 36.221 | sngl_inspiral | 10 | 0.030 | 0.039 | 258.973 | sngl_inspiral | 100 | 0.050 | 0.124 | 806.855 | sngl_inspiral | 1000 | 0.300 | 1.044 | 957.854 | sngl_burst | 1 | 0.020 | 0.021 | 48.086 | sngl_burst | 10 | 0.030 | 0.029 | 345.793 | sngl_burst | 100 | 0.030 | 0.082 | 1222.912 | sngl_burst | 1000 | 0.220 | 0.700 | 1429.468 | sngl_ringdown | 1 | 0.010 | 0.021 | 48.246 | sngl_ringdown | 10 | 0.020 | 0.029 | 347.488 | sngl_ringdown | 100 | 0.030 | 0.082 | 1212.312 | sngl_ringdown | 1000 | 0.220 | 0.706 | 1417.103 | sngl_unmodeled | 1 | 0.030 | 0.036 | 27.568 | sngl_unmodeled | 10 | 0.020 | 0.029 | 342.936 | sngl_unmodeled | 100 | 0.040 | 0.223 | 448.117 | sngl_unmodeled | 1000 | 0.230 | 0.823 | 1215.736 | sngl_dperiodic | 1 | 0.020 | 0.024 | 40.917 | sngl_dperiodic | 10 | 0.020 | 0.033 | 307.182 | sngl_dperiodic | 100 | 0.040 | 0.087 | 1154.734 | sngl_dperiodic | 1000 | 0.250 | 0.748 | 1336.136 | multi_inspiral | 1 | 0.030 | 0.030 | 33.669 | multi_inspiral | 10 | 0.030 | 0.040 | 248.979 | multi_inspiral | 100 | 0.030 | 0.110 | 907.762 | multi_inspiral | 1000 | 0.310 | 0.995 | 1004.739 | multi_burst | 1 | 0.020 | 0.025 | 39.741 | multi_burst | 10 | 0.010 | 0.030 | 328.580 | multi_burst | 100 | 0.040 | 0.081 | 1227.807 | multi_burst | 1000 | 0.230 | 0.665 | 1504.180 | frameset_loc | 1 | 0.000 | 0.009 | 105.552 | frameset_loc | 10 | 0.010 | 0.022 | 446.309 | frameset_loc | 100 | 0.020 | 0.063 | 1593.372 | frameset_loc | 1000 | 0.110 | 0.473 | 2114.688 | summ_value | 1 | 0.010 | 0.017 | 59.259 | summ_value | 10 | 0.030 | 0.039 | 258.144 | summ_value | 100 | 0.050 | 0.094 | 1061.143 | summ_value | 1000 | 0.160 | 0.643 | 1554.412 | summ_statistics | 1 | 0.020 | 0.020 | 49.346 | summ_statistics | 10 | 0.010 | 0.029 | 340.321 | summ_statistics | 100 | 0.030 | 0.091 | 1103.887 | summ_statistics | 1000 | 0.170 | 0.749 | 1335.154 | summ_spectrum | 1 | 0.020 | 0.032 | 31.713 | summ_spectrum | 10 | 0.010 | 0.056 | 179.443 | summ_spectrum | 100 | 0.040 | 0.374 | 267.560 | summ_spectrum | 1000 | 0.400 | 3.223 | 310.270 | summ_comment | 1 | 0.020 | 0.019 | 52.312 | summ_comment | 10 | 0.000 | 0.028 | 358.551 | summ_comment | 100 | 0.030 | 0.095 | 1056.993 | summ_comment | 1000 | 0.240 | 0.768 | 1301.788 | summ_csd | 1 | 0.010 | 0.022 | 45.057 | summ_csd | 10 | 0.020 | 0.054 | 185.367 | summ_csd | 100 | 0.040 | 0.370 | 270.251 | summ_csd | 1000 | 0.280 | 3.092 | 323.415 | summ_mime | 1 | 0.020 | 0.025 | 40.211 | summ_mime | 10 | 0.020 | 0.052 | 192.201 | summ_mime | 100 | 0.050 | 0.389 | 256.834 | summ_mime | 1000 | 0.340 | 3.270 | 305.810 | sngl_unmodeled_v | 1 | 0.010 | 0.015 | 67.218 | sngl_unmodeled_v | 10 | 0.010 | 0.020 | 504.439 | sngl_unmodeled_v | 100 | 0.020 | 0.056 | 1799.241 | sngl_unmodeled_v | 1000 | 0.080 | 0.462 | 2165.834 | coinc_sngl | 1 | 0.040 | 0.053 | 19.022 | coinc_sngl | 10 | 0.050 | 0.068 | 146.192 | coinc_sngl | 100 | 0.110 | 0.209 | 479.442 | coinc_sngl | 1000 | 0.660 | 1.836 | 544.662 | sngl_transdata | 1 | 0.010 | 0.022 | 46.305 | sngl_transdata | 10 | 0.020 | 0.046 | 218.871 | sngl_transdata | 100 | 0.040 | 0.345 | 290.109 | sngl_transdata | 1000 | 0.320 | 2.790 | 358.423 | sngl_mime | 1 | 0.010 | 0.023 | 44.043 | sngl_mime | 10 | 0.020 | 0.044 | 226.439 | sngl_mime | 100 | 0.050 | 0.366 | 273.456 | sngl_mime | 1000 | 0.360 | 3.069 | 325.839 | sngl_datasource | 1 | 0.030 | 0.031 | 32.379 | sngl_datasource | 10 | 0.030 | 0.038 | 263.685 | sngl_datasource | 100 | 0.040 | 0.072 | 1387.598 | sngl_datasource | 1000 | 0.150 | 0.463 | 2161.573 |
|---|
Summary: