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: