ldas-dev Database cit_test Insertion Rates
| Test Period | June 13 2001 17:43:38 | |
|---|---|---|
| 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, 3257M free, 257M swap in use, 3081M 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.018 | 54.401 | process | 10 | 0.000 | 0.023 | 430.775 | process | 100 | 0.040 | 0.070 | 1428.469 | process | 1000 | 0.270 | 0.584 | 1711.239 | runlist | 1 | 0.010 | 0.013 | 77.411 | runlist | 10 | 0.010 | 0.013 | 768.049 | runlist | 100 | 0.010 | 0.031 | 3267.974 | runlist | 1000 | 0.070 | 0.207 | 4819.440 | process_params | 1 | 0.030 | 0.030 | 33.469 | process_params | 10 | 0.020 | 0.033 | 300.120 | process_params | 100 | 0.030 | 0.058 | 1738.375 | process_params | 1000 | 0.100 | 0.320 | 3120.222 | frameset_chanlist | 1 | 0.030 | 0.033 | 29.853 | frameset_chanlist | 10 | 0.030 | 0.039 | 255.846 | frameset_chanlist | 100 | 0.030 | 0.077 | 1304.240 | frameset_chanlist | 1000 | 0.180 | 0.417 | 2400.050 | frameset_writer | 1 | 0.020 | 0.031 | 32.512 | frameset_writer | 10 | 0.030 | 0.035 | 282.103 | frameset_writer | 100 | 0.040 | 0.075 | 1326.260 | frameset_writer | 1000 | 0.110 | 0.485 | 2061.048 | segment_definer | 1 | 0.030 | 0.030 | 33.099 | segment_definer | 10 | 0.030 | 0.036 | 278.652 | segment_definer | 100 | 0.030 | 0.073 | 1372.213 | segment_definer | 1000 | 0.100 | 0.483 | 2069.297 | filter | 1 | 0.030 | 0.035 | 28.721 | filter | 10 | 0.040 | 0.041 | 242.512 | filter | 100 | 0.050 | 0.081 | 1232.787 | filter | 1000 | 0.200 | 0.567 | 1762.680 | frameset | 1 | 0.030 | 0.034 | 29.366 | frameset | 10 | 0.030 | 0.038 | 263.026 | frameset | 100 | 0.040 | 0.077 | 1294.716 | frameset | 1000 | 0.120 | 0.479 | 2088.511 | segment | 1 | 0.020 | 0.031 | 32.623 | segment | 10 | 0.020 | 0.039 | 256.069 | segment | 100 | 0.030 | 0.076 | 1320.237 | segment | 1000 | 0.080 | 0.457 | 2187.810 | filter_params | 1 | 0.020 | 0.030 | 33.254 | filter_params | 10 | 0.020 | 0.037 | 273.905 | filter_params | 100 | 0.040 | 0.071 | 1414.467 | filter_params | 1000 | 0.120 | 0.433 | 2310.835 | gds_trigger | 1 | 0.040 | 0.043 | 23.363 | gds_trigger | 10 | 0.040 | 0.050 | 199.892 | gds_trigger | 100 | 0.050 | 0.131 | 766.166 | gds_trigger | 1000 | 0.290 | 1.017 | 983.284 | sngl_inspiral | 1 | 0.040 | 0.043 | 23.438 | sngl_inspiral | 10 | 0.040 | 0.051 | 194.795 | sngl_inspiral | 100 | 0.050 | 0.148 | 676.320 | sngl_inspiral | 1000 | 0.330 | 1.344 | 744.048 | sngl_burst | 1 | 0.030 | 0.034 | 29.155 | sngl_burst | 10 | 0.030 | 0.042 | 240.923 | sngl_burst | 100 | 0.040 | 0.089 | 1117.356 | sngl_burst | 1000 | 0.240 | 0.724 | 1381.223 | sngl_ringdown | 1 | 0.030 | 0.035 | 28.640 | sngl_ringdown | 10 | 0.030 | 0.043 | 230.054 | sngl_ringdown | 100 | 0.040 | 0.095 | 1052.100 | sngl_ringdown | 1000 | 0.230 | 0.649 | 1540.457 | sngl_unmodeled | 1 | 0.030 | 0.035 | 28.329 | sngl_unmodeled | 10 | 0.030 | 0.040 | 250.721 | sngl_unmodeled | 100 | 0.050 | 0.117 | 857.523 | sngl_unmodeled | 1000 | 0.230 | 0.897 | 1114.553 | sngl_dperiodic | 1 | 0.030 | 0.037 | 26.742 | sngl_dperiodic | 10 | 0.040 | 0.046 | 218.727 | sngl_dperiodic | 100 | 0.050 | 0.101 | 985.911 | sngl_dperiodic | 1000 | 0.270 | 0.816 | 1226.057 | multi_inspiral | 1 | 0.040 | 0.043 | 23.391 | multi_inspiral | 10 | 0.040 | 0.052 | 191.446 | multi_inspiral | 100 | 0.060 | 0.136 | 734.883 | multi_inspiral | 1000 | 0.330 | 1.166 | 857.633 | multi_burst | 1 | 0.030 | 0.040 | 25.030 | multi_burst | 10 | 0.040 | 0.047 | 210.793 | multi_burst | 100 | 0.060 | 0.098 | 1020.856 | multi_burst | 1000 | 0.250 | 0.658 | 1519.424 | frameset_loc | 1 | 0.010 | 0.036 | 27.721 | frameset_loc | 10 | 0.010 | 0.016 | 640.123 | frameset_loc | 100 | 0.020 | 0.056 | 1796.558 | frameset_loc | 1000 | 0.110 | 0.481 | 2080.572 | summ_value | 1 | 0.030 | 0.053 | 18.875 | summ_value | 10 | 0.030 | 0.043 | 232.493 | summ_value | 100 | 0.050 | 0.091 | 1096.071 | summ_value | 1000 | 0.160 | 0.633 | 1578.943 | summ_statistics | 1 | 0.030 | 0.060 | 16.609 | summ_statistics | 10 | 0.040 | 0.047 | 214.648 | summ_statistics | 100 | 0.050 | 0.098 | 1017.501 | summ_statistics | 1000 | 0.180 | 0.684 | 1461.258 | summ_spectrum | 1 | 0.030 | 0.058 | 17.152 | summ_spectrum | 10 | 0.030 | 0.066 | 150.473 | summ_spectrum | 100 | 0.060 | 0.383 | 261.430 | summ_spectrum | 1000 | 0.240 | 3.031 | 329.924 | summ_comment | 1 | 0.030 | 0.057 | 17.648 | summ_comment | 10 | 0.040 | 0.047 | 214.966 | summ_comment | 100 | 0.050 | 0.107 | 936.373 | summ_comment | 1000 | 0.250 | 0.835 | 1197.763 | summ_csd | 1 | 0.030 | 0.057 | 17.477 | summ_csd | 10 | 0.040 | 0.061 | 163.808 | summ_csd | 100 | 0.050 | 0.362 | 276.575 | summ_csd | 1000 | 0.250 | 3.061 | 326.691 | summ_mime | 1 | 0.010 | 0.050 | 20.099 | summ_mime | 10 | 0.020 | 0.053 | 189.494 | summ_mime | 100 | 0.050 | 0.361 | 276.933 | summ_mime | 1000 | 0.530 | 3.379 | 295.946 | sngl_transdata | 1 | 0.010 | 0.035 | 28.739 | sngl_transdata | 10 | 0.010 | 0.043 | 233.405 | sngl_transdata | 100 | 0.040 | 0.318 | 314.337 | sngl_transdata | 1000 | 0.290 | 2.740 | 364.964 | sngl_unmodeled_v | 1 | 0.020 | 0.045 | 22.055 | sngl_unmodeled_v | 10 | 0.020 | 0.035 | 289.176 | sngl_unmodeled_v | 100 | 0.040 | 0.072 | 1395.089 | sngl_unmodeled_v | 1000 | 0.100 | 0.412 | 2427.173 | sngl_mime | 1 | 0.030 | 0.052 | 19.149 | sngl_mime | 10 | 0.040 | 0.058 | 172.079 | sngl_mime | 100 | 0.070 | 0.352 | 284.098 | sngl_mime | 1000 | 0.420 | 3.075 | 325.203 | coinc_sngl | 1 | 0.040 | 0.097 | 10.303 | coinc_sngl | 10 | 0.040 | 0.055 | 181.422 | coinc_sngl | 100 | 0.100 | 0.201 | 498.427 | coinc_sngl | 1000 | 0.580 | 1.771 | 564.653 | sngl_datasource | 1 | 0.030 | 0.045 | 22.307 | sngl_datasource | 10 | 0.030 | 0.040 | 250.840 | sngl_datasource | 100 | 0.040 | 0.074 | 1350.020 | sngl_datasource | 1000 | 0.150 | 0.472 | 2118.339 |
|---|
Summary: