LDAS LHO Database (lho_test) Insertion Rates
Test Period June 29 2000 15:18:41
Input data Ilwd with dimensions 1,10,100,1000
Platform metaserver.ligo-wa.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.114 8.809
process 10 0.060 0.096 104.179
process 100 0.330 0.550 181.786
process 1000 3.200 6.213 160.953
process_params 1 0.030 0.442 2.260
process_params 10 0.060 0.067 149.873
process_params 100 0.240 0.327 305.687
process_params 1000 2.100 2.729 366.435
frameset_chanlist 1 0.020 0.103 9.669
frameset_chanlist 10 0.050 0.060 167.384
frameset_chanlist 100 0.130 0.332 301.600
frameset_chanlist 1000 1.080 3.790 263.852
frameset_writer 1 0.040 0.079 12.734
frameset_writer 10 0.060 0.074 135.750
frameset_writer 100 0.280 0.492 203.249
frameset_writer 1000 2.550 4.307 232.180
segment_definer 1 0.030 0.077 12.911
segment_definer 10 0.050 0.079 127.278
segment_definer 100 0.230 0.386 258.806
segment_definer 1000 2.030 3.705 269.906
filter 1 0.040 0.084 11.838
filter 10 0.040 0.082 122.630
filter 100 0.180 0.441 227.011
filter 1000 1.430 4.761 210.040
frameset 1 0.010 0.559 1.789
frameset 10 0.060 0.117 85.663
frameset 100 0.210 0.381 262.619
frameset 1000 1.760 2.670 374.532
segment 1 0.040 0.099 10.116
segment 10 0.040 0.200 49.997
segment 100 0.130 0.234 427.987
segment 1000 0.890 1.559 641.437
filter_params 1 0.030 0.076 13.150
filter_params 10 0.060 0.076 130.738
filter_params 100 0.250 0.332 301.191
filter_params 1000 2.090 2.803 356.761
gds_trigger 1 0.050 0.228 4.392
gds_trigger 10 0.080 0.123 81.091
gds_trigger 100 0.330 0.714 139.987
gds_trigger 1000 3.050 14.620 68.399
sngl_inspiral 1 0.060 0.128 7.835
sngl_inspiral 10 0.060 0.094 106.864
sngl_inspiral 100 0.200 0.489 204.400
sngl_inspiral 1000 1.570 5.350 186.916
sngl_burst 1 0.040 0.114 8.773
sngl_burst 10 0.050 0.087 114.917
sngl_burst 100 0.180 0.459 218.035
sngl_burst 1000 1.550 5.023 199.084
sngl_ringdown 1 0.050 0.127 7.902
sngl_ringdown 10 0.070 0.096 104.077
sngl_ringdown 100 0.200 0.452 221.177
sngl_ringdown 1000 1.530 5.278 189.466
sngl_unmodeled 1 0.050 0.104 9.634
sngl_unmodeled 10 0.070 0.091 110.161
sngl_unmodeled 100 0.240 0.511 195.614
sngl_unmodeled 1000 1.970 5.872 170.300
sngl_dperiodic 1 0.050 0.108 9.259
sngl_dperiodic 10 0.060 0.111 90.281
sngl_dperiodic 100 0.240 0.530 188.614
sngl_dperiodic 1000 2.030 6.285 159.109
multi_inspiral 1 0.050 0.097 10.264
multi_inspiral 10 0.060 0.080 124.468
multi_inspiral 100 0.200 0.479 208.793
multi_inspiral 1000 1.650 5.542 180.440
multi_burst 1 0.040 0.072 13.861
multi_burst 10 0.050 0.085 118.007
multi_burst 100 0.200 0.461 216.933
multi_burst 1000 1.580 5.225 191.388
frameset_loc 1 0.040 1.464 0.683
frameset_loc 10 0.060 0.107 93.327
frameset_loc 100 0.300 0.593 168.697
frameset_loc 1000 2.700 7.273 137.495
summ_value 1 0.050 0.198 5.043
summ_value 10 0.070 0.118 84.630
summ_value 100 0.330 0.582 171.965
summ_value 1000 2.900 5.591 178.859
summ_statistics 1 0.050 0.278 3.592
summ_statistics 10 0.080 0.111 90.351
summ_statistics 100 0.280 0.587 170.424
summ_statistics 1000 2.320 5.582 179.147
summ_spectrum 1 0.040 0.218 4.587
summ_spectrum 10 0.050 0.244 41.022
summ_spectrum 100 0.440 2.331 42.900
summ_spectrum 1000 4.060 19.927 50.183
summ_comment 1 0.050 0.189 5.285
summ_comment 10 0.080 0.133 74.952
summ_comment 100 0.400 0.659 151.832
summ_comment 1000 3.660 7.546 132.521
sngl_transdata 1 0.020 0.104 9.608
sngl_transdata 10 0.070 0.214 46.788
sngl_transdata 100 0.500 2.230 44.843
sngl_transdata 1000 4.610 17.511 57.107
sngl_unmodeled_v 1 0.030 0.150 6.667
sngl_unmodeled_v 10 0.050 0.079 127.363
sngl_unmodeled_v 100 0.180 0.732 136.576
sngl_unmodeled_v 1000 1.290 2.478 403.551
coinc_sngl 1 0.050 0.251 3.982
coinc_sngl 10 0.090 0.180 55.560
coinc_sngl 100 0.440 0.995 100.455
coinc_sngl 1000 3.870 10.368 96.451
sngl_datasource 1 0.020 0.873 1.146
sngl_datasource 10 0.050 0.084 119.372
sngl_datasource 100 0.260 0.319 313.233
sngl_datasource 1000 2.180 2.710 369.004

Summary: