ldas-wa Database lho_test Insertion Rates
Test Period February 22 2001 15:19:00
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.8 Generic_108528-05 sun4u sparc SUNW,Ultra-4
Memory: 4096M real, 3457M free, 156M swap in use, 3195M swap free
LDAS software ldas-0.0.14, 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.030 0.073 13.747
process 10 0.080 0.163 61.506
process 100 0.350 0.667 149.843
process 1000 3.380 6.243 160.179
process_params 1 0.040 0.101 9.894
process_params 10 0.040 0.074 134.358
process_params 100 0.260 0.375 266.658
process_params 1000 2.430 3.112 321.337
frameset_chanlist 1 0.030 0.068 14.789
frameset_chanlist 10 0.040 0.110 91.019
frameset_chanlist 100 0.170 0.663 150.860
frameset_chanlist 1000 1.170 1.968 508.130
frameset_writer 1 0.020 0.065 15.324
frameset_writer 10 0.060 0.119 84.104
frameset_writer 100 0.320 0.561 178.368
frameset_writer 1000 2.910 5.404 185.048
segment_definer 1 0.020 0.084 11.890
segment_definer 10 0.040 0.137 72.893
segment_definer 100 0.260 0.467 214.055
segment_definer 1000 2.290 4.540 220.264
filter 1 0.020 0.080 12.446
filter 10 0.040 0.071 141.529
filter 100 0.190 0.453 220.911
filter 1000 1.560 3.653 273.748
frameset 1 0.030 0.096 10.392
frameset 10 0.050 0.101 99.001
frameset 100 0.220 0.386 259.004
frameset 1000 2.040 3.206 311.915
segment 1 0.020 0.062 16.173
segment 10 0.040 0.060 166.174
segment 100 0.130 0.257 388.923
segment 1000 1.040 1.921 520.562
filter_params 1 0.020 0.059 16.877
filter_params 10 0.050 0.102 97.743
filter_params 100 0.270 0.404 247.573
filter_params 1000 2.430 3.142 318.269
gds_trigger 1 0.030 0.083 12.057
gds_trigger 10 0.050 0.199 50.260
gds_trigger 100 0.360 0.714 140.037
gds_trigger 1000 3.330 12.397 80.665
sngl_inspiral 1 0.050 0.102 9.761
sngl_inspiral 10 0.060 0.155 64.480
sngl_inspiral 100 0.240 0.706 141.575
sngl_inspiral 1000 2.090 4.481 223.164
sngl_burst 1 0.040 0.081 12.337
sngl_burst 10 0.050 0.083 120.804
sngl_burst 100 0.200 0.380 263.307
sngl_burst 1000 1.650 3.424 292.056
sngl_ringdown 1 0.030 0.107 9.319
sngl_ringdown 10 0.050 0.103 97.006
sngl_ringdown 100 0.230 0.407 245.523
sngl_ringdown 1000 1.650 4.036 247.770
sngl_unmodeled 1 0.030 0.113 8.870
sngl_unmodeled 10 0.060 0.139 72.165
sngl_unmodeled 100 0.290 0.529 189.068
sngl_unmodeled 1000 2.670 4.952 201.939
sngl_dperiodic 1 0.050 0.079 12.705
sngl_dperiodic 10 0.060 0.131 76.227
sngl_dperiodic 100 0.270 0.478 209.318
sngl_dperiodic 1000 2.170 4.578 218.436
multi_inspiral 1 0.030 0.079 12.581
multi_inspiral 10 0.060 0.087 115.223
multi_inspiral 100 0.220 0.486 205.933
multi_inspiral 1000 1.740 3.981 251.193
multi_burst 1 0.050 0.082 12.209
multi_burst 10 0.060 0.104 96.162
multi_burst 100 0.210 0.420 238.260
multi_burst 1000 1.680 3.791 263.783
frameset_loc 1 0.040 0.100 9.951
frameset_loc 10 0.050 0.152 65.600
frameset_loc 100 0.330 0.636 157.129
frameset_loc 1000 2.990 4.693 213.083
summ_value 1 0.050 0.113 8.866
summ_value 10 0.050 0.144 69.343
summ_value 100 0.360 0.713 140.250
summ_value 1000 3.250 5.462 183.083
summ_statistics 1 0.030 0.080 12.536
summ_statistics 10 0.060 0.142 70.455
summ_statistics 100 0.290 0.643 155.505
summ_statistics 1000 2.600 5.704 175.316
summ_spectrum 1 0.030 0.098 10.213
summ_spectrum 10 0.060 0.393 25.466
summ_spectrum 100 0.460 4.608 21.701
summ_spectrum 1000 4.160 41.010 24.384
summ_comment 1 0.030 0.095 10.546
summ_comment 10 0.080 0.155 64.334
summ_comment 100 0.420 0.576 173.523
summ_comment 1000 4.080 5.037 198.531
sngl_transdata 1 0.020 0.090 11.125
sngl_transdata 10 0.080 0.404 24.741
sngl_transdata 100 0.490 4.458 22.432
sngl_transdata 1000 4.590 40.908 24.445
sngl_unmodeled_v 1 0.010 0.064 15.628
sngl_unmodeled_v 10 0.070 0.148 67.425
sngl_unmodeled_v 100 0.170 0.370 270.010
sngl_unmodeled_v 1000 1.530 3.173 315.159
coinc_sngl 1 0.040 0.134 7.491
coinc_sngl 10 0.080 0.213 46.901
coinc_sngl 100 0.470 0.980 102.001
coinc_sngl 1000 4.320 9.873 101.286
sngl_datasource 1 0.040 0.083 12.068
sngl_datasource 10 0.050 0.128 77.998
sngl_datasource 100 0.280 0.365 273.640
sngl_datasource 1000 2.500 3.204 312.110

Summary: