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: