G
George Potemkin
Guest
> I ran dbanalys The output's header should report the line: Options: chanalys ixanalys tabanalys The "chanalys" option means that the output should have the "* CHAIN ANALYSIS" segments (msg ## 3873 & 3892). These messages exist at least since Progress V6. > interested to see that multiple assign statements would increase the update count in _tablestat even if within a single transaction Most likely a first assign statement creates a record with the size just a bit larger than the template record that in its turn can be close to the minimal record size reported by tabanalys. Second assign statement changes the record's size to its final value, let's say to an average record size reported by tabanalys. So you can estimate the size of the record's expansions as AverageRecSize - MinRecSzie. Only a record that uses a last slot in a block has a chance to become fragmeneted. If it's your case than (Fragments - Records) / Records ration should be close to 1 / RealRPB where RealRPB ~ BlockSize / AverageRecSize. This approach will work only for those tables where _Table-update / _Table-create ration is aproximately 1:1.
Continue reading...
Continue reading...