ldas-dev Database cit_test Insertion Rates
| Test Period | August 16 2001 15:39:50 | |
|---|---|---|
| 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, 3474M free, 199M swap in use, 3171M swap free |
|
| LDAS software | ldas-0.0.20, 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.020 | 50.618 | process | 10 | 0.020 | 0.027 | 375.700 | process | 100 | 0.030 | 0.076 | 1317.072 | process | 1000 | 0.290 | 0.812 | 1232.225 | runlist | 1 | 0.010 | 0.010 | 97.466 | runlist | 10 | 0.010 | 0.014 | 698.422 | runlist | 100 | 0.010 | 0.039 | 2559.509 | runlist | 1000 | 0.060 | 0.251 | 3986.160 | process_params | 1 | 0.020 | 0.029 | 34.053 | process_params | 10 | 0.010 | 0.019 | 531.858 | process_params | 100 | 0.010 | 0.047 | 2137.346 | process_params | 1000 | 0.100 | 0.347 | 2878.402 | frameset_chanlist | 1 | 0.020 | 0.031 | 32.733 | frameset_chanlist | 10 | 0.010 | 0.024 | 411.370 | frameset_chanlist | 100 | 0.020 | 0.082 | 1222.569 | frameset_chanlist | 1000 | 0.170 | 0.433 | 2311.663 | frameset_writer | 1 | 0.010 | 0.051 | 19.599 | frameset_writer | 10 | 0.020 | 0.019 | 531.124 | frameset_writer | 100 | 0.020 | 0.076 | 1319.296 | frameset_writer | 1000 | 0.100 | 0.514 | 1943.937 | segment_definer | 1 | 0.010 | 0.026 | 38.601 | segment_definer | 10 | 0.010 | 0.024 | 422.940 | segment_definer | 100 | 0.020 | 0.057 | 1744.835 | segment_definer | 1000 | 0.080 | 0.481 | 2078.272 | filter | 1 | 0.020 | 0.032 | 31.481 | filter | 10 | 0.010 | 0.026 | 379.853 | filter | 100 | 0.020 | 0.072 | 1390.279 | filter | 1000 | 0.160 | 0.582 | 1718.086 | frameset | 1 | 0.010 | 0.049 | 20.377 | frameset | 10 | 0.010 | 0.023 | 441.755 | frameset | 100 | 0.020 | 0.066 | 1508.637 | frameset | 1000 | 0.110 | 0.417 | 2400.926 | segment | 1 | 0.020 | 0.027 | 37.350 | segment | 10 | 0.010 | 0.020 | 493.145 | segment | 100 | 0.010 | 0.078 | 1281.624 | segment | 1000 | 0.060 | 0.464 | 2153.404 | filter_params | 1 | 0.010 | 0.030 | 33.238 | filter_params | 10 | 0.020 | 0.042 | 240.085 | filter_params | 100 | 0.020 | 0.054 | 1837.627 | filter_params | 1000 | 0.100 | 0.451 | 2219.647 | gds_trigger | 1 | 0.030 | 0.082 | 12.142 | gds_trigger | 10 | 0.030 | 0.035 | 288.292 | gds_trigger | 100 | 0.040 | 0.121 | 824.171 | gds_trigger | 1000 | 0.270 | 0.929 | 1076.082 | sngl_inspiral | 1 | 0.020 | 0.053 | 18.943 | sngl_inspiral | 10 | 0.030 | 0.040 | 248.466 | sngl_inspiral | 100 | 0.060 | 0.110 | 908.521 | sngl_inspiral | 1000 | 0.300 | 1.131 | 884.173 | sngl_burst | 1 | 0.010 | 0.042 | 23.960 | sngl_burst | 10 | 0.030 | 0.030 | 329.305 | sngl_burst | 100 | 0.040 | 0.088 | 1140.797 | sngl_burst | 1000 | 0.220 | 0.659 | 1516.528 | sngl_ringdown | 1 | 0.020 | 0.041 | 24.533 | sngl_ringdown | 10 | 0.010 | 0.032 | 311.294 | sngl_ringdown | 100 | 0.040 | 0.094 | 1069.381 | sngl_ringdown | 1000 | 0.220 | 0.709 | 1409.449 | sngl_unmodeled | 1 | 0.020 | 0.041 | 24.617 | sngl_unmodeled | 10 | 0.020 | 0.031 | 320.821 | sngl_unmodeled | 100 | 0.040 | 0.108 | 925.592 | sngl_unmodeled | 1000 | 0.210 | 0.917 | 1090.509 | sngl_dperiodic | 1 | 0.020 | 0.070 | 14.342 | sngl_dperiodic | 10 | 0.020 | 0.034 | 292.946 | sngl_dperiodic | 100 | 0.040 | 0.094 | 1059.749 | sngl_dperiodic | 1000 | 0.250 | 0.752 | 1329.119 | multi_inspiral | 1 | 0.030 | 0.054 | 18.365 | multi_inspiral | 10 | 0.030 | 0.042 | 237.541 | multi_inspiral | 100 | 0.050 | 0.127 | 787.476 | multi_inspiral | 1000 | 0.290 | 1.153 | 867.303 | multi_burst | 1 | 0.020 | 0.040 | 24.951 | multi_burst | 10 | 0.020 | 0.032 | 315.946 | multi_burst | 100 | 0.040 | 0.087 | 1150.219 | multi_burst | 1000 | 0.220 | 0.756 | 1323.467 | frameset_loc | 1 | 0.000 | 0.041 | 24.392 | frameset_loc | 10 | 0.010 | 0.015 | 647.543 | frameset_loc | 100 | 0.020 | 0.067 | 1503.036 | frameset_loc | 1000 | 0.110 | 0.483 | 2068.599 | summ_value | 1 | 0.010 | 0.045 | 22.305 | summ_value | 10 | 0.020 | 0.028 | 361.978 | summ_value | 100 | 0.030 | 0.100 | 996.145 | summ_value | 1000 | 0.160 | 0.633 | 1578.627 | summ_statistics | 1 | 0.030 | 0.046 | 21.913 | summ_statistics | 10 | 0.020 | 0.031 | 322.966 | summ_statistics | 100 | 0.020 | 0.104 | 961.751 | summ_statistics | 1000 | 0.150 | 0.659 | 1517.805 | summ_spectrum | 1 | 0.010 | 0.046 | 21.877 | summ_spectrum | 10 | 0.020 | 0.044 | 226.127 | summ_spectrum | 100 | 0.040 | 0.367 | 272.281 | summ_spectrum | 1000 | 0.260 | 3.218 | 310.752 | summ_comment | 1 | 0.010 | 0.042 | 23.946 | summ_comment | 10 | 0.020 | 0.032 | 317.088 | summ_comment | 100 | 0.040 | 0.092 | 1082.989 | summ_comment | 1000 | 0.240 | 0.819 | 1220.731 | summ_csd | 1 | 0.020 | 0.069 | 14.533 | summ_csd | 10 | 0.020 | 0.057 | 176.090 | summ_csd | 100 | 0.040 | 0.426 | 234.483 | summ_csd | 1000 | 0.290 | 3.190 | 313.480 | summ_mime | 1 | 0.010 | 0.058 | 17.251 | summ_mime | 10 | 0.020 | 0.057 | 174.280 | summ_mime | 100 | 0.050 | 0.446 | 224.105 | summ_mime | 1000 | 0.390 | 3.318 | 301.386 | sngl_transdata | 1 | 0.020 | 0.047 | 21.186 | sngl_transdata | 10 | 0.020 | 0.053 | 189.563 | sngl_transdata | 100 | 0.040 | 0.373 | 267.842 | sngl_transdata | 1000 | 0.310 | 2.767 | 361.402 | sngl_unmodeled_v | 1 | 0.030 | 0.047 | 21.324 | sngl_unmodeled_v | 10 | 0.030 | 0.038 | 263.213 | sngl_unmodeled_v | 100 | 0.030 | 0.070 | 1436.286 | sngl_unmodeled_v | 1000 | 0.100 | 0.433 | 2310.285 | sngl_mime | 1 | 0.020 | 0.068 | 14.691 | sngl_mime | 10 | 0.010 | 0.064 | 156.265 | sngl_mime | 100 | 0.050 | 0.410 | 243.732 | sngl_mime | 1000 | 0.400 | 3.342 | 299.222 | coinc_sngl | 1 | 0.030 | 0.097 | 10.312 | coinc_sngl | 10 | 0.040 | 0.056 | 177.557 | coinc_sngl | 100 | 0.090 | 0.214 | 468.119 | coinc_sngl | 1000 | 0.660 | 1.831 | 546.150 | sngl_datasource | 1 | 0.010 | 0.047 | 21.412 | sngl_datasource | 10 | 0.010 | 0.023 | 436.243 | sngl_datasource | 100 | 0.020 | 0.061 | 1639.344 | sngl_datasource | 1000 | 0.150 | 0.543 | 1842.547 |
|---|
Summary: