ldas-wa Database lho_test Insertion Rates
Test Period April 09 2001 14:42:20
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, 3616M free, 72M swap in use, 3301M swap free
LDAS software ldas-0.0.16, 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.050 0.100 10.002
process 10 0.070 0.118 84.553
process 100 0.350 0.566 176.730
process 1000 3.410 4.883 204.792
process_params 1 0.060 0.117 8.538
process_params 10 0.080 0.127 78.908
process_params 100 0.300 0.443 225.786
process_params 1000 2.460 3.182 314.268
frameset_chanlist 1 0.060 0.098 10.235
frameset_chanlist 10 0.070 0.104 96.219
frameset_chanlist 100 0.160 0.342 292.060
frameset_chanlist 1000 1.170 1.870 534.759
frameset_writer 1 0.060 0.128 7.794
frameset_writer 10 0.090 0.138 72.331
frameset_writer 100 0.350 0.628 159.234
frameset_writer 1000 3.010 5.221 191.534
segment_definer 1 0.060 0.121 8.278
segment_definer 10 0.070 0.151 66.040
segment_definer 100 0.270 0.495 201.844
segment_definer 1000 2.350 4.480 223.214
filter 1 0.060 0.096 10.424
filter 10 0.070 0.148 67.477
filter 100 0.200 0.402 248.691
filter 1000 1.620 3.170 315.457
frameset 1 0.070 0.143 7.017
frameset 10 0.070 0.161 62.044
frameset 100 0.260 0.421 237.308
frameset 1000 2.060 3.128 319.693
segment 1 0.050 0.101 9.909
segment 10 0.060 0.092 108.661
segment 100 0.150 0.309 323.869
segment 1000 1.060 2.032 492.126
filter_params 1 0.060 0.102 9.768
filter_params 10 0.080 0.128 77.849
filter_params 100 0.300 0.424 235.955
filter_params 1000 2.470 3.301 302.939
gds_trigger 1 0.070 0.119 8.403
gds_trigger 10 0.110 0.187 53.449
gds_trigger 100 0.370 0.778 128.617
gds_trigger 1000 3.300 12.230 81.766
sngl_inspiral 1 0.060 0.117 8.523
sngl_inspiral 10 0.070 0.111 90.265
sngl_inspiral 100 0.250 0.491 203.714
sngl_inspiral 1000 2.100 4.376 228.519
sngl_burst 1 0.050 0.108 9.282
sngl_burst 10 0.060 0.117 85.288
sngl_burst 100 0.190 0.395 253.347
sngl_burst 1000 1.680 3.533 283.046
sngl_ringdown 1 0.070 0.103 9.733
sngl_ringdown 10 0.090 0.152 65.737
sngl_ringdown 100 0.230 0.421 237.635
sngl_ringdown 1000 1.710 3.653 273.748
sngl_unmodeled 1 0.060 0.127 7.860
sngl_unmodeled 10 0.080 0.156 64.295
sngl_unmodeled 100 0.320 0.538 185.795
sngl_unmodeled 1000 2.690 4.811 207.857
sngl_dperiodic 1 0.060 0.166 6.030
sngl_dperiodic 10 0.080 0.101 99.261
sngl_dperiodic 100 0.270 0.475 210.615
sngl_dperiodic 1000 2.200 4.597 217.533
multi_inspiral 1 0.070 0.121 8.247
multi_inspiral 10 0.080 0.131 76.133
multi_inspiral 100 0.230 0.453 220.554
multi_inspiral 1000 1.750 3.989 250.689
multi_burst 1 0.080 0.107 9.312
multi_burst 10 0.080 0.154 64.808
multi_burst 100 0.240 0.462 216.570
multi_burst 1000 1.750 3.821 261.712
frameset_loc 1 0.040 0.167 5.972
frameset_loc 10 0.060 0.130 77.011
frameset_loc 100 0.320 0.613 163.210
frameset_loc 1000 3.030 4.780 209.205
summ_value 1 0.050 0.102 9.851
summ_value 10 0.080 0.151 66.422
summ_value 100 0.380 0.583 171.550
summ_value 1000 3.300 5.653 176.897
summ_statistics 1 0.060 0.113 8.835
summ_statistics 10 0.090 0.173 57.693
summ_statistics 100 0.330 0.633 157.975
summ_statistics 1000 2.680 5.673 176.274
summ_spectrum 1 0.060 0.204 4.900
summ_spectrum 10 0.080 0.453 22.074
summ_spectrum 100 0.500 4.701 21.272
summ_spectrum 1000 4.170 41.176 24.286
summ_comment 1 0.080 0.134 7.468
summ_comment 10 0.120 0.180 55.428
summ_comment 100 0.460 0.600 166.668
summ_comment 1000 4.100 5.110 195.695
summ_csd 1 0.070 0.159 6.295
summ_csd 10 0.100 0.422 23.715
summ_csd 100 0.530 4.821 20.743
summ_csd 1000 4.470 43.939 22.759
sngl_transdata 1 0.040 0.127 7.849
sngl_transdata 10 0.080 0.430 23.280
sngl_transdata 100 0.560 4.575 21.858
sngl_transdata 1000 4.630 39.598 25.254
sngl_unmodeled_v 1 0.040 0.106 9.428
sngl_unmodeled_v 10 0.060 0.081 123.245
sngl_unmodeled_v 100 0.190 0.353 283.075
sngl_unmodeled_v 1000 1.530 3.322 301.023
coinc_sngl 1 0.050 0.161 6.204
coinc_sngl 10 0.100 0.194 51.618
coinc_sngl 100 0.490 0.981 101.967
coinc_sngl 1000 4.290 10.464 95.566
sngl_datasource 1 0.040 0.099 10.087
sngl_datasource 10 0.090 0.110 90.631
sngl_datasource 100 0.320 0.410 244.183
sngl_datasource 1000 2.590 3.329 300.391

Summary: