LDAS CIT Database Insertion Rates
Test Period March 28th, 2000
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.10, 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.090 0.186 5.369
process 10 0.080 0.097 102.866
process 100 0.350 0.480 208.510
process 1000 2.860 5.061 197.578
process_params 1 0.060 0.081 12.350
process_params 10 0.080 0.094 106.194
process_params 100 0.250 0.316 316.266
process_params 1000 1.940 2.395 417.546
frameset_chanlist 1 0.080 0.071 14.022
frameset_chanlist 10 0.070 0.084 119.513
frameset_chanlist 100 0.160 0.315 317.303
frameset_chanlist 1000 1.100 3.157 316.795
frameset_writer 1 0.070 0.079 12.653
frameset_writer 10 0.100 0.104 96.011
frameset_writer 100 0.300 0.415 240.685
frameset_writer 1000 2.370 3.505 285.291
segment_definer 1 0.060 0.083 11.983
segment_definer 10 0.090 0.090 111.310
segment_definer 100 0.240 0.358 279.669
segment_definer 1000 1.890 3.081 324.618
filter 1 0.060 0.084 11.973
filter 10 0.100 0.100 99.988
filter 100 0.220 0.428 233.819
filter 1000 1.450 3.829 261.191
frameset 1 0.080 0.106 9.458
frameset 10 0.090 0.106 94.530
frameset 100 0.230 0.306 326.522
frameset 1000 1.670 2.982 335.323
segment 1 0.070 0.075 13.267
segment 10 0.070 0.101 98.972
segment 100 0.150 0.187 534.928
segment 1000 0.890 1.329 752.332
filter_params 1 0.060 0.080 12.443
filter_params 10 0.090 0.090 110.525
filter_params 100 0.250 0.303 330.218
filter_params 1000 1.960 2.377 420.707
gds_trigger 1 0.090 0.096 10.412
gds_trigger 10 0.100 0.126 79.127
gds_trigger 100 0.350 0.606 164.993
gds_trigger 1000 3.630 10.339 96.717
sngl_inspiral 1 0.090 0.102 9.787
sngl_inspiral 10 0.100 0.114 87.369
sngl_inspiral 100 0.240 0.435 229.645
sngl_inspiral 1000 1.590 4.331 230.908
sngl_burst 1 0.080 0.099 10.141
sngl_burst 10 0.090 0.116 85.999
sngl_burst 100 0.230 0.422 237.216
sngl_burst 1000 1.540 4.240 235.861
sngl_ringdown 1 0.080 0.095 10.484
sngl_ringdown 10 0.090 0.117 85.190
sngl_ringdown 100 0.240 0.402 248.780
sngl_ringdown 1000 1.570 4.174 239.566
sngl_unmodeled 1 0.090 0.096 10.379
sngl_unmodeled 10 0.100 0.108 92.879
sngl_unmodeled 100 0.270 0.453 220.558
sngl_unmodeled 1000 1.880 4.650 215.052
sngl_dperiodic 1 0.100 0.095 10.533
sngl_dperiodic 10 0.090 0.132 76.000
sngl_dperiodic 100 0.270 0.471 212.306
sngl_dperiodic 1000 1.950 4.859 205.819
multi_inspiral 1 0.110 0.101 9.943
multi_inspiral 10 0.120 0.125 79.938
multi_inspiral 100 0.240 0.434 230.523
multi_inspiral 1000 1.640 4.523 221.082
multi_burst 1 0.090 0.096 10.453
multi_burst 10 0.090 0.113 88.313
multi_burst 100 0.240 0.428 233.687
multi_burst 1000 1.590 4.423 226.095
frameset_loc 1 0.070 0.211 4.728
frameset_loc 10 0.090 0.099 100.717
frameset_loc 100 0.300 0.438 228.131
frameset_loc 1000 2.420 5.707 175.217
summ_value 1 0.100 0.112 8.904
summ_value 10 0.110 0.121 82.328
summ_value 100 0.360 0.524 190.706
summ_value 1000 2.720 4.629 216.017
summ_statistics 1 0.100 0.147 6.784
summ_statistics 10 0.110 0.153 65.285
summ_statistics 100 0.300 0.499 200.390
summ_statistics 1000 2.180 5.377 185.975
summ_spectrum 1 0.080 0.127 7.891
summ_spectrum 10 0.110 0.235 42.483
summ_spectrum 100 0.970 2.889 34.615
summ_spectrum 1000 7.460 26.254 38.090
summ_comment 1 0.080 0.191 5.234
summ_comment 10 0.110 0.134 74.701
summ_comment 100 0.410 0.619 161.612
summ_comment 1000 3.430 5.991 166.931
sngl_transdata 1 0.050 0.134 7.437
sngl_transdata 10 0.100 0.181 55.366
sngl_transdata 100 0.930 2.079 48.111
sngl_transdata 1000 7.630 27.530 36.324
sngl_unmodeled_v 1 0.060 0.122 8.210
sngl_unmodeled_v 10 0.090 0.091 109.994
sngl_unmodeled_v 100 0.170 0.284 351.862
sngl_unmodeled_v 1000 1.230 2.026 493.703
coinc_sngl 1 0.100 0.146 6.830
coinc_sngl 10 0.120 0.196 51.115
coinc_sngl 100 0.460 0.842 118.712
coinc_sngl 1000 3.720 8.374 119.415

Summary: