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: