ldas-dev Database cit_test Insertion Rates
Test Period June 12 2001 12:19:30
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS metaserver 5.8 Generic_108528-07 sun4u sparc SUNW,Ultra-4
Memory: 4096M real, 3307M free, 154M swap in use, 3187M swap free
LDAS software ldas-0.0.18, 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.000 0.018 54.271
process 10 0.010 0.024 414.559
process 100 0.030 0.065 1533.366
process 1000 0.260 0.544 1838.637
runlist 1 0.000 0.010 98.174
runlist 10 0.010 0.011 893.895
runlist 100 0.010 0.033 3009.148
runlist 1000 0.070 0.231 4333.732
process_params 1 0.030 0.029 34.501
process_params 10 0.020 0.034 293.126
process_params 100 0.040 0.067 1501.975
process_params 1000 0.100 0.334 2989.992
frameset_chanlist 1 0.030 0.033 30.082
frameset_chanlist 10 0.030 0.036 278.334
frameset_chanlist 100 0.050 0.071 1411.492
frameset_chanlist 1000 0.180 0.407 2456.489
frameset_writer 1 0.030 0.033 30.476
frameset_writer 10 0.030 0.034 292.458
frameset_writer 100 0.030 0.073 1377.752
frameset_writer 1000 0.110 0.491 2035.739
segment_definer 1 0.030 0.030 32.992
segment_definer 10 0.020 0.037 271.843
segment_definer 100 0.040 0.080 1256.266
segment_definer 1000 0.120 0.463 2157.921
filter 1 0.030 0.035 28.948
filter 10 0.030 0.040 247.194
filter 100 0.050 0.083 1198.538
filter 1000 0.180 0.523 1910.731
frameset 1 0.030 0.034 29.832
frameset 10 0.030 0.039 253.563
frameset 100 0.040 0.079 1270.180
frameset 1000 0.120 0.479 2088.193
segment 1 0.030 0.030 33.664
segment 10 0.020 0.036 280.411
segment 100 0.030 0.072 1388.831
segment 1000 0.080 0.509 1964.837
filter_params 1 0.020 0.030 32.839
filter_params 10 0.030 0.037 270.059
filter_params 100 0.030 0.071 1402.151
filter_params 1000 0.110 0.443 2259.300
gds_trigger 1 0.040 0.043 23.462
gds_trigger 10 0.040 0.052 192.071
gds_trigger 100 0.060 0.130 768.203
gds_trigger 1000 0.280 0.943 1060.371
sngl_inspiral 1 0.030 0.045 22.470
sngl_inspiral 10 0.040 0.053 187.956
sngl_inspiral 100 0.060 0.124 807.787
sngl_inspiral 1000 0.290 1.035 966.184
sngl_burst 1 0.030 0.035 28.961
sngl_burst 10 0.030 0.041 243.374
sngl_burst 100 0.030 0.089 1120.699
sngl_burst 1000 0.180 0.628 1591.222
sngl_ringdown 1 0.020 0.035 28.794
sngl_ringdown 10 0.030 0.042 237.282
sngl_ringdown 100 0.060 0.099 1007.658
sngl_ringdown 1000 0.200 0.699 1430.902
sngl_unmodeled 1 0.030 0.034 29.165
sngl_unmodeled 10 0.030 0.042 238.141
sngl_unmodeled 100 0.050 0.107 936.032
sngl_unmodeled 1000 0.210 0.867 1152.918
sngl_dperiodic 1 0.030 0.037 26.753
sngl_dperiodic 10 0.040 0.049 202.396
sngl_dperiodic 100 0.050 0.103 974.934
sngl_dperiodic 1000 0.260 0.727 1374.833
multi_inspiral 1 0.040 0.042 23.922
multi_inspiral 10 0.040 0.052 192.745
multi_inspiral 100 0.060 0.130 767.672
multi_inspiral 1000 0.310 1.084 922.509
multi_burst 1 0.030 0.039 25.718
multi_burst 10 0.030 0.050 198.744
multi_burst 100 0.050 0.100 1002.195
multi_burst 1000 0.250 0.667 1499.104
frameset_loc 1 0.010 0.012 85.697
frameset_loc 10 0.010 0.016 606.134
frameset_loc 100 0.010 0.057 1747.549
frameset_loc 1000 0.100 0.464 2155.349
summ_value 1 0.030 0.035 28.391
summ_value 10 0.030 0.042 235.927
summ_value 100 0.040 0.095 1048.801
summ_value 1000 0.160 0.640 1561.497
summ_statistics 1 0.040 0.039 25.787
summ_statistics 10 0.030 0.046 216.371
summ_statistics 100 0.050 0.100 1002.436
summ_statistics 1000 0.180 0.687 1456.147
summ_spectrum 1 0.030 0.040 25.165
summ_spectrum 10 0.030 0.062 161.729
summ_spectrum 100 0.040 0.355 281.717
summ_spectrum 1000 0.240 2.971 336.587
summ_comment 1 0.030 0.038 26.387
summ_comment 10 0.030 0.045 219.867
summ_comment 100 0.050 0.110 910.365
summ_comment 1000 0.220 0.751 1331.613
summ_csd 1 0.030 0.039 25.919
summ_csd 10 0.030 0.061 165.052
summ_csd 100 0.060 0.381 262.305
summ_csd 1000 0.250 2.995 333.890
summ_mime 1 0.020 0.026 38.394
summ_mime 10 0.020 0.050 199.553
summ_mime 100 0.050 0.367 272.409
summ_mime 1000 0.450 3.317 301.477
sngl_transdata 1 0.010 0.021 48.534
sngl_transdata 10 0.020 0.043 233.995
sngl_transdata 100 0.040 0.316 316.486
sngl_transdata 1000 0.300 2.777 360.101
sngl_unmodeled_v 1 0.040 0.035 28.696
sngl_unmodeled_v 10 0.030 0.040 253.120
sngl_unmodeled_v 100 0.040 0.076 1322.454
sngl_unmodeled_v 1000 0.100 0.466 2146.683
sngl_mime 1 0.030 0.037 26.686
sngl_mime 10 0.040 0.060 168.053
sngl_mime 100 0.060 0.349 286.375
sngl_mime 1000 0.370 3.005 332.779
coinc_sngl 1 0.030 0.040 25.171
coinc_sngl 10 0.040 0.064 156.787
coinc_sngl 100 0.090 0.194 516.620
coinc_sngl 1000 0.650 1.802 554.939
sngl_datasource 1 0.030 0.035 28.475
sngl_datasource 10 0.030 0.039 256.253
sngl_datasource 100 0.040 0.072 1396.726
sngl_datasource 1000 0.160 0.442 2264.662

Summary: