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

[ahmed_seedat]

I created test DB using 8k. Below is the results. Fri Mar 8 09:49:01 2019 [2019/03/08@09:49:01.901+0200] P-10638 T-140587748644672 I DBUTIL : (451) Truncate bi session begin for root on /dev/pts/5. [2019/03/08@09:49:01.901+0200] P-10638 T-140587748644672 I DBUTIL : (15321) Before Image Log Initialization at block 0 offset 1004. [2019/03/08@09:49:01.905+0200] P-10638 T-140587748644672 I DBUTIL : (7129) Usr 0 set name to root. [2019/03/08@09:49:01.906+0200] P-10638 T-140587748644672 I DBUTIL : (1620) Before-image cluster size set to 16384 kb. [2019/03/08@09:49:01.910+0200] P-10638 T-140587748644672 I DBUTIL : (123) .bi file truncated. [2019/03/08@09:49:01.911+0200] P-10638 T-140587748644672 I DBUTIL : (15109) At Database close the number of live transactions is 0. [2019/03/08@09:49:01.911+0200] P-10638 T-140587748644672 I DBUTIL : (15743) Before Image Log Completion at Block 0 Offset 1004. [2019/03/08@09:49:01.926+0200] P-10638 T-140587748644672 I DBUTIL : (334) Truncate bi session end. Fri Mar 8 09:49:25 2019 [2019/03/08@09:49:25.142+0200] P-11384 T-139803562612544 I DBUTIL : (451) Bigrow session begin for root on /dev/pts/5. [2019/03/08@09:49:25.142+0200] P-11384 T-139803562612544 I DBUTIL : (15321) Before Image Log Initialization at block 0 offset 0. [2019/03/08@09:49:37.200+0200] P-11384 T-139803562612544 I DBUTIL : (7129) Usr 0 set name to root. [2019/03/08@09:49:37.200+0200] P-11384 T-139803562612544 I DBUTIL : (6600) Adding 2 clusters to the Before Image file. [2019/03/08@09:49:43.516+0200] P-11384 T-139803562612544 I DBUTIL : (15109) At Database close the number of live transactions is 0. [2019/03/08@09:49:43.516+0200] P-11384 T-139803562612544 I DBUTIL : (15743) Before Image Log Completion at Block 0 Offset 235. [2019/03/08@09:49:43.529+0200] P-11384 T-139803562612544 I DBUTIL : (334) Bigrow session end. [root@hssmiplive-ind:tmp]# l total 102288 drwxr-xr-x 2 root root 4096 Mar 8 09:49 . drwxr-xr-x 9 root root 4096 Mar 8 06:20 .. -rw-r--r-- 1 root root 100794368 Mar 8 09:49 test.b1 -rw-r--r-- 1 root root 3276800 Mar 8 09:49 test.d1 -rw-r--r-- 1 root root 655360 Mar 8 09:49 test.db -rw-r--r-- 1 root root 3502 Mar 8 09:49 test.lg -rw-r--r-- 1 root root 33 Mar 8 09:48 test.st

Continue reading...