G
gus
Guest
> George Potemkin [https://community.progress.com/members/georgep12] > BTW, LOB area with RPB 64 is not a good place for the zsaztdl table with 100 byte records. why not? the overhead in a block that contains 64 records consist of the following: data block header 64 bytes record block specific extra header 12 bytes row directory (2 bytes each) 128 bytes create limit 300 bytes per row overhead (~17 bytes each) 1088 bytes subtotal 1592 bytes for an 8192 byte data block, that leaves us with 6600 bytes for data. 64 100 bytes records is 6400. so we waste a litle but not all that much. not terrible either. setting max rows per block to 128 would be slightly better. or not, since rows are not all the same size.
Continue reading...
Continue reading...