G
George Potemkin
Guest
I run some tests with the scatter factor: Progress V10.2B d "Table Area":7,8;8 . I created 15 records. They used 2 blocks: first one stores 7 records + template record, second block stores 8 records. Scatter factor was 1.0. Then I deleted a half of the records (if tbl.i mod 2 eq 0 then delete tbl). Scatter factor changed to 1.3. Note that EXP(10, 0.3) = 2. In other words, the scatter factor is still 1 + LOG(Ratio, 10). The record size does not matter. I tried the mean rec size 19 bytes as well as 471 bytes. Also I removed the recid holders, so two blocks stored only 4 + 1 records and 4 records. Then I deleted all records except one in each block (if tbl.i ne 1 and tbl.i ne 9 then delete tbl). Scatter factor was not changed, it's still equal 1.3. The record size does not matter again. It looks like the scatter factor does not work as a block packing factor. Regards, George
Continue reading...
Continue reading...