ldas-dev Database ldas_tst Insertion Rates
Test Period November 07 2001 19:54:52
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, 3112M free, 310M swap in use, 2949M swap free
LDAS software ldas-0.0.22, 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.020 0.037 27.173
process 10 0.020 0.030 334.829
process 100 0.050 0.122 817.314
process 1000 0.350 0.815 1227.316
runlist 1 0.000 0.015 67.686
runlist 10 0.000 0.013 743.771
runlist 100 0.010 0.028 3591.438
runlist 1000 0.070 0.229 4362.488
process_params 1 0.030 0.026 38.322
process_params 10 0.020 0.031 317.571
process_params 100 0.030 0.056 1776.167
process_params 1000 0.110 0.413 2423.990
frameset_chanlist 1 0.020 0.047 21.371
frameset_chanlist 10 0.020 0.037 272.398
frameset_chanlist 100 0.020 0.079 1264.606
frameset_chanlist 1000 0.220 0.493 2029.867
frameset_writer 1 0.010 0.025 40.479
frameset_writer 10 0.000 0.017 590.598
frameset_writer 100 0.020 0.074 1358.530
frameset_writer 1000 0.100 0.595 1681.908
segment_definer 1 0.010 0.025 40.035
segment_definer 10 0.010 0.019 532.652
segment_definer 100 0.010 0.083 1209.965
segment_definer 1000 0.100 0.560 1784.898
filter 1 0.010 0.029 35.031
filter 10 0.010 0.023 427.332
filter 100 0.040 0.070 1419.708
filter 1000 0.240 0.572 1749.111
frameset 1 0.020 0.035 28.798
frameset 10 0.010 0.024 413.377
frameset 100 0.030 0.082 1215.185
frameset 1000 0.120 0.537 1863.457
segment 1 0.010 0.027 36.937
segment 10 0.010 0.019 535.647
segment 100 0.010 0.056 1786.640
segment 1000 0.060 0.522 1914.158
filter_params 1 0.020 0.050 19.849
filter_params 10 0.010 0.021 471.076
filter_params 100 0.020 0.056 1793.979
filter_params 1000 0.110 0.547 1829.080
gds_trigger 1 0.020 0.042 23.533
gds_trigger 10 0.020 0.033 306.288
gds_trigger 100 0.040 0.126 791.534
gds_trigger 1000 0.320 1.175 851.064
sngl_inspiral 1 0.020 0.050 20.075
sngl_inspiral 10 0.030 0.042 240.587
sngl_inspiral 100 0.060 0.131 762.759
sngl_inspiral 1000 0.330 1.219 820.345
sngl_burst 1 0.020 0.052 19.254
sngl_burst 10 0.020 0.030 336.632
sngl_burst 100 0.040 0.087 1148.132
sngl_burst 1000 0.300 0.823 1214.711
sngl_ringdown 1 0.010 0.038 26.357
sngl_ringdown 10 0.010 0.030 338.009
sngl_ringdown 100 0.040 0.089 1126.773
sngl_ringdown 1000 0.260 0.711 1406.767
sngl_unmodeled 1 0.010 0.056 17.784
sngl_unmodeled 10 0.030 0.049 202.094
sngl_unmodeled 100 0.040 0.106 946.316
sngl_unmodeled 1000 0.270 1.101 908.265
sngl_dperiodic 1 0.030 0.059 16.809
sngl_dperiodic 10 0.040 0.033 304.025
sngl_dperiodic 100 0.050 0.095 1048.691
sngl_dperiodic 1000 0.280 0.793 1261.503
multi_inspiral 1 0.030 0.053 19.047
multi_inspiral 10 0.030 0.043 231.685
multi_inspiral 100 0.060 0.264 379.200
multi_inspiral 1000 0.360 1.211 825.764
multi_burst 1 0.030 0.040 24.697
multi_burst 10 0.040 0.048 210.155
multi_burst 100 0.050 0.105 956.416
multi_burst 1000 0.270 0.748 1336.302
frameset_loc 1 0.010 0.020 49.176
frameset_loc 10 0.010 0.016 638.081
frameset_loc 100 0.020 0.066 1509.776
frameset_loc 1000 0.100 0.538 1858.684
summ_value 1 0.010 0.037 27.057
summ_value 10 0.020 0.025 396.637
summ_value 100 0.040 0.119 840.979
summ_value 1000 0.150 0.641 1560.523
summ_statistics 1 0.020 0.045 22.353
summ_statistics 10 0.020 0.030 331.851
summ_statistics 100 0.030 0.112 892.244
summ_statistics 1000 0.170 0.675 1482.026
summ_spectrum 1 0.010 0.057 17.607
summ_spectrum 10 0.010 0.074 134.474
summ_spectrum 100 0.040 0.447 223.663
summ_spectrum 1000 0.420 3.944 253.550
summ_comment 1 0.020 0.040 25.012
summ_comment 10 0.020 0.030 329.598
summ_comment 100 0.040 0.131 762.858
summ_comment 1000 0.280 0.904 1106.626
summ_csd 1 0.010 0.043 23.102
summ_csd 10 0.020 0.045 224.356
summ_csd 100 0.040 0.366 273.137
summ_csd 1000 0.300 3.195 312.989
summ_mime 1 0.020 0.048 20.696
summ_mime 10 0.020 0.053 189.854
summ_mime 100 0.070 0.389 257.317
summ_mime 1000 0.450 3.431 291.460
sngl_unmodeled_v 1 0.010 0.029 34.478
sngl_unmodeled_v 10 0.010 0.022 456.475
sngl_unmodeled_v 100 0.010 0.071 1413.448
sngl_unmodeled_v 1000 0.080 0.431 2320.498
coinc_sngl 1 0.050 0.119 8.392
coinc_sngl 10 0.050 0.095 105.412
coinc_sngl 100 0.110 0.243 412.317
coinc_sngl 1000 0.750 2.260 442.478
sngl_transdata 1 0.020 0.039 25.792
sngl_transdata 10 0.020 0.041 243.043
sngl_transdata 100 0.040 0.336 297.599
sngl_transdata 1000 0.310 2.799 357.270
sngl_mime 1 0.020 0.038 26.219
sngl_mime 10 0.010 0.047 211.278
sngl_mime 100 0.060 0.369 271.217
sngl_mime 1000 0.420 3.182 314.268
sngl_datasource 1 0.020 0.044 22.646
sngl_datasource 10 0.030 0.038 261.862
sngl_datasource 100 0.030 0.082 1225.490
sngl_datasource 1000 0.150 0.472 2119.569

Summary: