ldas-wa Database lho_test Insertion Rates
Test Period January 16 2001 18:38:39
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.8 Generic_108528-03 sun4u sparc SUNW,Ultra-4
Memory: 4096M real, 3557M free, 190M swap in use, 3189M swap free
LDAS software ldas-0.0.13, 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.066 15.149
process 10 0.070 0.122 82.244
process 100 0.380 0.747 133.821
process 1000 3.460 6.526 153.233
process_params 1 0.050 0.137 7.286
process_params 10 0.050 0.101 98.563
process_params 100 0.270 0.467 214.136
process_params 1000 2.440 3.131 319.387
frameset_chanlist 1 0.040 0.074 13.466
frameset_chanlist 10 0.040 0.112 89.419
frameset_chanlist 100 0.140 0.320 312.474
frameset_chanlist 1000 1.200 2.003 499.251
frameset_writer 1 0.030 0.070 14.345
frameset_writer 10 0.050 0.081 123.192
frameset_writer 100 0.310 0.602 166.109
frameset_writer 1000 2.930 5.654 176.866
segment_definer 1 0.030 0.066 15.208
segment_definer 10 0.060 0.104 96.473
segment_definer 100 0.250 0.465 214.922
segment_definer 1000 2.300 4.796 208.507
filter 1 0.010 0.066 15.200
filter 10 0.050 0.117 85.286
filter 100 0.190 0.461 217.018
filter 1000 1.630 3.916 255.363
frameset 1 0.050 0.121 8.255
frameset 10 0.080 0.148 67.758
frameset 100 0.240 0.389 257.216
frameset 1000 2.020 3.189 313.578
segment 1 0.030 0.062 16.185
segment 10 0.040 0.063 159.875
segment 100 0.130 0.238 420.057
segment 1000 1.070 2.098 476.644
filter_params 1 0.030 0.075 13.390
filter_params 10 0.040 0.102 97.750
filter_params 100 0.260 0.408 244.902
filter_params 1000 2.460 3.255 307.220
gds_trigger 1 0.030 0.101 9.867
gds_trigger 10 0.070 0.206 48.548
gds_trigger 100 0.340 1.115 89.686
gds_trigger 1000 3.350 12.779 78.253
sngl_inspiral 1 0.050 0.086 11.687
sngl_inspiral 10 0.060 0.151 66.230
sngl_inspiral 100 0.240 0.430 232.390
sngl_inspiral 1000 2.130 3.941 253.743
sngl_burst 1 0.030 0.077 13.022
sngl_burst 10 0.040 0.082 121.923
sngl_burst 100 0.190 0.406 246.488
sngl_burst 1000 1.700 3.611 276.932
sngl_ringdown 1 0.040 0.084 11.858
sngl_ringdown 10 0.050 0.105 95.537
sngl_ringdown 100 0.200 0.388 257.969
sngl_ringdown 1000 1.710 3.876 257.998
sngl_unmodeled 1 0.040 0.100 10.048
sngl_unmodeled 10 0.070 0.140 71.658
sngl_unmodeled 100 0.310 0.559 178.777
sngl_unmodeled 1000 2.730 4.850 206.186
sngl_dperiodic 1 0.040 0.086 11.665
sngl_dperiodic 10 0.050 0.164 60.925
sngl_dperiodic 100 0.270 0.529 188.976
sngl_dperiodic 1000 2.240 4.440 225.225
multi_inspiral 1 0.030 0.083 12.103
multi_inspiral 10 0.050 0.090 111.307
multi_inspiral 100 0.220 0.437 228.592
multi_inspiral 1000 1.760 3.811 262.398
multi_burst 1 0.030 0.074 13.546
multi_burst 10 0.060 0.113 88.637
multi_burst 100 0.200 0.437 228.614
multi_burst 1000 1.720 3.595 278.164
frameset_loc 1 0.050 0.103 9.720
frameset_loc 10 0.060 0.151 66.138
frameset_loc 100 0.320 0.590 169.509
frameset_loc 1000 3.020 4.813 207.771
summ_value 1 0.050 0.087 11.499
summ_value 10 0.070 0.144 69.517
summ_value 100 0.370 0.621 161.115
summ_value 1000 3.280 5.592 178.827
summ_statistics 1 0.040 0.088 11.410
summ_statistics 10 0.060 0.141 70.755
summ_statistics 100 0.290 0.623 160.539
summ_statistics 1000 2.670 6.066 164.853
summ_spectrum 1 0.040 0.136 7.361
summ_spectrum 10 0.070 0.411 24.310
summ_spectrum 100 0.500 4.701 21.272
summ_spectrum 1000 4.330 42.725 23.406
summ_comment 1 0.040 0.096 10.460
summ_comment 10 0.090 0.123 80.997
summ_comment 100 0.450 0.606 164.987
summ_comment 1000 4.130 5.515 181.324
sngl_transdata 1 0.020 0.428 2.336
sngl_transdata 10 0.070 0.390 25.667
sngl_transdata 100 0.500 4.477 22.336
sngl_transdata 1000 4.640 40.073 24.954
sngl_unmodeled_v 1 0.020 0.065 15.371
sngl_unmodeled_v 10 0.040 0.115 87.116
sngl_unmodeled_v 100 0.170 0.350 285.412
sngl_unmodeled_v 1000 1.510 3.139 318.573
coinc_sngl 1 0.060 0.132 7.572
coinc_sngl 10 0.080 0.199 50.246
coinc_sngl 100 0.470 1.009 99.108
coinc_sngl 1000 4.320 10.178 98.251
sngl_datasource 1 0.040 0.098 10.222
sngl_datasource 10 0.050 0.077 129.114
sngl_datasource 100 0.290 0.414 241.407
sngl_datasource 1000 2.530 3.200 312.500

Summary: