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: