[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Binary Load - Super Slow on 11.7.2

[George Potemkin]

Regarding idxbuild. Here is the results of rather random tests run by a customer of us. Table size = 982.5G (1.3T with indexes) 17073.806 sec 04:44:33.806 -TMB 256 -TF 80 -B 512 -datascanthreads 128 -mergethreads 32 17110.734 sec 04:45:10.734 -TMB 256 -TF 80 -B 5120 -datascanthreads 96 -mergethreads 8 17133.188 sec 04:45:33.188 -TMB 256 -TF 80 -B 512 -datascanthreads 128 -mergethreads 16 17134.440 sec 04:45:34.440 -TMB 256 -TF 80 -B 512 -datascanthreads 96 -mergethreads 8 17229.221 sec 04:47:09.221 -TMB 256 -TF 40 -B 512 -datascanthreads 64 -mergethreads 8 17244.425 sec 04:47:24.425 -TMB 256 -TF 80 -B 512 -datascanthreads 128 -mergethreads 8 17419.778 sec 04:50:19.778 -TMB 256 -TF 80 -B 512 -datascanthreads 96 -mergethreads 4 17419.839 sec 04:50:19.839 -TMB 256 -TF 40 -B 512 -datascanthreads 128 -mergethreads 8 17503.518 sec 04:51:43.518 -TMB 1024 -TF 80 -B 512 -datascanthreads 128 -mergethreads 16 17965.673 sec 04:59:25.673 -TMB 256 -TF 40 -B 512 -datascanthreads 32 -mergethreads 8 19762.750 sec 05:29:22.750 -TMB 256 -TF 40 -B 512 -datascanthreads 16 -mergethreads 8 19986.706 sec 05:33:06.706 -TMB 256 -TF 40 -B 512 -datascanthreads 16 -mergethreads 4 22282.903 sec 06:11:22.903 -TMB 256 -TF 80 -B 512 -datascanthreads 8 -mergethreads 4 23180.969 sec 06:26:20.969 -TMB 256 -TF 40 -B 512 -datascanthreads 8 -mergethreads 4 28684.978 sec 07:58:04.978 -TMB 256 -TF 80 -B 512 -datascanthreads 4 -mergethreads 2 29606.891 sec 08:13:26.891 -TMB 256 -TF 40 -B 512 -datascanthreads 4 -mergethreads 2

Continue reading...