ldas-dev Database cit_test Insertion Rates
Test Period April 09 2001 12:41:25
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.8 Generic_108528-05 sun4u sparc SUNW,Ultra-5_10
Memory: 256M real, 29M free, 196M swap in use, 985M 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.095 10.521
process 10 0.070 0.081 123.399
process 100 0.390 0.668 149.658
process 1000 3.740 4.419 226.296
process_params 1 0.040 0.062 16.134
process_params 10 0.070 0.092 108.211
process_params 100 0.320 0.367 272.264
process_params 1000 2.680 3.155 316.957
frameset_chanlist 1 0.060 0.080 12.487
frameset_chanlist 10 0.070 0.079 126.910
frameset_chanlist 100 0.180 0.273 366.335
frameset_chanlist 1000 1.250 1.884 530.786
frameset_writer 1 0.050 0.117 8.529
frameset_writer 10 0.080 0.094 106.033
frameset_writer 100 0.380 0.471 212.264
frameset_writer 1000 3.230 3.939 253.872
segment_definer 1 0.050 0.078 12.779
segment_definer 10 0.080 0.089 112.029
segment_definer 100 0.300 0.427 234.132
segment_definer 1000 2.540 3.910 255.754
filter 1 0.050 0.089 11.267
filter 10 0.070 0.109 92.109
filter 100 0.210 0.367 272.488
filter 1000 1.730 2.313 432.339
frameset 1 0.070 0.102 9.765
frameset 10 0.080 0.096 104.236
frameset 100 0.280 0.340 294.308
frameset 1000 2.300 3.196 312.891
segment 1 0.050 0.081 12.347
segment 10 0.080 0.103 96.846
segment 100 0.160 0.244 410.334
segment 1000 1.160 1.596 626.566
filter_params 1 0.060 0.083 12.018
filter_params 10 0.070 0.091 110.084
filter_params 100 0.330 0.411 243.122
filter_params 1000 2.720 3.116 320.924
gds_trigger 1 0.070 0.105 9.563
gds_trigger 10 0.100 0.112 89.421
gds_trigger 100 0.420 0.534 187.188
gds_trigger 1000 3.610 5.548 180.245
sngl_inspiral 1 0.060 0.073 13.695
sngl_inspiral 10 0.080 0.102 98.206
sngl_inspiral 100 0.240 0.349 286.157
sngl_inspiral 1000 1.850 3.262 306.560
sngl_burst 1 0.060 0.099 10.083
sngl_burst 10 0.080 0.088 113.494
sngl_burst 100 0.240 0.301 332.387
sngl_burst 1000 1.840 2.547 392.619
sngl_ringdown 1 0.060 0.110 9.125
sngl_ringdown 10 0.080 0.096 104.057
sngl_ringdown 100 0.230 0.299 334.111
sngl_ringdown 1000 1.820 3.004 332.889
sngl_unmodeled 1 0.060 0.096 10.425
sngl_unmodeled 10 0.080 0.099 100.882
sngl_unmodeled 100 0.280 0.447 223.778
sngl_unmodeled 1000 2.360 3.403 293.858
sngl_dperiodic 1 0.060 0.093 10.712
sngl_dperiodic 10 0.090 0.098 102.154
sngl_dperiodic 100 0.280 0.395 252.862
sngl_dperiodic 1000 2.410 4.281 233.590
multi_inspiral 1 0.070 0.089 11.203
multi_inspiral 10 0.080 0.095 105.565
multi_inspiral 100 0.240 0.346 289.257
multi_inspiral 1000 1.920 3.024 330.688
multi_burst 1 0.070 0.089 11.240
multi_burst 10 0.090 0.101 99.030
multi_burst 100 0.250 0.319 313.006
multi_burst 1000 1.860 3.245 308.166
frameset_loc 1 0.040 0.079 12.647
frameset_loc 10 0.060 0.096 104.643
frameset_loc 100 0.350 0.502 199.248
frameset_loc 1000 3.310 4.071 245.640
summ_value 1 0.050 0.106 9.447
summ_value 10 0.080 0.095 104.985
summ_value 100 0.400 0.555 180.297
summ_value 1000 3.600 5.076 197.006
summ_statistics 1 0.060 0.119 8.375
summ_statistics 10 0.100 0.121 82.893
summ_statistics 100 0.360 0.505 197.980
summ_statistics 1000 2.870 3.842 260.281
summ_spectrum 1 0.060 0.182 5.496
summ_spectrum 10 0.100 0.165 60.621
summ_spectrum 100 0.520 1.168 85.616
summ_spectrum 1000 4.520 8.647 115.647
summ_comment 1 0.060 0.111 9.023
summ_comment 10 0.100 0.127 78.955
summ_comment 100 0.510 0.570 175.306
summ_comment 1000 4.440 5.309 188.359
summ_csd 1 0.070 0.145 6.891
summ_csd 10 0.110 0.177 56.543
summ_csd 100 0.570 1.353 73.910
summ_csd 1000 4.880 10.629 94.082
sngl_transdata 1 0.040 0.121 8.292
sngl_transdata 10 0.080 0.167 59.979
sngl_transdata 100 0.560 1.125 88.889
sngl_transdata 1000 5.110 9.930 100.705
sngl_unmodeled_v 1 0.050 0.095 10.532
sngl_unmodeled_v 10 0.050 0.070 142.796
sngl_unmodeled_v 100 0.200 0.289 345.918
sngl_unmodeled_v 1000 1.660 3.228 309.789
coinc_sngl 1 0.070 0.099 10.103
coinc_sngl 10 0.100 0.177 56.598
coinc_sngl 100 0.530 0.644 155.375
coinc_sngl 1000 4.630 8.187 122.145
sngl_datasource 1 0.040 0.067 15.004
sngl_datasource 10 0.090 0.098 102.235
sngl_datasource 100 0.320 0.443 225.598
sngl_datasource 1000 2.770 3.441 290.613

Summary: