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: