ldas-dev Database cit_test Insertion Rates
Test Period January 25 2001 22:27:08
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.8 Generic_108528-03 sun4u sparc SUNW,Ultra-5_10
Memory: 256M real, 66M free, 142M swap in use, 1057M swap free
LDAS software ldas-0.0.13, 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.122 8.229
process 10 0.070 0.122 82.161
process 100 0.370 0.623 160.601
process 1000 3.450 4.897 204.207
process_params 1 0.040 0.309 3.240
process_params 10 0.050 0.106 94.338
process_params 100 0.270 0.417 239.704
process_params 1000 2.430 3.455 289.436
frameset_chanlist 1 0.020 0.069 14.408
frameset_chanlist 10 0.040 0.073 136.396
frameset_chanlist 100 0.150 0.305 327.642
frameset_chanlist 1000 1.180 2.097 476.872
frameset_writer 1 0.020 0.082 12.264
frameset_writer 10 0.040 0.108 92.388
frameset_writer 100 0.320 0.622 160.870
frameset_writer 1000 2.930 5.221 191.534
segment_definer 1 0.030 0.088 11.366
segment_definer 10 0.050 0.126 79.474
segment_definer 100 0.260 0.502 199.032
segment_definer 1000 2.320 4.671 214.087
filter 1 0.010 0.072 13.898
filter 10 0.040 0.128 77.901
filter 100 0.190 0.402 248.964
filter 1000 1.640 3.289 304.044
frameset 1 0.040 0.112 8.953
frameset 10 0.050 0.128 78.182
frameset 100 0.230 0.429 232.912
frameset 1000 2.020 3.321 301.114
segment 1 0.020 0.082 12.238
segment 10 0.050 0.063 158.647
segment 100 0.130 0.269 371.169
segment 1000 1.060 1.966 508.647
filter_params 1 0.020 0.074 13.548
filter_params 10 0.060 0.104 95.889
filter_params 100 0.260 0.395 253.005
filter_params 1000 2.460 3.415 292.826
gds_trigger 1 0.040 0.159 6.287
gds_trigger 10 0.070 0.145 68.885
gds_trigger 100 0.350 0.727 137.627
gds_trigger 1000 3.310 11.048 90.514
sngl_inspiral 1 0.040 0.133 7.522
sngl_inspiral 10 0.070 0.181 55.365
sngl_inspiral 100 0.240 0.459 217.636
sngl_inspiral 1000 2.100 4.102 243.784
sngl_burst 1 0.030 0.136 7.341
sngl_burst 10 0.060 0.088 113.541
sngl_burst 100 0.210 0.411 243.252
sngl_burst 1000 1.700 3.450 289.855
sngl_ringdown 1 0.020 0.113 8.883
sngl_ringdown 10 0.060 0.116 86.098
sngl_ringdown 100 0.200 0.411 243.594
sngl_ringdown 1000 1.690 5.026 198.965
sngl_unmodeled 1 0.030 0.133 7.544
sngl_unmodeled 10 0.060 0.147 68.131
sngl_unmodeled 100 0.300 0.701 142.743
sngl_unmodeled 1000 2.700 4.936 202.593
sngl_dperiodic 1 0.030 0.242 4.141
sngl_dperiodic 10 0.060 0.101 99.127
sngl_dperiodic 100 0.260 0.502 199.151
sngl_dperiodic 1000 2.230 4.930 202.840
multi_inspiral 1 0.050 0.120 8.342
multi_inspiral 10 0.060 0.114 87.540
multi_inspiral 100 0.210 0.459 217.642
multi_inspiral 1000 1.770 4.455 224.467
multi_burst 1 0.060 0.116 8.586
multi_burst 10 0.050 0.139 71.823
multi_burst 100 0.190 0.441 226.814
multi_burst 1000 1.740 3.917 255.297
frameset_loc 1 0.020 0.147 6.795
frameset_loc 10 0.050 0.109 92.122
frameset_loc 100 0.340 0.636 157.323
frameset_loc 1000 3.060 5.053 197.902
summ_value 1 0.030 0.143 6.998
summ_value 10 0.070 0.143 70.113
summ_value 100 0.360 0.648 154.315
summ_value 1000 3.310 6.060 165.017
summ_statistics 1 0.070 0.141 7.088
summ_statistics 10 0.070 0.139 71.911
summ_statistics 100 0.300 0.741 134.909
summ_statistics 1000 2.620 6.322 158.178
summ_spectrum 1 0.040 0.184 5.441
summ_spectrum 10 0.080 0.329 30.392
summ_spectrum 100 0.460 4.915 20.346
summ_spectrum 1000 4.190 42.238 23.675
summ_comment 1 0.050 0.130 7.669
summ_comment 10 0.080 0.136 73.321
summ_comment 100 0.440 0.629 158.928
summ_comment 1000 4.110 5.511 181.455
sngl_transdata 1 0.030 0.129 7.782
sngl_transdata 10 0.070 0.405 24.672
sngl_transdata 100 0.500 4.521 22.119
sngl_transdata 1000 4.620 40.954 24.418
sngl_unmodeled_v 1 0.030 0.111 9.033
sngl_unmodeled_v 10 0.040 0.119 84.203
sngl_unmodeled_v 100 0.180 0.390 256.633
sngl_unmodeled_v 1000 1.530 3.385 295.421
coinc_sngl 1 0.040 0.164 6.109
coinc_sngl 10 0.090 0.209 47.803
coinc_sngl 100 0.490 1.012 98.814
coinc_sngl 1000 4.340 11.149 89.694
sngl_datasource 1 0.030 0.070 14.385
sngl_datasource 10 0.060 0.139 72.074
sngl_datasource 100 0.270 0.406 246.595
sngl_datasource 1000 2.500 3.448 290.023

Summary: