ldas-wa Database lho_test Insertion Rates
| Test Period | June 13 2001 19:04:57 | |
|---|---|---|
| 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, 3419M free, 198M swap in use, 3165M 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.010 | 0.019 | 52.529 | process | 10 | 0.020 | 0.025 | 394.353 | process | 100 | 0.030 | 0.062 | 1611.344 | process | 1000 | 0.290 | 0.702 | 1423.609 | runlist | 1 | 0.000 | 0.011 | 93.458 | runlist | 10 | 0.010 | 0.014 | 705.667 | runlist | 100 | 0.020 | 0.033 | 3075.220 | runlist | 1000 | 0.060 | 0.223 | 4490.184 | process_params | 1 | 0.030 | 0.040 | 25.255 | process_params | 10 | 0.020 | 0.032 | 310.965 | process_params | 100 | 0.040 | 0.065 | 1539.670 | process_params | 1000 | 0.100 | 0.330 | 3032.122 | frameset_chanlist | 1 | 0.020 | 0.045 | 22.054 | frameset_chanlist | 10 | 0.020 | 0.041 | 241.115 | frameset_chanlist | 100 | 0.050 | 0.093 | 1075.789 | frameset_chanlist | 1000 | 0.180 | 0.477 | 2095.219 | frameset_writer | 1 | 0.020 | 0.043 | 23.015 | frameset_writer | 10 | 0.030 | 0.037 | 268.687 | frameset_writer | 100 | 0.040 | 0.078 | 1278.478 | frameset_writer | 1000 | 0.110 | 0.487 | 2052.196 | segment_definer | 1 | 0.030 | 0.040 | 24.794 | segment_definer | 10 | 0.030 | 0.036 | 280.725 | segment_definer | 100 | 0.050 | 0.083 | 1199.616 | segment_definer | 1000 | 0.100 | 0.472 | 2118.783 | filter | 1 | 0.030 | 0.045 | 22.158 | filter | 10 | 0.030 | 0.040 | 247.359 | filter | 100 | 0.040 | 0.080 | 1256.266 | filter | 1000 | 0.210 | 0.594 | 1684.307 | frameset | 1 | 0.020 | 0.049 | 20.504 | frameset | 10 | 0.030 | 0.036 | 275.976 | frameset | 100 | 0.040 | 0.075 | 1335.845 | frameset | 1000 | 0.140 | 0.550 | 1818.856 | segment | 1 | 0.030 | 0.041 | 24.152 | segment | 10 | 0.020 | 0.034 | 294.750 | segment | 100 | 0.030 | 0.073 | 1360.692 | segment | 1000 | 0.080 | 0.505 | 1980.649 | filter_params | 1 | 0.030 | 0.043 | 23.104 | filter_params | 10 | 0.030 | 0.037 | 272.948 | filter_params | 100 | 0.030 | 0.080 | 1255.619 | filter_params | 1000 | 0.120 | 0.453 | 2206.439 | gds_trigger | 1 | 0.040 | 0.063 | 15.937 | gds_trigger | 10 | 0.040 | 0.054 | 183.759 | gds_trigger | 100 | 0.050 | 0.125 | 801.892 | gds_trigger | 1000 | 0.260 | 0.967 | 1034.551 | sngl_inspiral | 1 | 0.040 | 0.061 | 16.372 | sngl_inspiral | 10 | 0.040 | 0.050 | 199.752 | sngl_inspiral | 100 | 0.070 | 0.133 | 749.839 | sngl_inspiral | 1000 | 0.270 | 1.050 | 952.381 | sngl_burst | 1 | 0.030 | 0.048 | 20.793 | sngl_burst | 10 | 0.030 | 0.046 | 217.988 | sngl_burst | 100 | 0.040 | 0.096 | 1037.237 | sngl_burst | 1000 | 0.190 | 0.702 | 1423.751 | sngl_ringdown | 1 | 0.030 | 0.050 | 19.933 | sngl_ringdown | 10 | 0.040 | 0.042 | 236.412 | sngl_ringdown | 100 | 0.040 | 0.097 | 1027.781 | sngl_ringdown | 1000 | 0.220 | 0.703 | 1422.354 | sngl_unmodeled | 1 | 0.030 | 0.049 | 20.450 | sngl_unmodeled | 10 | 0.030 | 0.043 | 235.222 | sngl_unmodeled | 100 | 0.040 | 0.105 | 951.402 | sngl_unmodeled | 1000 | 0.240 | 0.864 | 1157.561 | sngl_dperiodic | 1 | 0.030 | 0.053 | 18.842 | sngl_dperiodic | 10 | 0.040 | 0.045 | 223.404 | sngl_dperiodic | 100 | 0.050 | 0.109 | 920.293 | sngl_dperiodic | 1000 | 0.240 | 0.753 | 1327.417 | multi_inspiral | 1 | 0.030 | 0.062 | 16.148 | multi_inspiral | 10 | 0.040 | 0.051 | 195.446 | multi_inspiral | 100 | 0.070 | 0.135 | 741.191 | multi_inspiral | 1000 | 0.280 | 1.110 | 900.901 | multi_burst | 1 | 0.030 | 0.057 | 17.475 | multi_burst | 10 | 0.040 | 0.046 | 216.563 | multi_burst | 100 | 0.050 | 0.105 | 955.146 | multi_burst | 1000 | 0.240 | 0.662 | 1511.645 | frameset_loc | 1 | 0.010 | 0.022 | 45.554 | frameset_loc | 10 | 0.020 | 0.017 | 593.542 | frameset_loc | 100 | 0.020 | 0.054 | 1858.736 | frameset_loc | 1000 | 0.100 | 0.471 | 2121.602 | summ_value | 1 | 0.030 | 0.054 | 18.568 | summ_value | 10 | 0.030 | 0.043 | 235.250 | summ_value | 100 | 0.050 | 0.100 | 1000.200 | summ_value | 1000 | 0.160 | 0.633 | 1579.457 | summ_statistics | 1 | 0.030 | 0.060 | 16.623 | summ_statistics | 10 | 0.030 | 0.047 | 210.988 | summ_statistics | 100 | 0.050 | 0.098 | 1024.947 | summ_statistics | 1000 | 0.180 | 0.687 | 1454.924 | summ_spectrum | 1 | 0.030 | 0.058 | 17.218 | summ_spectrum | 10 | 0.030 | 0.057 | 175.673 | summ_spectrum | 100 | 0.060 | 0.352 | 283.749 | summ_spectrum | 1000 | 0.250 | 3.025 | 330.579 | summ_comment | 1 | 0.030 | 0.056 | 17.736 | summ_comment | 10 | 0.030 | 0.046 | 217.103 | summ_comment | 100 | 0.050 | 0.104 | 960.809 | summ_comment | 1000 | 0.250 | 0.789 | 1268.205 | summ_csd | 1 | 0.030 | 0.057 | 17.583 | summ_csd | 10 | 0.030 | 0.060 | 167.062 | summ_csd | 100 | 0.050 | 0.359 | 278.177 | summ_csd | 1000 | 0.260 | 3.168 | 315.657 | summ_mime | 1 | 0.020 | 0.046 | 21.899 | summ_mime | 10 | 0.010 | 0.050 | 201.361 | summ_mime | 100 | 0.050 | 0.365 | 273.790 | summ_mime | 1000 | 0.540 | 3.372 | 296.560 | sngl_transdata | 1 | 0.000 | 0.034 | 29.452 | sngl_transdata | 10 | 0.010 | 0.041 | 241.774 | sngl_transdata | 100 | 0.050 | 0.319 | 313.755 | sngl_transdata | 1000 | 0.300 | 2.774 | 360.490 | sngl_unmodeled_v | 1 | 0.030 | 0.048 | 20.986 | sngl_unmodeled_v | 10 | 0.020 | 0.037 | 270.168 | sngl_unmodeled_v | 100 | 0.030 | 0.073 | 1379.044 | sngl_unmodeled_v | 1000 | 0.100 | 0.427 | 2341.679 | sngl_mime | 1 | 0.030 | 0.050 | 19.998 | sngl_mime | 10 | 0.030 | 0.060 | 166.731 | sngl_mime | 100 | 0.070 | 0.354 | 282.375 | sngl_mime | 1000 | 0.390 | 3.031 | 329.924 | coinc_sngl | 1 | 0.030 | 0.104 | 9.591 | coinc_sngl | 10 | 0.040 | 0.058 | 173.874 | coinc_sngl | 100 | 0.070 | 0.214 | 467.996 | coinc_sngl | 1000 | 0.650 | 1.962 | 509.684 | sngl_datasource | 1 | 0.030 | 0.048 | 21.022 | sngl_datasource | 10 | 0.030 | 0.039 | 254.680 | sngl_datasource | 100 | 0.040 | 0.074 | 1355.454 | sngl_datasource | 1000 | 0.140 | 0.455 | 2198.546 |
|---|
Summary: