LDAS CIT Database Insertion Rates
Test Period June 29 2000 09:56:56
Input data Ilwd with dimensions 1,10,100,1000
Platform metaserver.ligo.caltech.edu (SUN 450, 4 CPUs, RAM=1024MB, Solaris 2.7)
LDAS software ldas-0.0.11, IBM DB2 6.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.042 24.018
process 10 0.060 0.070 142.943
process 100 0.260 0.407 245.819
process 1000 2.360 4.783 209.074
process_params 1 0.050 0.083 12.042
process_params 10 0.040 0.061 164.439
process_params 100 0.180 0.227 440.463
process_params 1000 1.580 1.972 507.099
frameset_chanlist 1 0.030 0.048 20.662
frameset_chanlist 10 0.040 0.055 180.245
frameset_chanlist 100 0.100 0.235 425.911
frameset_chanlist 1000 0.840 2.889 346.141
frameset_writer 1 0.030 0.046 21.850
frameset_writer 10 0.030 0.068 147.403
frameset_writer 100 0.210 0.344 290.321
frameset_writer 1000 1.910 3.051 327.761
segment_definer 1 0.020 0.031 32.483
segment_definer 10 0.040 0.063 159.218
segment_definer 100 0.170 0.275 363.683
segment_definer 1000 1.530 2.583 387.147
filter 1 0.030 0.034 29.017
filter 10 0.040 0.056 178.836
filter 100 0.130 0.304 329.346
filter 1000 1.100 3.638 274.876
frameset 1 0.020 0.048 21.010
frameset 10 0.040 0.054 185.525
frameset 100 0.160 0.213 468.617
frameset 1000 1.350 2.407 415.455
segment 1 0.020 0.034 28.990
segment 10 0.030 0.056 178.936
segment 100 0.090 0.131 761.510
segment 1000 0.710 1.087 919.963
filter_params 1 0.030 0.046 21.624
filter_params 10 0.040 0.052 192.485
filter_params 100 0.180 0.230 435.462
filter_params 1000 1.590 1.934 517.063
gds_trigger 1 0.030 0.077 12.984
gds_trigger 10 0.050 0.074 134.268
gds_trigger 100 0.240 0.522 191.578
gds_trigger 1000 2.350 7.601 131.562
sngl_inspiral 1 0.030 0.054 18.663
sngl_inspiral 10 0.050 0.079 125.819
sngl_inspiral 100 0.160 0.340 294.334
sngl_inspiral 1000 1.240 3.926 254.712
sngl_burst 1 0.030 0.045 22.154
sngl_burst 10 0.040 0.056 179.327
sngl_burst 100 0.140 0.333 300.704
sngl_burst 1000 1.180 3.856 259.336
sngl_ringdown 1 0.040 0.039 25.412
sngl_ringdown 10 0.050 0.074 135.918
sngl_ringdown 100 0.150 0.323 309.245
sngl_ringdown 1000 1.200 3.949 253.229
sngl_unmodeled 1 0.020 0.049 20.279
sngl_unmodeled 10 0.040 0.066 151.625
sngl_unmodeled 100 0.170 0.376 265.616
sngl_unmodeled 1000 1.480 4.284 233.427
sngl_dperiodic 1 0.030 0.046 21.859
sngl_dperiodic 10 0.050 0.072 138.723
sngl_dperiodic 100 0.190 0.382 261.619
sngl_dperiodic 1000 1.540 4.372 228.728
multi_inspiral 1 0.040 0.056 17.906
multi_inspiral 10 0.050 0.080 125.023
multi_inspiral 100 0.150 0.350 285.489
multi_inspiral 1000 1.260 4.071 245.640
multi_burst 1 0.030 0.046 21.961
multi_burst 10 0.050 0.060 166.362
multi_burst 100 0.150 0.345 290.275
multi_burst 1000 1.200 3.947 253.357
frameset_loc 1 0.030 0.049 20.479
frameset_loc 10 0.030 0.062 160.759
frameset_loc 100 0.230 0.326 306.890
frameset_loc 1000 2.050 5.330 187.617
summ_value 1 0.030 0.037 27.015
summ_value 10 0.050 0.079 126.971
summ_value 100 0.240 0.359 278.319
summ_value 1000 2.190 3.301 302.939
summ_statistics 1 0.050 0.059 16.811
summ_statistics 10 0.050 0.074 136.029
summ_statistics 100 0.220 0.367 272.628
summ_statistics 1000 1.800 3.400 294.118
summ_spectrum 1 0.040 0.080 12.547
summ_spectrum 10 0.070 0.152 65.804
summ_spectrum 100 0.340 1.351 74.019
summ_spectrum 1000 3.060 12.543 79.726
summ_comment 1 0.040 0.078 12.884
summ_comment 10 0.050 0.076 132.349
summ_comment 100 0.310 0.439 227.933
summ_comment 1000 2.750 5.009 199.641
sngl_transdata 1 0.030 0.050 20.038
sngl_transdata 10 0.050 0.132 75.958
sngl_transdata 100 0.370 1.293 77.340
sngl_transdata 1000 3.290 11.073 90.310
sngl_unmodeled_v 1 0.030 0.038 26.589
sngl_unmodeled_v 10 0.040 0.056 178.952
sngl_unmodeled_v 100 0.120 0.204 489.783
sngl_unmodeled_v 1000 0.980 2.123 471.032
coinc_sngl 1 0.050 0.063 15.928
coinc_sngl 10 0.070 0.117 85.618
coinc_sngl 100 0.330 0.674 148.336
coinc_sngl 1000 2.950 7.281 137.344
sngl_datasource 1 0.030 0.044 22.553
sngl_datasource 10 0.040 0.065 154.109
sngl_datasource 100 0.200 0.231 432.410
sngl_datasource 1000 1.660 1.900 526.316

Summary: