ldas-dev Database cit_1 Insertion Rates
Test Period December 14 2001 16:56:29
Input data Ilwd with dimensions 1,10,100,1000
Platform SunOS ldas-dev 5.8 Generic_108528-07 sun4u sparc SUNW,Ultra-4
Memory: 4096M real, 2894M free, 483M swap in use, 2630M swap free
LDAS software ldas-0.0.23, 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.090 1.257 0.796
process 10 0.030 0.635 15.758
process 100 0.130 1.695 58.997
process 1000 0.340 1.650 606.061
runlist 1 0.000 0.649 1.540
runlist 10 0.010 0.637 15.706
runlist 100 0.010 0.379 263.773
runlist 1000 0.070 0.272 3682.333
process_params 1 0.110 1.605 0.623
process_params 10 0.020 0.306 32.714
process_params 100 0.100 1.575 63.492
process_params 1000 0.100 0.622 1608.180
frameset_chanlist 1 0.030 0.582 1.717
frameset_chanlist 10 0.110 1.518 6.588
frameset_chanlist 100 0.050 1.061 94.251
frameset_chanlist 1000 0.230 0.653 1532.447
frameset_writer 1 0.030 0.635 1.575
frameset_writer 10 0.100 1.242 8.052
frameset_writer 100 0.050 1.182 84.602
frameset_writer 1000 0.130 1.064 939.850
segment_definer 1 0.100 1.342 0.745
segment_definer 10 0.020 0.661 15.127
segment_definer 100 0.690 1.905 52.493
segment_definer 1000 1.160 2.181 458.505
filter 1 0.050 0.639 1.566
filter 10 0.060 1.200 8.333
filter 100 0.060 0.357 280.227
filter 1000 0.280 0.615 1625.511
frameset 1 0.020 0.571 1.751
frameset 10 0.110 1.315 7.605
frameset 100 0.210 1.525 65.574
frameset 1000 0.210 1.272 786.164
segment 1 0.100 1.633 0.612
segment 10 0.020 0.630 15.883
segment 100 0.040 0.654 152.842
segment 1000 0.820 2.070 483.092
filter_params 1 0.050 0.605 1.653
filter_params 10 0.110 1.535 6.515
filter_params 100 0.100 1.836 54.466
filter_params 1000 0.230 2.361 423.549
gds_trigger 1 0.090 1.576 0.635
gds_trigger 10 0.040 0.645 15.498
gds_trigger 100 0.080 1.073 93.197
gds_trigger 1000 0.350 1.622 616.523
sngl_inspiral 1 0.040 0.650 1.538
sngl_inspiral 10 0.110 1.541 6.489
sngl_inspiral 100 0.160 1.776 56.306
sngl_inspiral 1000 0.450 2.106 474.834
sngl_burst 1 0.130 1.361 0.735
sngl_burst 10 0.040 0.640 15.632
sngl_burst 100 0.060 0.381 262.709
sngl_burst 1000 0.990 2.089 478.698
sngl_ringdown 1 0.030 0.637 1.569
sngl_ringdown 10 0.120 1.598 6.258
sngl_ringdown 100 0.130 1.696 58.962
sngl_ringdown 1000 0.290 1.638 610.501
sngl_unmodeled 1 0.100 1.631 0.613
sngl_unmodeled 10 0.050 0.618 16.173
sngl_unmodeled 100 0.060 0.636 157.257
sngl_unmodeled 1000 0.310 1.679 595.593
sngl_dperiodic 1 0.040 0.592 1.689
sngl_dperiodic 10 0.120 1.301 7.686
sngl_dperiodic 100 0.270 1.740 57.471
sngl_dperiodic 1000 0.420 1.361 734.754
multi_inspiral 1 0.120 1.590 0.629
multi_inspiral 10 0.050 0.646 15.485
multi_inspiral 100 0.080 0.631 158.580
multi_inspiral 1000 0.400 1.667 599.880
multi_burst 1 0.040 0.621 1.609
multi_burst 10 0.030 0.632 15.819
multi_burst 100 0.060 0.625 159.886
multi_burst 1000 0.310 1.613 619.963
frameset_loc 1 0.080 1.327 0.754
frameset_loc 10 0.070 1.578 6.337
frameset_loc 100 0.010 0.322 310.266
frameset_loc 1000 0.120 0.612 1632.994
summ_value 1 0.030 0.633 1.580
summ_value 10 0.030 0.626 15.981
summ_value 100 0.180 1.743 57.372
summ_value 1000 0.170 0.634 1576.104
summ_statistics 1 0.120 1.619 0.618
summ_statistics 10 0.120 1.610 6.211
summ_statistics 100 0.040 0.631 158.494
summ_statistics 1000 0.190 1.612 620.347
summ_spectrum 1 0.030 0.577 1.732
summ_spectrum 10 0.030 0.282 35.496
summ_spectrum 100 0.140 1.809 55.279
summ_spectrum 1000 1.230 4.374 228.624
summ_comment 1 0.120 1.559 0.641
summ_comment 10 0.100 1.581 6.325
summ_comment 100 0.060 0.625 159.915
summ_comment 1000 0.330 1.358 736.377
summ_csd 1 0.030 0.651 1.535
summ_csd 10 0.030 0.628 15.914
summ_csd 100 0.070 0.616 162.229
summ_csd 1000 0.820 4.207 237.699
summ_mime 1 0.110 1.577 0.634
summ_mime 10 0.100 1.614 6.196
summ_mime 100 0.160 1.686 59.312
summ_mime 1000 0.550 4.117 242.895
sngl_unmodeled_v 1 0.020 0.580 1.725
sngl_unmodeled_v 10 0.030 0.634 15.766
sngl_unmodeled_v 100 0.040 0.356 281.076
sngl_unmodeled_v 1000 0.110 0.643 1554.900
coinc_sngl 1 0.070 0.633 1.581
coinc_sngl 10 0.070 0.626 15.978
coinc_sngl 100 0.140 1.113 89.847
coinc_sngl 1000 0.860 2.470 404.858
sngl_transdata 1 0.130 1.357 0.737
sngl_transdata 10 0.100 1.321 7.570
sngl_transdata 100 0.060 0.648 154.279
sngl_transdata 1000 0.470 3.575 279.720
sngl_mime 1 0.030 0.640 1.563
sngl_mime 10 0.030 0.631 15.851
sngl_mime 100 0.150 1.776 56.306
sngl_mime 1000 0.590 4.465 223.964
sngl_datasource 1 0.040 0.585 1.709
sngl_datasource 10 0.030 1.037 9.643
sngl_datasource 100 0.040 1.042 95.969
sngl_datasource 1000 0.470 1.042 959.693

Summary: This is a new test, different from all other insertion tests which ran on a standalone metadataAPI. This is now the new baseline for insertion tests.