ldas-test Database cprod_t Insertion Rates
Test Period March 07 2001 11:52:17
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, 3173M free, 223M swap in use, 2992M swap free
LDAS software ldas-0.0.15, 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.059 16.888
process 10 0.060 0.106 94.111
process 100 0.350 0.471 212.234
process 1000 3.340 4.287 233.263
process_params 1 0.040 0.079 12.609
process_params 10 0.050 0.080 125.047
process_params 100 0.260 0.331 301.860
process_params 1000 2.410 2.821 354.484
frameset_chanlist 1 0.010 0.069 14.438
frameset_chanlist 10 0.040 0.069 144.592
frameset_chanlist 100 0.140 0.270 370.306
frameset_chanlist 1000 1.140 1.596 626.566
frameset_writer 1 0.020 0.064 15.641
frameset_writer 10 0.050 0.094 106.317
frameset_writer 100 0.330 0.483 207.120
frameset_writer 1000 2.880 4.296 232.775
segment_definer 1 0.030 0.067 14.906
segment_definer 10 0.050 0.101 98.810
segment_definer 100 0.240 0.368 271.962
segment_definer 1000 2.270 3.600 277.778
filter 1 0.030 0.061 16.379
filter 10 0.050 0.091 109.807
filter 100 0.170 0.267 374.320
filter 1000 1.580 2.654 376.790
frameset 1 0.030 0.071 14.001
frameset 10 0.050 0.084 118.677
frameset 100 0.230 0.347 288.208
frameset 1000 2.000 2.824 354.108
segment 1 0.020 0.062 16.072
segment 10 0.050 0.073 136.153
segment 100 0.120 0.224 446.692
segment 1000 1.020 1.460 684.932
filter_params 1 0.020 0.064 15.712
filter_params 10 0.080 0.111 90.396
filter_params 100 0.270 0.351 285.077
filter_params 1000 2.400 2.777 360.101
gds_trigger 1 0.030 0.097 10.341
gds_trigger 10 0.070 0.108 92.848
gds_trigger 100 0.350 0.552 181.231
gds_trigger 1000 3.290 7.571 132.083
sngl_inspiral 1 0.040 0.080 12.569
sngl_inspiral 10 0.060 0.103 97.060
sngl_inspiral 100 0.250 0.530 188.656
sngl_inspiral 1000 2.100 3.376 296.209
sngl_burst 1 0.040 0.074 13.576
sngl_burst 10 0.060 0.099 101.018
sngl_burst 100 0.190 0.320 312.716
sngl_burst 1000 1.630 2.651 377.216
sngl_ringdown 1 0.030 0.071 14.025
sngl_ringdown 10 0.060 0.076 131.270
sngl_ringdown 100 0.200 0.319 313.197
sngl_ringdown 1000 1.660 3.001 333.222
sngl_unmodeled 1 0.020 0.069 14.425
sngl_unmodeled 10 0.060 0.110 90.558
sngl_unmodeled 100 0.290 0.448 223.112
sngl_unmodeled 1000 2.610 3.995 250.313
sngl_dperiodic 1 0.050 0.079 12.688
sngl_dperiodic 10 0.060 0.116 86.526
sngl_dperiodic 100 0.260 0.437 229.055
sngl_dperiodic 1000 2.130 3.516 284.414
multi_inspiral 1 0.050 0.077 12.989
multi_inspiral 10 0.050 0.111 89.858
multi_inspiral 100 0.200 0.381 262.359
multi_inspiral 1000 1.710 3.124 320.102
multi_burst 1 0.030 0.071 14.124
multi_burst 10 0.050 0.083 120.530
multi_burst 100 0.210 0.351 284.579
multi_burst 1000 1.660 3.018 331.345
frameset_loc 1 0.030 0.059 16.896
frameset_loc 10 0.050 0.097 103.439
frameset_loc 100 0.320 0.448 222.977
frameset_loc 1000 2.960 4.108 243.427
summ_value 1 0.030 0.070 14.201
summ_value 10 0.080 0.119 83.715
summ_value 100 0.350 0.491 203.625
summ_value 1000 3.220 4.644 215.332
summ_statistics 1 0.030 0.078 12.819
summ_statistics 10 0.060 0.108 92.520
summ_statistics 100 0.300 0.468 213.479
summ_statistics 1000 2.590 4.285 233.372
summ_spectrum 1 0.040 0.090 11.158
summ_spectrum 10 0.060 0.218 45.896
summ_spectrum 100 0.460 2.342 42.699
summ_spectrum 1000 4.160 19.770 50.582
summ_comment 1 0.020 0.076 13.204
summ_comment 10 0.080 0.130 77.194
summ_comment 100 0.430 0.533 187.728
summ_comment 1000 4.080 4.769 209.688
summ_csd 1 0.030 0.097 10.343
summ_csd 10 0.080 0.236 42.291
summ_csd 100 0.480 2.285 43.764
summ_csd 1000 4.530 20.356 49.126
sngl_transdata 1 0.030 0.065 15.422
sngl_transdata 10 0.060 0.180 55.406
sngl_transdata 100 0.490 2.116 47.259
sngl_transdata 1000 4.690 19.114 52.318
sngl_unmodeled_v 1 0.030 0.066 15.084
sngl_unmodeled_v 10 0.040 0.086 115.734
sngl_unmodeled_v 100 0.150 0.284 352.294
sngl_unmodeled_v 1000 1.480 2.438 410.172
coinc_sngl 1 0.060 0.127 7.897
coinc_sngl 10 0.090 0.167 59.860
coinc_sngl 100 0.460 0.787 127.120
coinc_sngl 1000 4.200 7.345 136.147
sngl_datasource 1 0.040 0.068 14.712
sngl_datasource 10 0.060 0.103 97.297
sngl_datasource 100 0.280 0.331 301.709
sngl_datasource 1000 2.480 2.792 358.166

Summary: